Re: Housing 2 Oracle DBs on 1 server

Hi Ann:

There's lots of minor issues, but the biggest problem arises when you get ready to do an upgrade. Different 8.0.x versions can't exist in the same ORACLE_HOME (ie. folder). So, say you have an 8.0.5 instance used for production and an 8.0.5 instance used for development on the same box, and you want to upgrade the development instance to 8.0.6 without upgrading the production instance to 8.0.6. Well, you can't! Supposedly this problem goes away if you use multiple ORACLE_HOME's, but I haven't actually tested this configuration. (My policy at work, since we are hell-bent on running everything on NT whether the results are good or bad, is to run only one instance per box.)

Hope this helps.

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Anne Williamson wrote in message <37782A1D.2E367055_at_its.unimelb.edu.au>...
>In the Oracle 8 Administrator's reference, it states:
>
>If you have multiple databases with the same ORACLE_HOME (a configuration
which Oracle Corporation *strongly* discourages)...
>
>Does anyone know the reason for this? What problems if any should I expect
if I create a second instance using the same ORACLE_HOME?
>
>Thanks
>Anne
>
>Pete Sharman wrote:
>
>> Yes, it will mean two complete copies of a database. So there will be
separate
>> data file, control files and redo log files. The only limitation on
numbers of
>> databases running against a single server is the capability of the server
to
>> handle the load.
>>
>> HTH.
>>
>> Pete
>>
>> Just4SC wrote:
>>
>> > What about datafiles? Would this mean that there will be two sets of
>> > control files, rollback segments, and etc?
>> > Thanks!
>> >
>> > <ManniP_at_Hotmail.com> wrote in message
news:376930FB.5A854F96_at_Hotmail.com...
>> > > Yes, but with two different Oracle S.I.D.
>> > >
>> > > Just4SC wrote:
>> > >
>> > > > Hi! This might be a stupid question but I was wondering if it is
>> > possible
>> > > > to have two databases running simultaneously on one Oracle 8.05
server?
>> > > >
>> > > > Thanks!
>> > >
>>
>> --
>>
>> Regards
>>
>> Pete
>>
>> -----------------------------------------------------------------------
-
>>
>> Pete Sharman <psharman_at_us.oracle.com>
>> Project Manager
>> Worldwide Internal Services Education
>> Oracle Corporation
>>
>> Pete Sharman
>> Project Manager

à8Ä
>> Worldwide Internal Services Education
>> Oracle Corporation
>> 500 Oracle Parkway M/S OPL-B1024

à8Ä
>> Redwood Shores

àTîÄ
>> California

àUDÄ
>> 94065
>> USA
>> SQL> select standard_disclaimer, witty_remark 2 from
company_requirements; **** The statements and opinions expressed here are my **** **** own and do not necessarily represent those of **** **** Oracle Corporation. **** "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA
>> Additional Information:
>> Last Name Sharman
>> First Name Peter
>> Version 2.1
>
>--
>Anne Williamson a.williamson_at_its.unimelb.edu.au
>
Received on Mon Jun 28 1999 - 21:48:05 CDT