Multiple Instance issue

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Tue, 1 Nov 2005 10:43:30 -0500
Message-ID: <1a3629600511010743m442b561ah36865cacad90fa80@mail.gmail.com>

I am running multiple instances on test machine, Windows, 9ir2. Both have SGA of 100m and machine memory is 512 mb. I am getting the following error.

C:\DOCUME~1\CMAJMU~1>set ORACLE_SID=chirep

C:\DOCUME~1\CMAJMU~1>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 10:39:26 2005

SQL> conn / as sysdba
Connected to an idle instance.

But the same instance is up and running in another windows, but in any new window I am opening, this particular is instance is showing as

Connected to Idle Instance.

Can anyone tell me what could have gone wrong here? It was working fine and I have not done any other installation in recent past.

Nothing is showing in Alert log files too, as the same instance is running in other window.

regards - Chirag

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 01 2005 - 09:45:35 CST