Some useful scripts - Part I

Hi All,

This is neto from Brazil

How are you?

Some useful scripts:

1) Profile to change ORACLE_SID

.bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

function sid {
export ORACLE_SID=$1
}

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export ORACLE_BASE=/oracle/app
export ORACLE_HOME=$ORACLE_BASE/product/11g
export ORACLE_SID=db
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
PS1='[\u@\h][${ORACLE_SID}][\w]\$ '
unset USERNAME

As we can see above, the function sid can be used as:

[oracle@mickey][db][~]$ echo $ORACLE_SID
db
[oracle@mickey][db][~]$ sid prod
[oracle@mickey][prod][~]$ echo $ORACLE_SID
prod

All the best,

neto
NetApp - I love this company!

Comments

[Elcio Nakashima]

Hi Neto, it´s Elcio from Servix. I wrote an article in portuguese about NetApp and database backups, and I took the liberty of using the SnapManager video you uploaded to Youtube.
Check it out and tell me what you think: http://tisimples.wordpress.com/2009/03/26/evolucao-do-backup-de-banco-de-dados/

[neto from Brazil]

Hi Elcio,

This is neto from Brazil

How are you?

Congratulations! Your post is really very good!!!

Keep up the good work!

I'm very honored with the reference on your blog.

Please let me know if you need anything help.

All the best,

neto
NetApp - I love this Family!