Re: Multiple Instance issue

From: Chirag DBA <chiragdba_at_gmail.com>
Date: Tue, 1 Nov 2005 11:51:58 -0500
Message-ID: <1a3629600511010851o746cd441oef4dd3bfaee38a68@mail.gmail.com>

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_at_tiscali.de> 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_at_hotmail.com
> *To:* chiragdba_at_gmail.com ; Oracle-L Freelists <oracle-l_at_freelists.org>
> *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_at_gmail.com>
> *To:* Oracle-L Freelists <oracle-l_at_freelists.org>
> *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
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 01 2005 - 10:55:19 CST