Re: multiple instances

To connect to a particular instance with server manager :

Open a DOS Command Prompt.
SET ORACLE_SID=XXXX (where XXXX is the instance you are connecting to) svrmgr30

Regards
David Russell

yongming wrote in message <358be7ac.0_at_lightning.ica.net>...
>Hi there,
>
>I am using Oracle 8 on Windows NT4 and try to create multiple instances. I
>loaded typical database from Oracle installation (with db_name=oracle and
>sid=orcl). I also created another instance called dogs (with
db_name=dbdogs
>and sid=dogs) using Oracle Database Assistant. By changing Registry Key
>ORACLE_SID to "dogs" from "orcl", I was able to connect to "dogs" instance
>in Enterprise Manager's Instance Manager console and command line Server
>Manager (svrmgr30) but not in SQL-PLUS. However I can connect to the
"orcl"
>instance in SQL-PLUS but not in server manager and instance manager. The
>command line instance manager (oradim80) shows both instances are running.
>Could somebody give me some hints to solve this math. Thanks a lot for
your
>help
>
>Yongming
>
>
Received on Sat Jun 20 1998 - 17:13:12 CDT