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; 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> < > 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) <mailto: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
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=us-ascii"> <META content="MSHTML 6.00.2800.1522" name=GENERATOR></HEAD> <BODY> <DIV dir=ltr align=left><SPAN class=808594519-01112005><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 class=808594519-01112005><FONT face=Arial color=#0000ff></FONT></SPAN> </DIV> <DIV dir=ltr align=left><SPAN class=808594519-01112005><FONT face=Arial color=#0000ff>korn shell version</FONT></SPAN></DIV> <DIV dir=ltr align=left><SPAN class=808594519-01112005><FONT face=Arial color=#0000ff>export ORACLE_SID=MYDB</FONT></SPAN></DIV> <DIV> </DIV> <DIV><SPAN class=808594519-01112005></SPAN><FONT face=Arial><FONT color=#0000ff>H<SPAN class=808594519-01112005>TH -- Mark D Powell --</SPAN></FONT></FONT><BR></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <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 pop.tiscali.de; t_adolph@(protected); Oracle-L Freelists<BR><B>Subject:</B> Re: Multiple Instance issue<BR></FONT><BR></DIV> <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 href="mailto:belvdr@(protected)">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 href="mailto:chiragdba@(protected)">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 href="http://pop.tiscali.de">pop.tiscali.de</A> <<A href="http://pop.tiscali.de">http://pop.tiscali.de</A>> <<BR>> <A href="mailto:adolph.tony@(protected)">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 href="mailto:t_adolph@(protected)">t_adolph@(protected)</A><BR>> > *To: * <A href="mailto:chiragdba@(protected)">chiragdba@(protected)</A> ; Oracle-L Freelists < <A href="mailto:oracle-l@(protected)">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 href="mailto:chiragdba@(protected)">chiragdba@(protected)</A>><BR>> > *To:* Oracle-L Freelists <<A href="mailto:oracle-l@(protected)"> 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 href="http://farechase.yahoo.com">http://farechase.yahoo.com</A><BR>< /BLOCKQUOTE></DIV><BR></BODY></HTML>
