Re: Housing 2 Oracle DBs on 1 server

I don't see a problem with running multiple database instances from one oracle home, I am not an NT expert by any means, but I administer NT machines with 3-4 database instances on them, all of them sharing the same ORACLE_HOME. I think that this ma6y be a technical writing error where the definition of database is not that of database instance but rather the Oracle executable itself.

I think that what they mean is that if you install the Oracle software, you should only install one version of Oracle in each ORACLE_HOME.

Migration is not that big an issue if you maintain multiple ORACLE_HOMEs.

But then again I am just insane, so you might want to call support and ask them for an official explanation.
--glen

David Sisk wrote:
>
> 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
> >

--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-| Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407 Glen.Upreti_at_NOSPAMnau.edu

Received on Tue Jun 29 1999 - 09:21:22 CDT