Re: Multiple Instance issue
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: mark.powell@xxxxxxx
- Date: Tue, 1 Nov 2005 15:11:32 -0500
This is Windows Mark. and I am setting them like
set ORACLE_SID=chirep
set ORACLE_HOME=C:\Oracle\Ora92
I am trying to change the registery with the default DB name, if that can
help me.
Seems like this environment is screwed up.
regards - Chirag
On 11/1/05, Powell, Mark D <mark.powell@xxxxxxx> wrote:
>
> When you set the Oracle environment variables did you export them?
> korn shell version
> export ORACLE_SID=MYDB
> HTH -- Mark D Powell --
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Chirag DBA
> *Sent:* Tuesday, November 01, 2005 2:41 PM
> *To:* Thomas Fox
> *Cc:* NEW pop.tiscali.de <http://pop.tiscali.de/>; t_adolph@xxxxxxxxxxx;
> Oracle-L Freelists
> *Subject:* Re: Multiple Instance issue
>
> Both are correct and showing the right things.
> Set them again, and tried as follows.
> C:\DOCUME~1\CMAJMU~1>sqlplus /nolog
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 14:24:01 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> conn / as sysdba
> Connected to an idle instance.
> SQL> startup
> ORA-01081: cannot start already-running ORACLE - shut it down first
> SQL> shutdown abort
> ORACLE instance shut down.
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 105978600 bytes
> Fixed Size 453352 bytes
> Variable Size 79691776 bytes
> Database Buffers 25165824 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
> Production
> With the Partitioning, OLAP and Oracle Data Mining options
> JServer Release 9.2.0.1.0 - Production
>
> C:\DOCUME~1\CMAJMU~1>sqlplus /nolog
>
> SQL*Plus: Release 9.2.0.1.0 - Production on Tue Nov 1 14:24:34 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
>
> SQL> conn / as sysdba
> Connected to an idle instance.
> I am unable to make out what is going wrong?
> Regards - Chirag
>
> On 11/1/05, Thomas Fox <belvdr@xxxxxxxxx> wrote:
> >
> > 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/> <
> > 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
> >
>
>
Other related posts:
