Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: NT - Installing Multiple Instances - 8.0.5

Re: NT - Installing Multiple Instances - 8.0.5

From: Adrian Shepherd <theshepherds_at_hotmail.com>
Date: Sat, 19 Aug 2000 10:44:57 +1000
Message-ID: <2Okn5.1904$Vb.50054@ozemail.com.au>

Single CPU NT servers with 7 instances would slow down if they were pretty active, but on a multiple CPU server I would't see any problem either, having run exponentially larger databases myself, as long as there is spare CPU cycles and free memory, Oracle will run quite happily given any number of instances up until the point where NT will spend too much time scheduling rather than user CPU cycles.

"Terry Dykstra" <dontreply_tdykstra_at_cfol.ab.ca> wrote in message news:399d9d79_7_at_news.cadvision.com...
> You shouldn't generalize those types of statements. I've been running 7
> instances with 45GB on NT without any problem for 2 years now.
>
> --
> Terry Dykstra (TeamSybase)
> Please state PB / OS versions in your post.
> Sybase Developer's Network: http://www.sybase.com/sdn
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:966573750.29114.0.pluto.d4ee154e_at_news.demon.nl...
> > No, that's not Oracle's inability. There is really no problem at all in
> > having multiple instances on one server.
> > However, you won't succeed in running 5 instances with 40G data on 1
 single
> > NT server anyway, and that's NT's inability.
> > Actually this is a typical RTFM question, sorry for using the phrase.
 Just
> > use the database assistant or even oradim80 to create those multiple
> > instances, it will work like a breeze, and yes there will be one
> > Oracle_home, and yes you need to configure sqlnet, and you definitely
 don't
> > need any multiple listeners or multiple ip-addresses or multiple ports.
 A
> > manual edit of listener.ora, and tnsnames.ora just duplicating and
 changing
> > the sid section should do.
> >
> >
> > Regards,
> >
> > Sybrand Bakker, Oracle DBA
> >
> > <azraiderfan_at_my-deja.com> wrote in message
> > news:8nhd6l$gtr$1_at_nnrp1.deja.com...
> > > Currently our company is having great success using Oracle 8.0.5 on
 NT.
> > > We're managing some 40 Gig of data across 5 instances.
> > >
> > > The only issue is that in managing those 5 instances, we have 5 NT
 servers
 do
> > > to Oracle's inability to support multiple instances on a single
 server.
 I've
> > > tried contacting their support without successful implementation, and
 even
> > > have been able to create multiple SIDs on a given box - - but the box
 only
> > > recognizes the common ORACLE_HOME entries and points to one vs.
 another.....
> > >
> > > Suggestions please?
> > >
> > > Multiple IPs? Ports? (and associative listener and tnsnames.ora file
 mods.)
> > >
> > > Has anyone out there been successful doing this? Many thanks in
 advance...
> > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> >
> >
>
>
Received on Fri Aug 18 2000 - 19:44:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US