multiple instances

From: yongming <yongming_at_ica.net>
Date: Sat, 20 Jun 1998 12:49:11 +0100
Message-ID: <358be7ac.0@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 - 06:49:11 CDT