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

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