Printable View
Hello Everyone,
I need some opinions with some logical reasons behind them.
I have two versions or Oracle on the same Unix Server. Is it better to have two users (OraVer#1, OraVer#2) which each have there own environments when signing on which is automatically sourced. OR Is it better to have only one Oracle user on the box and source their environment everytime you log on? Is either way a standard?
Thanks in advance
Kathy
Better is a relative term.
Better for me is one user and two different $ORACLE_HOME's. This way, when I upgrade from version x to version y I don't have to worry about file permissions in my data directories. In order to get the right environment, I use the oraenv script (coraenv in /bin/csh).
We use 'switch_home' OR 'select_sid' for our DBA GROUP management server having all the versions from 734 to 817 for testing purposes.
Here you go:
server1% more switch_home
# @(#)cshrc 1.11 89/11/29 SMI
umask 022
setenv ORAENV_ASK NO
#
echo " 1. LLLL (Oracle 7.3.4)"
echo " 2. MMMM (Oracle 7.3.4)"
echo " 3. PPPP (Oracle 8.0.5)"
echo " 4. QQQQ (Oracle 8.0.5)"
echo " 5. RRRR (Oracle 8.1.5)"
echo " 6. SSSS (Oracle 8.0.5)"
echo " "
echo -n "Please select by number <6> : "
set ans = $<
if ( $ans == "1" ) then
setenv ORACLE_SID LLLL
source /usr/bin/coraenv
else if ( $ans == "2" ) then
setenv ORACLE_SID MMMM
source /usr/bin/coraenv
else if ( $ans == "3" ) then
setenv ORACLE_SID PPPP
source /usr/bin/coraenv
else if ( $ans == "4" ) then
setenv ORACLE_SID QQQQ
source /usr/bin/coraenv
else if ( $ans == "5" ) then
setenv ORACLE_SID RRRR
source /usr/bin/coraenv
else if ( $ans == "6" ) then
setenv ORACLE_SID SSSS
source /usr/bin/coraenv
else
# ............DEFAULT IT TO ONE YOU WANTED............
setenv ORACLE_SID ZZZZ
source /usr/bin/coraenv
endif
#
#end of file
set an alias for this script and make it handy...
[Edited by sreddy on 01-13-2001 at 01:29 PM]
WOW, thanks for the great advice, this may solve my confusion.
Just for clarification.
This script is actually:
your entire oraenv file (that reside in /usr/lbin), thats all thats inside of it
OR just an addition to your oraenv file, you have other items in there also
FYI, I am trying to change items inside an oraenv file that I copied from another server, while installing 806 and 816 together on a different server.
Thanks
make sure you have the right TNS_ADMIN path in local modifications at the end of coraenv/oraenv scripts.
Thats it pretty much. Rest everything will be Okey. We use it every day.