RE: Oracle OID and Production Databases Sharing the same
Paul, Ron, Ravi & Brian, Thanks for the replies. I should have known that keeping them separate was the smart thing to do. We've tried twice now to apply patch 62 (a security notice) to the 9.2.0.4 software. It's failed both times. The first with Java errors, and the second with something else. If we had two separate instances, at least our production instance would probably have been patched easily and just the OID instance would be "in the weeds". Now I need to schedule some other down time to create a new Oracle home. Thanks again. Tom Mercadante Oracle Certified Professional -Original Message-From: paul bennett [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 30, 2003 6:09 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle OID and Production Databases Sharing the same 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 touse the OID supplied database for your other database and supportfrowned upon it. Was there any problem with using the "normal" Oracledatabase 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 Iwanted to use the OID database, to store my files data as well. Itfailed in a spectacular fashion. An Oracle support analyst said thatwas a bad idea. When I asked him if I could just create anotherinstance with the same $ORACLE_HOME, he frowned on it, because thedatabase 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 fromhim that it was a fragile database release, meant for use by Oracleonly.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 havetwo> 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 hostingservices> ---> --> 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
Re: Oracle OID and Production Databases Sharing the same
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 touse the OID supplied database for your other database and supportfrowned upon it. Was there any problem with using the "normal" Oracledatabase 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 Iwanted to use the OID database, to store my files data as well. Itfailed in a spectacular fashion. An Oracle support analyst said thatwas a bad idea. When I asked him if I could just create anotherinstance with the same $ORACLE_HOME, he frowned on it, because thedatabase 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 fromhim that it was a fragile database release, meant for use by Oracleonly.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 havetwo> 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 hostingservices> ---> --> 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 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).-- 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail mess
Re: Oracle OID and Production Databases Sharing the same Oracle Home
Tom, We have a small separate box housing OID(9204), OEM,RMAN instances. Since we are using OID for service Naming, I understand Oracle has no licence fee since it is used for servicing other Oracle Databases across the enterprise. We also use OID replication(another node located at the DR site), hence it makes it convenient for this type of maintenance, in addition to HA and low cost. Thanks, Ravi. --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > 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: [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). __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni 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: Oracle OID and Production Databases Sharing the same
I'll agree that you can run multiple instance out of 1 oracle home, however, I've found it to be simpler to use a dedicated oracle home per instance. Disk space is cheap (relatively speeking). Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] .org To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Re: Oracle OID and Production Databases Sharing the same .com 12/30/2003 12:59 PM Please respond to ORACLE-L 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 >>> [EMAIL PROTECTED] 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: [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 o
Re: Oracle OID and Production Databases Sharing the same
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).
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 >>> [EMAIL PROTECTED] 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: [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).
Re: Oracle OID and Production Databases Sharing the same Oracle Home
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).
Oracle OID and Production Databases Sharing the same Oracle Home
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: [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).