Re: Oracle OID and Production Databases Sharing the same

Tom,
 I see no problem that would prevent you from having multiple instances in the Oracle home. You would need multiple Oracle homes if you had different version of Oracle. With one Oracle home and multiple instances you have to be sure to include all instances in the shutdown and start up scripts or at least have a check list to insure all instances are down or up. Adding the java stuff should not effect the other instance if the init parameters are set correctly. It will make life easier to keep the Oracle software up to date with only one home. I like the KISS syndrome.
Ron

>>> thomas.mercadante_at_labor.state.ny.us 12/30/2003 1:34:49 PM >>>
All,

We have a AIX 5.2 box serving a new 9.2 database. We also installed the OID
software on this box. Oid requires it's own database. So we have two instances on this machine.

We received notice from Oracle that a security patch (#62) was required. We
were applying the patch and it failed because some Java stuff needed to be
installed separatly first.

Now I'm wondering if we should have created two Oracle Homes - one for the
production database and one for the OID database. I'm worried that we will
always have problems keeping these two instances sharing the same Oracle
home.

Anybody got an opinion?

Tom Mercadante
Oracle Certified Professional

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Mercadante, Thomas F
  INET: thomas.mercadante_at_labor.state.ny.us 

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: Ron Rogers
  INET: RROGERS_at_galottery.org

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