FreeLists / oracle-l / Re: Multiple Instance issue

[Chirag DBA <chiragdba@xxxxxxxxx>]

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@xxxxxxxxxx> 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@xxxxxxxxxxx
> *To:* chiragdba@xxxxxxxxx ; Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
> *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@xxxxxxxxx>
> *To:* Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
> *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
>
>