RE: migrating to 8.0.6 in a second ORACLE

From: Thapliyal, Deepak <DThapliyal_at_ea.com>
Date: Wed, 14 Jun 2000 13:40:08 -0700
Message-Id: <10528.109302@fatcity.com>

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-----
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 may

Received on Wed Jun 14 2000 - 15:40:08 CDT

RE: migrating to 8.0.6 in a second ORACLE_HOME