Single bash profile with multiple DB option

Shrikant's Blog

There are times when we have more than 1 database on a single servers. So setting OS profile for oracle environment becomes complicated. Like how to set SID or oracle home for all Databases.

A Solution can be is creating a separate OS user for different database or can go with below statement. Editing oracle .profile in /home/oracle.

Below showing 5 different SID with 4 different versions of database,,,, We can see there are two database DB4 and DB5 with same oracle version, so even in this case we need to have 2 different option 4 and 5 as the SID are different.

cat .profile PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:. export PATH if [ -s "$MAIL" ]           # This is at Shell startup.  In normal then echo "$MAILMSG"        # operation, the Shell checks fi                          # periodically. echo " " echo " " echo "            ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~" echo "                                   Database options"…

View original post 216 more words


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s