Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: migrating to 8.0.6 in a second ORACLE_HOME
ruth, we had a similar prob here .. we are running 805,815,816.
i have a generic .profile that i execute as soon as i log in to unix.
the script basically accepts SID and sets the oracle home from oratab.
thereafter it sets the PATH and ld_library_path. works for me :-)
Prerequisites: root.sh has been run AND oratab has been set with correct values for diff sids/diff homes
$ ksh
$ . .profile8i [sid]
relevant excerpt from .profile8i for oracle settings (assumes solaris)
if [ -r /usr/local/bin/oraenv ] || [ -r /opt/bin/oraenv ] ; then
#grep -v "#" /var/opt/oracle/oratab| awk -F":" '{print $1}' |sed '/^[ ]*$/d'
export ORAENV_ASK=NO export PATH=$PATH:.:/usr/local/bin:/opt/bin . oraenv export ORAENV_ASK=YES export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH:/usr/lib:/usr/openwin/lib export
else
echo $ORAMSG"[ check oraenv ]"
fi
else
echo $ORAMSG"[ check oratab ]"
fi
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
Sent: Wednesday, June 14, 2000 9:19 AM
To: Multiple recipients of list ORACLE-L
Subject: migrating to 8.0.6 in a second ORACLE_HOME
I am going to migrate one of my development databases to 8.0.6. There will be two developement database left in 8.0.5.1. I have a few questions about living in two ORACLE_HOME's.
Once I migrate to the new version, how do I set the environment to the new ORACLE_HOME when I want to use svrmgrl and other tools? I think I use ORAENV but I am not sure how.
If anyone thinks of anything I should know before I take the plunge please let me know.
Ruth B. Gramolini
ORACLE & DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us
-- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Wed Jun 14 2000 - 15:40:08 CDT