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
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
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
<div>I am running multiple instances on test machine, Windows, 9ir2.</div> <div> </div> <div>Both have SGA of 100m and machine memory is 512 mb.</div> <div> </div> <div>I am getting the following error.</div> <div> </div> <div> <p>C:\DOCUME~1\CMAJMU~1>set ORACLE_SID=chirep</p> <p>C:\DOCUME~1\CMAJMU~1>sqlplus /nolog</p> <p>SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 10:39:26 2005</p> <p>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.</p> <p>SQL> conn / as sysdba<br>Connected to an idle instance.</p> <p>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 </p> <p>Connected to Idle Instance.</p> <p>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.</p> <p>Nothing is showing in Alert log files too, as the same instance is running in other window.</p> <p> </p> <p>regards - Chirag </p></div>