OraFAQ Forum: Server Administration » Connect to idle instance

Home » RDBMS Server » Server Administration » Connect to idle instance (Oracle 11g, Sun solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connect to idle instance [message #506784]

Wed, 11 May 2011 05:38

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

Hi DBA's,

Getting the below message even after doing the

oracle@ttlwaurd001:~$ ps -ef | grep pmon
oracle 7779 1 0 Feb08 ? 00:00:07 ora_pmon_WGRGOLD1
oracle 10155 1 0 Feb20 ? 00:30:48 ora_pmon_DPTLS01
oracle 12354 1 0 Feb20 ? 00:00:53 ora_pmon_DOEMS01
oracle 17902 1 0 Feb20 ? 00:00:13 ora_pmon_DREPS01
oracle 23745 23360 0 19:51 pts/4 00:00:00 grep pmon
oracle@ttlwaurd001:~$
oracle@ttlwaurd001:~$ sqlplus '/as sysdba'

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 19:49:54 2011

Copyright 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

oracle@ttlwaurd001:~$ echo $ORACLE_SID
DPTLS01

HELP REQUIRED

Report message to a moderator

Re: Connect to idle instance [message #506785 is a reply to message #506784]

Wed, 11 May 2011 05:47

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

There's no error there....So what is the question?

Does the below help?

SYS@ORA11GMK AS SYSDBA> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@ORA11GMK AS SYSDBA> exit
Disconnected from Personal Oracle Database 11g Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

C:\Documents and Settings\mkr02\Desktop>sqlplus sys/****** as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Wed May 11 11:47:40 2011

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to an idle instance.

[Updated on: Wed, 11 May 2011 05:49]

Report message to a moderator

Re: Connect to idle instance [message #506786 is a reply to message #506785]

Wed, 11 May 2011 05:50

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

after giving the ps -ef| grep pmon we can see the number of process running.

i had did the export ORACLE_SID=DPTLS01

and then tried to connect

sqlplus /as sysdba

i get the message

"Connected to an idle instance."

even to my ORACLE_SID is pointing to a db.

help me if I am missing something here.

Report message to a moderator

Re: Connect to idle instance [message #506787 is a reply to message #506786]

Wed, 11 May 2011 05:52

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

Have you got multiple oracle homes?

Report message to a moderator

Re: Connect to idle instance [message #506788 is a reply to message #506786]

Wed, 11 May 2011 05:52

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

You are connected, there is no error. The database just needs starting. Currently its unmounted and closed.

That's not an error though...

Edit: I'm assuming the "IDLE INSTANCE" is the focus of the question

[Updated on: Wed, 11 May 2011 05:53]

Report message to a moderator

Re: Connect to idle instance [message #506790 is a reply to message #506788]

Wed, 11 May 2011 05:55

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

the can see the database is running when I use the ps -ef | grep pmon.

is there any other way.

Report message to a moderator

Re: Connect to idle instance [message #506791 is a reply to message #506790]

Wed, 11 May 2011 05:56

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

The instance is running, the database is closed and unmounted.

Report message to a moderator

Re: Connect to idle instance [message #506794 is a reply to message #506791]

Wed, 11 May 2011 05:58

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

the database is opened, as other users are able to access, but why not me?

Report message to a moderator

Re: Connect to idle instance [message #506795 is a reply to message #506788]

Wed, 11 May 2011 05:58

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

If the DB was closed pmon wouldn't be running would it?

Report message to a moderator

Re: Connect to idle instance [message #506796 is a reply to message #506795]

Wed, 11 May 2011 05:59

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

now you got it cookiemonster....

so help me out how to I get to resolve this.

Report message to a moderator

Re: Connect to idle instance [message #506798 is a reply to message #506787]

Wed, 11 May 2011 06:00

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

cookiemonster wrote on Wed, 11 May 2011 11:52

Have you got multiple oracle homes?

Report message to a moderator

Re: Connect to idle instance [message #506799 is a reply to message #506798]

Wed, 11 May 2011 06:00

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

yes...

Report message to a moderator

Re: Connect to idle instance [message #506800 is a reply to message #506799]

Wed, 11 May 2011 06:02

madhusudankowlgi
Messages: 7
Registered: May 2011
Location: India

Junior Member

mgkowlgi@gmail.com

the db's I am working are dev db's...and are same as prod env.

Report message to a moderator

Re: Connect to idle instance [message #506803 is a reply to message #506800]

Wed, 11 May 2011 06:06

cookiemonster
Messages: 13922
Registered: September 2008
Location: Rainy Manchester

Senior Member

You've probably got the wrong oracle home set.

Report message to a moderator

Re: Connect to idle instance [message #506816 is a reply to message #506800]

Wed, 11 May 2011 06:34

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Quoting cookiemonster

You've probably got the wrong oracle home set.

Most probably.
The simplest way to use pwdx with PID to find the oracle home used.
Something like this.



oracle@lars#ps -ef | grep smon
  oracle   242     1   0   Dec 04 ?           8:52 asm_smon_+ASM
  oracle  7776     1   0   Dec 30 ?          22:20 ora_smon_larstest
  oracle  3619     1   0   Jan 12 ?          20:27 ora_smon_dwtest
  oracle  7138     1   0   Dec 29 ?          20:36 ora_smon_dev
  oracle  7310     1   0   Dec 29 ?          25:20 ora_smon_apex
  oracle  6850     1   0   Dec 29 ?          16:46 ora_smon_upg11
  oracle 13677 13612   0 07:27:24 pts/1       0:00 grep smon
  oracle  7232     1   0   Dec 29 ?          20:04 ora_smon_install

oracle@lars#pwdx  7776 
7776:   /u01/base/product/11.2.0/dbhome_1/dbs

#or use this one liner that i frequently use for my other stuff.

oracle@lars#pgrep -lf smon  | awk '{print $1" "substr($2,10)}' | while read thisPid thisSid ; do echo $thisSid is docked in `pwdx $thisPid | awk -F":" '{print $2}'`; done
+ASM is docked in /u01/base/product/11.2.0/grid2/dbs
larstest is docked in /u01/base/product/11.2.0/dbhome_1/dbs
dwtest is docked in /u01/base/product/11.2.0/dbhome_1/dbs
dev is docked in /u01/base/product/11.2.0/dbhome_1/dbs
apex is docked in /u01/base/product/11.2.0/dbhome_1/dbs
upg11 is docked in /u01/base/product/11.2.0/dbhome_1/dbs
install is docked in /u01/base/product/11.2.0/dbhome_1/dbs

Report message to a moderator

Re: Connect to idle instance [message #506821 is a reply to message #506816]

Wed, 11 May 2011 06:52

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Apologies, hadn't noticed the pmon thread, prejudiced by title Embarassed

Embarassed

Report message to a moderator

Previous Topic:	Mermory prcentage
Next Topic:	TX Lock Wait time disappears when gather stat is run

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 17:18:25 CDT 2024