This is Windows Mark. and I am setting them like set ORACLE_SID=chirep set ORACLE_HOME=C:\Oracle\Ora92 I am trying to change the registery with the default DB name, if that can help me. Seems like this environment is screwed up. regards - Chirag
On 11/1/05, Powell, Mark D <mark.powell@(protected)> wrote: > > When you set the Oracle environment variables did you export them? > korn shell version > export ORACLE_SID=MYDB > HTH -- Mark D Powell -- > -- ---- ---- ---- ---- ---- -- > *From:* oracle-l-bounce@(protected) [mailto: > oracle-l-bounce@(protected)] *On Behalf Of *Chirag DBA > *Sent:* Tuesday, November 01, 2005 2:41 PM > *To:* Thomas Fox > *Cc:* NEW pop.tiscali.de <http://pop.tiscali.de/>; t_adolph@(protected); > Oracle-L Freelists > *Subject:* Re: Multiple Instance issue > > Both are correct and showing the right things. > Set them again, and tried as follows. > C:\DOCUME~1\CMAJMU~1>sqlplus /nolog > > SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 14:24:01 2005 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > SQL> conn / as sysdba > Connected to an idle instance. > SQL> startup > ORA-01081 (See ORA-01081.ora-code.com): cannot start already-running ORACLE - shut it down first > SQL> shutdown abort > ORACLE instance shut down. > SQL> startup > ORACLE instance started. > > Total System Global Area 105978600 bytes > Fixed Size 453352 bytes > Variable Size 79691776 bytes > Database Buffers 25165824 bytes > Redo Buffers 667648 bytes > Database mounted. > Database opened. > SQL> exit > Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - > Production > With the Partitioning, OLAP and Oracle Data Mining options > JServer Release 9.2.0.1.0 - Production > > C:\DOCUME~1\CMAJMU~1>sqlplus /nolog > > SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 14:24:34 2005 > > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. > > SQL> conn / as sysdba > Connected to an idle instance. > I am unable to make out what is going wrong? > Regards - Chirag > > On 11/1/05, Thomas Fox <belvdr@(protected)> wrote: > > > > You'll need to set your ORACLE_HOME as well, because Oracle uses a hash > > of the > > ORACLE_HOME and ORACLE_SID to connect. If one or the other is not set, > > you > > won't be connecting to the proper instance. > > > > You can always check it with: > > > > echo %ORACLE_HOME% > > echo %ORACLE_SID% > > > > > > --- Chirag DBA <chiragdba@(protected) > wrote: > > > > > 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/> < > > 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 > > > > > > > > > > > > > > > > > > > > > __ ____ ____ ____ ____ ____ ______ > > Yahoo! FareChase: Search multiple travel sites in one click. > > http://farechase.yahoo.com > > > >
<div>This is Windows Mark. and I am setting them like</div> <div> </div> <div>set ORACLE_SID=chirep</div> <div>set ORACLE_HOME=C:\Oracle\Ora92</div> <div> </div> <div>I am trying to change the registery with the default DB name, if that can help me.</div> <div> </div> <div>Seems like this environment is screwed up.</div> <div> </div> <div>regards - Chirag <br><br> </div> <div><span class="gmail_quote">On 11/1/05, <b class="gmail_sendername">Powell, Mark D</b> <<a href="mailto:mark.powell@(protected)">mark.powell@(protected)</a>> wrote:</span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid"> <div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">When you set the Oracle environment variables did you export them?</font></span></div> <div dir="ltr" align="left"><span><font face="Arial" color="#0000ff"></font>< /span> </div> <div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">korn shell version</font></span></div> <div dir="ltr" align="left"><span><font face="Arial" color="#0000ff">export ORACLE_SID=MYDB</font></span></div> <div> </div> <div><span></span><font face="Arial"><font color="#0000ff">H<span>TH -- Mark D Powell --</span></font></font><br> </div> <div lang="en-us" dir="ltr" align="left"> <hr> <font face="Tahoma" size="2"><b>From:</b> <a onclick="return top.js.OpenExtLink (window,event,this)" href="mailto:oracle-l-bounce@(protected)" target="_blank" >oracle-l-bounce@(protected)</a> [mailto:<a onclick="return top.js.OpenExtLink (window,event,this)" href="mailto:oracle-l-bounce@(protected)" target="_blank" > oracle-l-bounce@(protected)</a>] <b>On Behalf Of </b>Chirag DBA<br><b>Sent:< /b> Tuesday, November 01, 2005 2:41 PM<br><b>To:</b> Thomas Fox<br><b>Cc:</b> NEW <a onclick="return top.js.OpenExtLink(window,event,this)" href="http://pop .tiscali.de/" target="_blank"> pop.tiscali.de</a>; <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:t_adolph@(protected)" target="_blank">t_adolph@(protected)</a>; Oracle-L Freelists <div><span class="e" id="q_1074d608d5756efc_1"><br><b>Subject:</b> Re: Multiple Instance issue<br></span></div></font><br> </div> <div><span class="e" id="q_1074d608d5756efc_3"> <div></div> <div>Both are correct and showing the right things.</div> <div> </div> <div>Set them again, and tried as follows.</div> <div> </div> <div>C:\DOCUME~1\CMAJMU~1>sqlplus /nolog</div> <p>SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 14:24:01 2005</p> <p>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.</p> <p>SQL> conn / as sysdba<br>Connected to an idle instance.<br>SQL> startup<br>ORA-01081 (See ORA-01081.ora-code.com): cannot start already-running ORACLE - shut it down first <br>SQL> shutdown abort<br>ORACLE instance shut down.<br>SQL> startup <br>ORACLE instance started.</p> <p>Total System Global Area 105978600 bytes<br>Fixed Size 453352 bytes<br>Variable Size 79691776 bytes<br>Database Buffers 25165824 bytes<br>Redo Buffers 667648 bytes <br>Database mounted.<br>Database opened.<br>SQL> exit<br>Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production<br>With the Partitioning, OLAP and Oracle Data Mining options<br>JServer Release 9.2.0.1.0 - Production</p> <p>C:\DOCUME~1\CMAJMU~1>sqlplus /nolog</p> <p>SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 14:24:34 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> <div>I am unable to make out what is going wrong?</div> <div> </div> <div>Regards - Chirag <br><br> </div> <div><span class="gmail_quote">On 11/1/05, <b class="gmail_sendername">Thomas Fox</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:belvdr@(protected)" target="_blank">belvdr@(protected)</a>> wrote: </span> <blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0 .8ex; BORDER-LEFT: #ccc 1px solid">You'll need to set your ORACLE_HOME as well, because Oracle uses a hash of the<br>ORACLE_HOME and ORACLE_SID to connect. If one or the other is not set, you <br>won't be connecting to the proper instance.<br><br>You can always check it with:<br><br>echo %ORACLE_HOME%<br>echo %ORACLE_SID%<br><br><br>--- Chirag DBA <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto :chiragdba@(protected)" target="_blank"> chiragdba@(protected)</a> > wrote:<br><br>> As I said it is up and running, Here is the output.<br>> SQL> select * from v$instance;<br>><br>> 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 <br>><br>><br>> SQL><br>> It was fine, and I have not even installed or removed anything which can<br>> cause problem.<br>> Nothing in alert log too. I restarted with right pfile again, still the<br > > same issue.<br>> regards - chirag<br>><br>>   ;On 11/1/05, NEW <a onclick="return top.js.OpenExtLink(window,event,this)" href= "http://pop.tiscali.de/" target="_blank">pop.tiscali.de</a> <<a onclick= "return top.js.OpenExtLink(window,event,this)" href="http://pop.tiscali.de/" target="_blank"> http://pop.tiscali.de</a>> <<br>> <a onclick="return top.js .OpenExtLink(window,event,this)" href="mailto:adolph.tony@(protected)" target=" _blank">adolph.tony@(protected)</a>> wrote:<br>> ><br>> > What do you get if you run "select * from v$instance" from the 'other' <br>> > window, the one where you know it is already running?<br>> > ; <br>> > -- -- Original Message -- --<br>> > *From:* <a onclick= "return top.js.OpenExtLink(window,event,this)" href="mailto:t_adolph@(protected) " target="_blank"> t_adolph@(protected)</a><br>> > *To:* <a onclick="return top.js .OpenExtLink(window,event,this)" href="mailto:chiragdba@(protected)" target=" _blank">chiragdba@(protected)</a> ; Oracle-L Freelists < <a onclick="return top .js.OpenExtLink(window,event,this)" href="mailto:oracle-l@(protected)" target= "_blank"> oracle-l@(protected)</a>><br>> > *Sent:* Tuesday, November 01, 2005 4:56 PM<br>> > *Subject:* Re: Multiple Instance issue<br>> ><br>> ; > Are they both running under the same ORACLE_HOME? <br>> > ; Tony <br>> ><br>> > -- -- Original Message -- --<br>> > *From:* Chirag DBA <<a onclick="return top.js.OpenExtLink(window,event,this)" href= "mailto:chiragdba@(protected)" target="_blank">chiragdba@(protected)</a> ><br>> > *To:* Oracle-L Freelists <<a onclick="return top.js .OpenExtLink(window,event,this)" href="mailto:oracle-l@(protected)" target=" _blank"> oracle-l@(protected)</a>><br>> > *Sent:* Tuesday, November 01, 2005 4:43 PM <br>> > *Subject:* Multiple Instance issue<br>> ><br>> >  ; I am running multiple instances on test machine, Windows, 9ir2. <br>> > Both have SGA of 100m and machine memory is 512 mb.<br>> > I am getting the following error. <br>> ><br>> > C:\DOCUME~1\CMAJMU~1>set ORACLE_SID=chirep<br>> ; ><br>> > C:\DOCUME~1\CMAJMU~1>sqlplus /nolog <br>> ><br>> > SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 10:39:26 2005 <br>> ><br>> > Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.<br>> ><br>> > SQL> conn / as sysdba <br>> > Connected to an idle instance.<br>> ><br>> > But the same instance is up and running in another windows, but in any new <br>> > window I am opening, this particular is instance is showing as <br>> ><br>> > Connected to Idle Instance.<br>> ><br>> > Can anyone tell me what could have gone wrong here? It was working fine <br>> > and I have not done any other installation in recent past. <br> > ><br>> > Nothing is showing in Alert log files too, as the same instance is running<br>> > in other window.<br>> ><br> > > regards - Chirag<br>> ><br>> ><br>><br><br> <br><br><br>__ ____ ____ ____ ____ ____ ______<br>Yahoo! FareChase: Search multiple travel sites in one click.<br><a onclick="return top.js.OpenExtLink (window,event,this)" href="http://farechase.yahoo.com/" target="_blank"> http://farechase.yahoo.com</a><br></blockquote></div><br></span></div>< /blockquote></div><br>
