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 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 Thomas
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).
