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,

- 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.
[EMAIL PROTECTED]


-----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   [EMAIL PROTECTED]     (540) 231-4109     KE4TJC    28^D
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ray Stell
  INET: [EMAIL PROTECTED]

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to