Re: Oracle OID and Production Databases Sharing the same

[paul bennett]

Hi Ron and Brian:   We have been running the OID database in the same ORACLE_HOME as a production database since Nov 2002. I am running both  8.1.7 on AIX 4.33 and 9.2.0.4 on AIX 5.1. I feel using the same ORACLE_HOME or separate ORACLE_HOMES depends on how you plan to use OID. On the servers where the same ORACLE_HOME is being shared we are only using generic LDAP functions. If you plan to use Oracle LDAP/OID functionality such as Single-Sign-On then you I believe you need to have them in separate ORACLE_HOMES. Whenever you need the Infrastructure that is part of 9iAS I would say it should be a separate ORACLE_HOMES with some possible exceptions. I have not had  any issues applying patchsets so far when sharing a ORACLE_HOME.    Collaboration Suite is different problem. OCS requires an Infrastructure that must be installed in a 9.0.4.1 database. This version of the database is not supported on AIX 5L. (This is because 9.0.4.1 came out before 5.L was out according to Oracle.)  It is only supported on AIX 5L when installed as part of OCS. The Infrastructure for OCS must be in a separate ORACLE_HOME. There may be a way to have the OID database outside of the Infrastructure but I would not recommend it. You also need to make sure the server where the Infrastructure is installed is not likely to change because moving the  OCS Infrastructure is almost impossible to do.   In summary I would say the OID database should be a separate ORACLE_HOME unless you only plan to use it for non-Oracle LDAP functions.    Paul Bennett         >>> [EMAIL PROTECTED] 12/30/03 02:04PM >>> Brian, From reading into your message I get the impression the you wanted to use the OID supplied database for your other database and support frowned upon it. Was there any problem with using the "normal" Oracle database for the OID database? Ron >>> [EMAIL PROTECTED] 12/30/2003 1:59:26 PM >>> I would opt to separate them.  I ran into some problems with a Collaboration Suite install, where I wanted to use the OID database, to store my files data as well.  It failed in a spectacular fashion.  An Oracle support analyst said that was a bad idea.  When I asked him if I could just create another instance with the same $ORACLE_HOME, he frowned on it, because the database version used by OID isn't really *that* supported by Oracle.  I don't know what makes it so special, but I got the impression from him that it was a fragile database release, meant for use by Oracle only. My $.02 - Brian ----- Original Message ----- Date: Tuesday, December 30, 2003 12:34 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 > Oraclehome. > > 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: [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:   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 Rogers   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).