Re: Multiple Instance issue

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 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 To: Oracle-L Freelists 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