Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: multiple oracle homes

RE: multiple oracle homes

From: John Blake <jblake_at_arrow.com>
Date: Sun, 02 Mar 2003 05:53:42 -0800
Message-ID: <F001.0055DE97.20030302055342@fatcity.com>

We do something similar to this, we created a series of scripts that use the oratab file to create a menu for the oracle id. this same proc is called when running batch jobs against the DB's by sending the DB name as a parm.
-----Original Message-----
Kirti
Sent: Friday, February 28, 2003 10:15 PM To: Multiple recipients of list ORACLE-L

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,

-----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).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: John Blake
  INET: jblake_at_arrow.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).
Received on Sun Mar 02 2003 - 07:53:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US