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)> > > *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 -- http://www.freelists.org/webpage/oracle-l
