Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NT - Installing Multiple Instances - 8.0.5
I think the problem may be registry related. creating a default database during installation will set oracle_sid in the registry. better remove it to force setting oracle_sid on the command prompt explicitely. at least, that's what I make of your "pointing to another".
no problem in having multiple instances on one NT box. oracle_home has nothing to do with is - you decide where to put the database (but nt doesn't know symbolic links so yout init<SID>.ora file always resides in %ORACLE_HOME%/database
"Howard J. Rogers" wrote:
>
> <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?
> >
>
> Try harder to contact Oracle Support. Interesting, this inability to
> support multiple instances on a single server -since on an average training
> day, Oracle's own server is supporting somewhere around 50 or 60 different
> Instances (admittedly fairly small ones). I must be doing something wrong!!
>
> Irony aside, Oracle is clearly capable of having multiple Instances running
> on the one box, and it's ability to do so is limited only by the amount of
> memory you are prepared to throw at the problem.
>
> You need separate services per Instance, but you don't need separate
> listeners, and the one tnsnames.ora file will do nicely. The issue of 'the
> box...points one vs.another' is a configuration issue, and if you configure
> listener.ora, and tnsnames.ora correctly, you shouldn't have a problem.
>
> Regards
> HJR
>
> > 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 Wed Aug 23 2000 - 04:47:04 CDT