Re: multiple instances

From: JHY <jhy_at_earthling.net>
Date: Mon, 29 Jun 1998 21:35:53 -0400
Message-ID: <6n9fdh$dpg@bgtnsc01.worldnet.att.net>

Check to see if a system variable, ORACLE_SID, is getting set to the other SID. Look in Control Panel => System => Environment.

yongming wrote:

> 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 Mon Jun 29 1998 - 20:35:53 CDT