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
>>>
RROGERS@galottery.org 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
>>> brian.mcgraw@ipacc.com 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:
thomas.mercadante@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@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:
INET: brian.mcgraw@ipacc.com
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@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@galottery.org
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 message
to:
ListGuru@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).
