RE: multiple oracle homes
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 KE4TJC28^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).
Re: multiple oracle homes
Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT' and /usr/local/bin/oracle_setup.ksh will source oraenv and do some additional customization. Alex. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:14 PM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein 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).
RE: multiple oracle homes
Alex, Thanks for that idea :) - Kirti -Original Message- Sent: Sunday, March 02, 2003 8:04 PM To: Multiple recipients of list ORACLE-L Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT' and /usr/local/bin/oracle_setup.ksh will source oraenv and do some additional customization. Alex. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, February 28, 2003 7:14 PM 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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein 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: 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).
RE: multiple oracle homes
Title: RE: multiple oracle homes Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Friday, February 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Subject: RE: multiple oracle homes 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] 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: DENNIS WILLIAMS 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).
RE: multiple oracle homes
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 KE4TJC28^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).
RE: multiple oracle homes
Ray - the one thing we do is always make sure we don't corrupt the Oracle Inventory files. Whenever we install a new version of Oracle, we copy then delete the current oraInst.loc file (e.g. cp oraInst.loc oraInst_u03.loc), which on our system is located in /var/opt/oracle. We have our Oracle Homes on different file systems. If you want them on the same file system, be sure your Oracle Inventory is located under $ORACLE_HOME, so that each version can have it's own inventory location. Always be sure you have the right oraInst.loc file in place when you are doing your patching. See note 182853.1 Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 02/06/03 04:18PM Ray - Since I don't see where anyone replied, I think the problem is your stress on well documented. Might have scared people off. The basic procedure is to use separate ORACLE_HOME for each version. Make sure each version doesn't share anything you don't want them to. Most Unix systems require certain kernel parameters to be increased. I am not seen where anyone has clearly documented all aspects of this situation. Make sure you try this first on a test server. Once you've done it a time or two, your confidence will increase. Then you can write that clear documentation and post it on a web site for everyone's benefit. ;-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 06, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D **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 DE 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).
Re: multiple oracle homes
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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
Re: multiple oracle homes
Ray - I have always used #2 and never had a problem. I do set Oracle_Base Oracle_Home to different values for each version. e.g. /oracle1/dbserver/7.3.4 /oracle1/dbserver/8.1.7 /oracle1/appserver/1.0.2 ... hth, Gene P.S. The root directory is different on all my servers to support HA, i.e. oracle1 is on node 1, oracle2 on node 2, This allows me to have a failover and still have the primary secondary mount points available. [EMAIL PROTECTED] 02/07/03 09:23AM 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 likethere are two different approaches on the surface:1. use two different userids, ora817 and ora920, to do the install. Thisseems stupid, since it replicates the product directory structure andoraInventory stuff under different ownership. This might be safer sinceit is like running one version in that everything is seperate, butmaybe there are operational issues to not using the oracle userid.Seems like there may be a gotcha waiting in the wings. Like maybe youcan't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environmentvars as needed. Seems like you could damage the first install if youmade a mistake. Also, it seems like in a stressful failure situationyou 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]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: multiple oracle homes
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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: DENNIS WILLIAMS 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).
RE: multiple oracle homes
Dennis, What bad experience did you had? I wouldn't recommend it but I had no problem when I run both 32 bit and 64 bit 8.1.7.4 on the same box using that approch. Thanks Richard -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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: DENNIS WILLIAMS 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: Richard Ji 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).
RE: multiple oracle homes
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 DE 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).
Re: multiple oracle homes
On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can imagine. I can imagine blowing one's foot off the other way, also. Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
RE: multiple oracle homes
Richard - It was more like Jay mentioned. Just problems with file permissions. It just always seem to be biting me at every turn. I finally got everything over to the Oracle username. The other issue is that my guess is that the Oracle developers test everything with the Oracle username. So if you use a different username you stand a slight chance of discovering something that hadn't turned up before. Again, this was just my experience and I never had a reason to use separate userids since. If they work well for you, maybe your advice is just what Ray needs to hear. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Dennis, What bad experience did you had? I wouldn't recommend it but I had no problem when I run both 32 bit and 64 bit 8.1.7.4 on the same box using that approch. Thanks Richard -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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: DENNIS WILLIAMS 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: Richard Ji 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: DENNIS WILLIAMS 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:
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 [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 DE 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).
Re: multiple oracle homes
On Fri, Feb 07, 2003 at 11:36:36AM -0800, Scott Stefick wrote: 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) Well, it seems like it could be confusing either way, you gotta remember one thing or the other and get it right. Could be fun at crunch time. I'm more concerned about the hidden gotchas of not using the oracle id. I suspect the Oracle Corp devel comment about assuming the oracle userid is a very strong one. I'll check the docs ;) This just got too confusing, OK, I'll go that way. However, if I don't get the env right, I'm pretty sure I can trash some of the software already installed. What are the critical vars: ORACLE_HOME ORACLE_BASE ORACLE_SID PATH LD_LIBRARY_PATH LD_RUN_PATH Please help me to not mess up my weekend! Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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).
RE: multiple oracle homes
Maybe, but Ray will decide what's best for him. I think we have offered enough points for him to consider. File permission is a big headache. In my case, I have two totally separate environment since one is 32 bit, on is 64 bit. Regards Richard Ji -Original Message- Sent: Friday, February 07, 2003 2:31 PM To: Multiple recipients of list ORACLE-L Richard - It was more like Jay mentioned. Just problems with file permissions. It just always seem to be biting me at every turn. I finally got everything over to the Oracle username. The other issue is that my guess is that the Oracle developers test everything with the Oracle username. So if you use a different username you stand a slight chance of discovering something that hadn't turned up before. Again, this was just my experience and I never had a reason to use separate userids since. If they work well for you, maybe your advice is just what Ray needs to hear. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 11:40 AM To: Multiple recipients of list ORACLE-L Dennis, What bad experience did you had? I wouldn't recommend it but I had no problem when I run both 32 bit and 64 bit 8.1.7.4 on the same box using that approch. Thanks Richard -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 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: DENNIS WILLIAMS 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: Richard Ji 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network
Re: multiple oracle homes
maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. thanks, steve Ray Stell [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/07/2003 01:19 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: multiple oracle homes On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can imagine. I can imagine blowing one's foot off the other way, also. Thanks. === 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] 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).
Re: multiple oracle homes
That is why each oracle home has its own oraInventory directory. I have 10 different instances across 2 machines. Each instance has its own user id and group. There have been no problems at all with this setup for 8.1.7.4 and 9.2.0 Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] edu To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: multiple oracle homes 02/07/2003 01:49 PM Please respond to ORACLE-L maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. thanks, steve Ray Stell [EMAIL PROTECTED] To:Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject:Re: multiple oracle homes 02/07/2003 01:19 PM Please respond to ORACLE-L On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can imagine. I can imagine blowing one's foot off the other way, also. Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: Ron Thomas 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
Re: multiple oracle homes
Solution would be different users but all having the same group. I always use a oinstall group for all oracle users in a system. I have Oracle 8 and 9 on the same Sun. Quoting Stephen Evans [EMAIL PROTECTED]: maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu 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).
RE: multiple oracle homes
Ray - Perhaps you misunderstood. You won't find anything in the documentation saying our developers didn't have time to test every installation permutation against alternate userids. I used to be a developer at a software vendor. I know how the developers think. You don't like to test. You take the path of least resistance. If an enterprising tester/developer wannabe files a priority one bug against your software because he found a small problem when he tried alternate userids, you let him know if he busts your chops for something so lousy and insignificant again, you'll make sure he never becomes a developer. Okay, I feel better . . . cooling down . . . thinking Friday . . . Oh yeah, what is this about doing it this weekend? On your test server? Hey we got rules in the secret fraternity of Oracle DBAs. Don't make the rest of us look bad. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 2:20 PM To: Multiple recipients of list ORACLE-L On Fri, Feb 07, 2003 at 11:36:36AM -0800, Scott Stefick wrote: 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) Well, it seems like it could be confusing either way, you gotta remember one thing or the other and get it right. Could be fun at crunch time. I'm more concerned about the hidden gotchas of not using the oracle id. I suspect the Oracle Corp devel comment about assuming the oracle userid is a very strong one. I'll check the docs ;) This just got too confusing, OK, I'll go that way. However, if I don't get the env right, I'm pretty sure I can trash some of the software already installed. What are the critical vars: ORACLE_HOME ORACLE_BASE ORACLE_SID PATH LD_LIBRARY_PATH LD_RUN_PATH Please help me to not mess up my weekend! Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: DENNIS WILLIAMS 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).
RE: multiple oracle homes
Ray - Since I don't see where anyone replied, I think the problem is your stress on well documented. Might have scared people off. The basic procedure is to use separate ORACLE_HOME for each version. Make sure each version doesn't share anything you don't want them to. Most Unix systems require certain kernel parameters to be increased. I am not seen where anyone has clearly documented all aspects of this situation. Make sure you try this first on a test server. Once you've done it a time or two, your confidence will increase. Then you can write that clear documentation and post it on a web site for everyone's benefit. ;-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 06, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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: DENNIS WILLIAMS 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).
Re: multiple oracle homes
Normally there is some stuff in the platform-specific installation manual or in the migration manual. In any event, you pretty much stick 8i under one directory / filesystem and 9i under another and use oratab (in conjunction with oraenv/coraenv) to toggle between them hth connor --- Ray Stell [EMAIL PROTECTED] wrote: Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell 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). = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
RE: Multiple Oracle Homes for Oracle
If you try to run sqlplus or any other sql utility on the database without those environment variables set, it won't know where to look for the utilities or where to look for a database whose name it doesn't know. Your best bet to see exactly what it does is do what you are describing and try to run sqlplus to access the database and see what happens. But this isn't really the multiple homes concept. April Wells Oracle DBA Keep yourself well oiled with life, laughter, new ideas and action. Otherwise you will rust out. _Anonymous -Original Message- Sent: Friday, October 04, 2002 8:08 AM To: Multiple recipients of list ORACLE-L Hi All, I am not very clear on how the Multiple Oracle Homes' concept works. Does one need an ORALE_HOME and ORACLE_SID environment veriable with appropriate values ONLY when starting the DB instance, or launching an application that uses these variables? Are these environment variables not accessed after that? To make my question clear, say, I need to start a database having SID = 'db1'. I do a $ export ORACLE_SID=db1 and export ORACLE_HOME=/opt/oracle/product/9201 and then connect to sqlplus and start the database. (FYI: Oracle on Linux) after this, if I unset the 2 environment variables or set them to some other garbage value, will anything go wrong? Cheers, Shantanu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shantanu Datta 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). begin 666 InterScan_Disclaimer.txt M0U-502 R,# R.B @26UA9VEN92!T:4@4]SVEB:6QI=EER$-D-OG!O MF%T92!37-T96US($%N;G5A;!5V5RR!!W-O8VEA=EO;B!#;VYF97)E M;F-E#0I7:5N.B!/8W1O8F5R(#(M-P@,C P,@T*5VAEF4Z($-AFEB92!2 M;WEA;4@4F5S;W)T( @3W)L86YD;RP@1DP@(%5300T*1F]R(UOF4@:6YF M;W)M871I;VX@9V\@=\@=W=W+F-S961G92YC;VT-@T*#0H-E1H92!I;F9O MFUA=EO;B!C;VYT86EN960@:6X@=AIR!E+6UA:6P@:7,@W1R:6-T;'D@ M8V]N9FED96YT:6%L(%N9!F;W(@=AE(EN=5N95D('5S92!O9B!T:4@ M861DF5SV5E(]N;'D[(ET(UA2!A;'-O()E(QE9V%L;'D@')I=FEL M96=E9!A;F0O;W(@')I8V4@V5NVET:79E+B @3F]T:6-E(ES(AEF5B M2!G:79E;B!T:%T(%N2!D:7-C;]S=7)E+!UV4@;W(@8V]P6EN9R!O M9B!T:4@:6YF;W)M871I;VX@8GD@86YY;VYE(]T:5R('1H86X@=AE(EN M=5N95D(')E8VEP:65N=!IR!PF]H:6)I=5D(%N9!M87D@8F4@:6QL M96=A;X@($EF('EO=2!H879E(')E8V5I=F5D('1H:7,@;65SV%G92!I;B!E MG)OBP@QE87-E(YO=EF2!T:4@V5N95R(EM;65D:6%T96QY()Y M(')E='5R;B!E+6UA:6PN@I#;W)P;W)A=4@4WES=5MRP@26YC+B!H87,@ M=%K96X@979EGD@F5AV]N86)L92!PF5C875T:6]N('1O(5NW5R92!T M:%T(%N2!A='1A8VAM96YT('1O('1H:7,@92UM86EL(AAR!B965N('-W M97!T(9OB!V:7)UV5S+B @5V4@86-C97!T(YO(QI86)I;ET2!F;W(@ M86YY(1A;6%G92!S=7-T86EN960@87,@82!R97-U;'0@;V8@V]F='=AF4@ M=FER=7-ER!A;F0@861V:7-E('EO=2!C87)R2!O=70@6]UB!O=VX@=FER M=7,@8VAE8VMS()E9F]R92!O5N:6YG(%N2!A='1A8VAM96YT+@T*#0H- #@T* end -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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).
RE: Multiple Oracle Homes on Unix
Yes. I have had 7.3.4 and 8.1.6 databases runing together just fine. There are two schools of thought on this. 1. 2 seperate IDs and homes 2. The same ID and same home. With the first version you setup your 2 id's (They can have the same group) and point those IDs to 2 seperate homes. Each ID will have different profiles that will setup the appropriate ORACLE_HOME, Paths, Sids, etc. The second version is a little more complicated but was the one we used. We used 1 id and therefore 1 home. By default NO ORACLE VARIABLES WERE SET. This way if you did not do the next step, you could not login and screw up the DB. Next , we create a script that setup the correct Oracle Home and Path variables when you choose it from a menu. This way, we could log into 1 ID, choose which instance we wanted to go to, and then get all the variable setup. It worked very good. But, if you are more of a Novice Unix person and Oracle DBA I would suggest 2 seperate homes. It eliminates the headache of creating the other environment setting script. Kevin -Original Message- Sent: Wednesday, September 12, 2001 6:37 PM To: Multiple recipients of list ORACLE-L Currently I have a 8.0.5 environment that was installed and configured by the previous DBA who liked to things a certain way, not necessarily the right way, just a certain way. I am in the process of installing 8.1.6, according to the docs I should setup a separate unix account for installing the software, which I have. What I want to do is create a mixed environment with multiple oracle homes, currently 8.1.6 and 8.0.5, with oracle 9 coming in sometime in the future. I am having trouble with the owner/privileges. If I have installed 8.1.6 software as owner 'oracle' group 'dba', can I create a new unix account, 'ora816' group 'dba' and run the software and instance/database ?. The ora816 would issue the necessary login profile to setup its ORACLE_HOME and supporting variables. I would create a environment for the 8.0.5 account (ora805). I am assuming that the database files themselves would have to be created and owned by ora816 and or ora805 Any tips,articles general info would be appreciated as Metalink doesn't quite answer the questions I have, at least I can't find the answers. Thanks Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).