RE: migrating to 8.0.6 in a second ORACLE_HOME

From: Deshpande, Kirti <Kirti.Deshpande_at_gtedc.gte.com>
Date: Thu, 15 Jun 2000 11:30:05 -0500
Message-Id: <10529.109430@fatcity.com>

Ruth,
 We run multiple releases of oracle from multiple ORACLE_HOMEs. In oracle's .profile we setup 'aliases' for the various things associated with SIDs. To change to a new SID, we just type the SID name. The 'alias' setup takes care of re-setting the env properly. Also, our UNIX prompt includes the name of the SID.

Here is an example of such aliases from one of our machines:

# Set up aliases for Dump and Archive directories

alias bdump='export BDUMP=/u888/oradata/$ORACLE_SID/bdump'
alias cdump='export CDUMP=/u888/oradata/$ORACLE_SID/cdump'
alias udump='export UDUMP=/u888/oradata/$ORACLE_SID/udump'

alias archive='export ARCHIVE=/u999/oradata/$ORACLE_SID/archive' alias setdump='bdump; cdump; udump; archive'

#Set up aliases for SIDs
alias TBST='export ORACLE_SID=TBST; export ORAENV_ASK="NO";. oraenv; setdump'
alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/PRMT; setdump'
alias PRBT='export ORACLE_SID=PRBT; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/PRBT; setdump'
alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D; setdump'
alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv; setdump'
alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv; setdump'
alias DSSA='export ORACLE_SID=DSSA; export ORAENV_ASK="NO";. oraenv; setdump'

Hope this helps.
- Kirti

> >From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
> >To: "oracle list" <ORACLE-L_at_fatcity.com>, "oracleDBA"
> ><oracledba_at_quickdoc.co.uk>, "Oracle_L at Suny Mailing lList"
> ><ORACLE-L_at_LISTS.SUNYSB.EDU>
> >Subject: migrating to 8.0.6 in a second ORACLE_HOME
> >Date: Wed, 14 Jun 2000 10:54:08 -0400
> >
> >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
Received on Thu Jun 15 2000 - 11:30:05 CDT