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 assume you are not running parallel server so you have one instance mounted to one set of datafiles. You don't need multiple installations of Oracle on a server in order to run multiple databases - you just need one installation. You can then create as many databases as your machine's hardware can support. Each has a different SID and you can start one or more of them, connect to one or more of them and stop one or more of them. You don't need to have multiple ports, you do need to have entries in your tnsnames.ora and listener.ora for each of your databases. The IP address will presumably be the same for each database on a single server.
Van
<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 Thu Aug 17 2000 - 18:37:02 CDT