| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Multiple Instance issue
You'll need to set your ORACLE_HOME as well, because Oracle uses a hash of the
ORACLE_HOME and ORACLE_SID to connect. If one or the other is not set, you
won't be connecting to the proper instance.
You can always check it with:
echo %ORACLE_HOME%
echo %ORACLE_SID%
> 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-lReceived on Tue Nov 01 2005 - 12:54:53 CST
 |
 |