As I said it is up and running, Here is the output. SQL> select * from v$instance;
INSTANCE_NUMBER INSTANCE_NAME -- ---- ---- -- -- ---- ---- --- HOST_NAME -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ -- ---- ---- ---- -- ------ -- ---- ---- --- -- ---- -- -- ---- -- ---- --- LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST -- ---- -- --- -- ---- ---- ---- -- ---- ---- ----- -- ------ 1 chirep WSLVNJTO2775 9.2.0.1.0 01-NOV-05 OPEN NO 1 STARTED ALLOWED NO ACTIVE PRIMARY_INSTANCE NORMAL
SQL> It was fine, and I have not even installed or removed anything which can cause problem. Nothing in alert log too. I restarted with right pfile again, still the same issue. regards - chirag
On 11/1/05, NEW pop.tiscali.de <http://pop.tiscali.de> < adolph.tony@(protected)> wrote: > > What do you get if you run "select * from v$instance" from the 'other' > window, the one where you know it is already running? > > -- -- Original Message -- -- > *From:* t_adolph@(protected) > *To:* chiragdba@(protected) ; Oracle-L Freelists <oracle-l@(protected)> > *Sent:* Tuesday, November 01, 2005 4:56 PM > *Subject:* Re: Multiple Instance issue > > 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 > >
<div>As I said it is up and running, Here is the output. </div> <div>SQL> select * from v$instance;</div> <p>INSTANCE_NUMBER INSTANCE_NAME<br>-- ---- ---- -- -- ---- ---- ---<br>HOST _NAME<br>-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------<br >VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_ <br>-- ---- ---- ---- -- ------ -- ---- ---- --- -- ---- -- -- ---- -- ---- --- <br>LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST<br>-- ---- -- --- -- ---- ---- ---- --- -- ---- ---- -- -- ------<br> 1 chirep <br>WSLVNJTO2775<br>9.2.0.1.0 01-NOV-05 OPEN NO 1 STARTED<br>ALLOWED   ; NO ACTIVE PRIMARY_INSTANCE NORMAL</p> <p><br>SQL></p> <div>It was fine, and I have not even installed or removed anything which can cause problem.</div> <div> </div> <div>Nothing in alert log too. I restarted with right pfile again, still the same issue.</div> <div> </div> <div>regards - chirag <br><br> </div> <div><span class="gmail_quote">On 11/1/05, <b class="gmail_sendername">NEW <a href="http://pop.tiscali.de">pop.tiscali.de</a></b> <<a href="mailto:adolph .tony@(protected)">adolph.tony@(protected)</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div><font face="Arial" size="2">What do you get if you run "select * from v$instance" from the 'other' window, the one where you know it is already running?</font></div> <div><span class="e" id="q_1074c94e3a2eef7f_1"> <blockquote dir="ltr" style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT : 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <div style="FONT: 10pt arial">-- -- Original Message -- -- </div> <div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title="t _adolph@(protected)" onclick="return top.js.OpenExtLink(window,event,this)" href ="mailto:t_adolph@(protected)" target="_blank">t_adolph@(protected) </a> </div> <div style="FONT: 10pt arial"><b>To:</b> <a title="chiragdba@(protected)" onclick ="return top.js.OpenExtLink(window,event,this)" href="mailto:chiragdba@(protected) " target="_blank">chiragdba@(protected)</a> ; <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:56 PM< /div> <div style="FONT: 10pt arial"><b>Subject:</b> Re: Multiple Instance issue</div> <div><br> </div> <div><font face="Arial" size="2">Are they both running under the same ORACLE _HOME?</font></div> <div><font face="Arial" size="2"></font> </div> <div><font face="Arial" size="2">Tony</font></div> <blockquote dir="ltr" style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT : 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px"> <div style="FONT: 10pt arial">-- -- Original Message -- -- </div> <div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title= "chiragdba@(protected)" onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:chiragdba@(protected)" target="_blank">Chirag DBA</a> </div>
<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></blockquote></span></div>< /blockquote></div><br>
