RE: multiple oracle homes

Better yet, have one single generic .profile with aliases defined for each instance running on the server.

Want to change env for another instance? Just type it's name. It is that simple.

We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w.

The .profile file sources the alias' file as .local.aliases. This file has entries as below:

#Add Database name here using the following format

alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv;'
alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK="NO";. oraenv;'
alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D;'
alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv;'
alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK="NO";. oraenv;'
alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK="NO";. oraenv;'
alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK="NO";. oraenv;'
alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv;'
alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK="NO";. oraenv;'

PRMT --> IWVT are the instances running on the server.  

And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !!

HTH,

• Kirti

-----Original Message-----
Sent: Friday, February 28, 2003 4:30 PM
To: Multiple recipients of list ORACLE-L

Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense. -----Original Message-----
Sent: Friday, February 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L

Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, February 07, 2003 8:24 AM To: Multiple recipients of list ORACLE-L

On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote:
>
> Where is it well documented how to install multiple server versions,
> 8i and 9i, on the same unix server?

-- 
Thanks for you replies.  I've never tried this before and it seems like 
there are two different approaches on the surface: 
1. use two different userids, ora817 and ora920, to do the install.  This 
seems stupid, since it replicates the product directory structure and 
oraInventory stuff under different ownership.  This might be safer since 
it is like running one version in that everything is seperate, but 
maybe there are operational issues to not using the oracle userid. 
Seems like there may be a gotcha waiting in the wings.  Like maybe you 
can't run the same listener for both, or worse.  
2. use the same oracle userid for both installs and change the environment 
vars as needed.  Seems like you could damage the first install if you 
made a mistake.  Also, it seems like in a stressful failure situation 
you don't want to have to think about who's on first?  I don't know, 
third base. 
Are both paths valid? 
=============================================================== 
Ray Stell   stellr_at_vt.edu     (540) 231-4109     KE4TJC    28^D 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ray Stell 
  INET: stellr_at_cns.vt.edu 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).