Thanks! Ruth
----- Original Message -----
From: Thapliyal, Deepak <DThapliyal_at_ea.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Wednesday, June 14, 2000 5:47 PM
Subject: 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)
>
> ***
> export ORACLE_SID=$1
> ORAMSG="Please Set ENVIRONMENT --> ORACLE_HOME, PATH, LD_LIBRARY_PATH "
> grep "$ORACLE_SID" /var/opt/oracle/oratab > /dev/null 2>&1
> if [ `echo $?` -eq 0 ] ; then
> 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
>
PATH=$ORACLE_HOME/bin:$PATH:/bin:/usr/bin:/usr/sbin:/usr/ccs/bin:/usr/ucb:/e
> tc
> else
> echo $ORAMSG"[ check oraenv ]"
> fi
> else
> echo $ORAMSG"[ check oratab ]"
> fi
>
> ***
>
>
>
> -----Original Message-----
> Sent: Wednesday, June 14, 2000 9:19 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 may
> also send the HELP command for other information (like subscribing).
> --
> Author: Thapliyal, Deepak
> INET: DThapliyal_at_ea.com
>
> 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 may
Received on Thu Jun 15 2000 - 12:27:51 CDT
