FreeLists / oracle-l / Re: Multiple Instance issue

["NEW pop.tiscali.de" <adolph.tony@xxxxxxxxxx>]

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 
  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