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