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
>>> [EMAIL PROTECTED] 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.
[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?
**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: [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).
****************************************** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ****************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Stefick 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).
