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: 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: 
  INET: brian.mcgraw_at_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_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).