Re: Multiple Instance issue

  • From: Chirag DBA <chiragdba@xxxxxxxxx>
  • To: "t_adolph@xxxxxxxxxxx" <t_adolph@xxxxxxxxxxx>
  • Date: Tue, 1 Nov 2005 11:50:25 -0500

yes both are on the same ORACLE_HOME.

On 11/1/05, t_adolph@xxxxxxxxxxx <t_adolph@xxxxxxxxxxx> wrote:
>
> 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
>
>

Other related posts: