-
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).
Jeff Hunter
-
switch_home OR select_sid
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:
<font face=courier>
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
</font>
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
-
tns_admin
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|