| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: multiple oracle homes
I tend to agree also, just because of confusion. We are running on one
server, 817 (1 instance), 9201 (1 instance), 9iASRel 2 (1 instance) and on
the second server we have 817 (2 instances), 9201 (1 instance), 9iAS Ver
102 (1 instance). So at first we tried different user names:
oracle8i (817 instances)
oracle9i (9201 instances)
oraias (9iAS Ver 102)
ora9ias (9iAS Rel 2)
This just got too confusing, so I wrote a script and placed it in the "oracle" .profile which creates a menu for the Admin logging in to choose (by number) which instances environment variables they want set. Then it calls another script depending on the choice to set those variables and echo them to verify by using:
env | grep ORA
env | grep TNS
This has been working ok so far, but if anyone has any better suggestions, let me know.
-Scott
At 10:34 AM 2/7/03 -0800, you wrote:
>I agree with Dennis. We tried this several years ago and decided it was
>best to stick with one username. I forget what the exact issues were - it
>might have been file privileges when you are upgrading a database.
>
>Jay
>
> >>> DWILLIAMS_at_LIFETOUCH.COM 02/07/03 10:54AM >>>
>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?
>
>
>
>
>
>
>**DISCLAIMER
>This e-mail message and any files transmitted with it are intended for the
>use of the individual or entity to which they are addressed and may
>contain information that is privileged, proprietary and confidential. If
>you are not the intended recipient, you may not use, copy or disclose to
>anyone the message or any information contained in the message. If you
>have received this communication in error, please notify the sender and
>delete this e-mail message. The contents do not represent the opinion of
>D&E except to the extent that it relates to their official business.
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Jay Hostetter
> INET: jhostetter_at_decommunications.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: Scott Stefick INET: sstefick_at_harpercollege.edu 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 Fri Feb 07 2003 - 13:36:36 CST
 |
 |