Re: Running multiple instances

From: J.B.Natar <jbn_delete_at_excite.com>
Date: Tue, 03 Aug 1999 10:31:52 -0700
Message-ID: <37A72788.36E9F54C@excite.com>

You can start both the instances from DOS command line. Before starting the instances set ORACLE_SID to your SID of the instance ie. orcl or prod. Then in server manager (svrmgr30) use stratup nomount pfile= ..path.. of the init_sid.ora parameter file. Then run alter database mount, alter database open. run select * from v$instance to check your instance name. Exit to DOS. Start the second one. Set your tnsnames.ora and listner.ora file parameters accordingly.

Good luck.

joe

wozi wrote:

> Oracle 8.05 on NT 4.0
>
> I have installed the started database from Oracle 8.05. I am able to connect
> from a client. I have also installed another database instance called PROD.
>
> I am able to start ONLY one instance at a time and connect to it.
> BUT, I want both instances 'ORCL' and 'PROD' running on the same
> machine at the same time.
>
> Any suggestion ?
>
> thanks
> wozi_at_dhc.net
Received on Tue Aug 03 1999 - 12:31:52 CDT