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 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 To: Oracle-L Freelists 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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> <META content="MSHTML 6.00.2800.1522" name=GENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=#ffffff> <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> <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; font-color: black"><B>From:</B> <A title=t_adolph@(protected) href="mailto:t_adolph@(protected)">t_adolph@(protected)</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=chiragdba@(protected) href="mailto:chiragdba@(protected)">chiragdba@(protected)</A> ; <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">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; font-color: black"><B>From:< /B> <A title=chiragdba@(protected) href="mailto:chiragdba@(protected)">Chirag DBA</A> </DIV> <DIV style="FONT: 10pt arial"><B>To:</B> <A title=oracle-l@(protected) href="mailto:oracle-l@(protected)">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></BODY></HTML>
