Re: Multiple Instance issue
- From: Thomas Fox <belvdr@xxxxxxxxx>
- To: chiragdba@xxxxxxxxx, "NEW pop.tiscali.de" <adolph.tony@xxxxxxxxxx>
- Date: Tue, 1 Nov 2005 10:52:47 -0800 (PST)
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%
--- Chirag DBA <chiragdba@xxxxxxxxx> wrote:
> 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@xxxxxxxxxx> 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@xxxxxxxxxxx
> > *To:* chiragdba@xxxxxxxxx ; Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
> > *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@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
> >
> >
>
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
