Re: Running multiple instances

in NT you have to do
SET ORACLE_SID=<new instance name>
svrmgrl
startup
select * from v$parameter where name='db_name'; and you'll see your new instance running to get back to your old instance
you have to do
SET ORACLE_SID=<old instance name>
svrmgrl
select * from v$parameter where name='db_name'; and you'll see your old instance

On Mon, 2 Aug 1999 19:04:01 -0700, "wozi" <wozi_at_dhc.net> 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
>
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email