Re: Housing 2 Oracle DBs on 1 server

From: Anne Williamson <a.williamson_at_its.unimelb.edu.au>
Date: Wed, 30 Jun 1999 16:31:29 +1000
Message-ID: <3779B9BE.BD619228@its.unimelb.edu.au>

Thanks everyone. I use Unix (Sun UltraEnterprise 450 with 4 cpus) and need to run three instances. It's fine for two of them to be at the same software level,
and I'll run them off the same ORACLE_HOME. The third instance, where I want to be able to test patches and upgrades, will need a different ORACLE_HOME.

Thanks to all who responded and so quickly!

Anne

Francis Somers wrote:

> We run up to 4 Oracle instances on a single quad CPU HP K-460 in a
> production environment and have never had any problems. The point about
> running different versions is valid but if you want to run them all at the
> same version of Oracle then there should be no problem .
>
> Francis Sommers
> EDS Systemhouse
>
> David Sisk wrote in message <3mWd3.215$6J4.531_at_news.ipass.net>...
> >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
> >>
> >

--

Anne Williamson                       a.williamson_at_its.unimelb.edu.au
Information Technology Services       phone: +61 3 9344 7465
The University of Melbourne           fax:   +61 3 9347 4803

Australia Received on Wed Jun 30 1999 - 01:31:29 CDT