On 11/1/05, t_adolph@(protected) <t_adolph@(protected)> wrote: > > Are they both running under the same ORACLE_HOME? > Tony > > -- -- Original Message -- -- > *From:* Chirag DBA <chiragdba@(protected)> > *To:* Oracle-L Freelists <oracle-l@(protected)> > *Sent:* Tuesday, November 01, 2005 4:43 PM > *Subject:* Multiple Instance issue > > 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 > >
yes both are on the same ORACLE_HOME.<br><br> <div><span class="gmail_quote">On 11/1/05, <b class="gmail_sendername"><a href= "mailto:t_adolph@(protected)">t_adolph@(protected)</a></b> <<a href="mailto:t _adolph@(protected)">t_adolph@(protected)</a>> wrote:</span>
<div style="FONT: 10pt arial"><b>To:</b> <a title="oracle-l@(protected)" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:oracle-l @(protected)" target="_blank">Oracle-L Freelists</a> </div> <div style="FONT: 10pt arial"><b>Sent:</b> Tuesday, November 01, 2005 4:43 PM< /div> <div style="FONT: 10pt arial"><b>Subject:</b> Multiple Instance issue</div> <div><br> </div> <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></blockquote></span></div></blockquote></div><br>
