OraFAQ Forum: Server Administration » finding all databases at os level

Home » RDBMS Server » Server Administration » finding all databases at os level (oracle10g, Linux AS4)

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

finding all databases at os level [message #381275]

Fri, 16 January 2009 01:59

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

Hi,

How to find all the instances (already running and not running) at os level.

I tried with the following cmd.

$ ps -ef | grep pmon

But the output is only running instances. I want to find all the instances.

Regards,
suresh

Report message to a moderator

Re: finding all databases at os level [message #381277 is a reply to message #381275]

Fri, 16 January 2009 02:12

surachart
Messages: 19
Registered: December 2008

Junior Member

ps -aef | grep pmon

If you find one process...
that's mean your machine has one instance ... running.

Report message to a moderator

Re: finding all databases at os level [message #381278 is a reply to message #381277]

Fri, 16 January 2009 02:15

suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad

Member

I want to know how many databases are present in my server from os level. How to find this.

Regards,
suresh

Report message to a moderator

Re: finding all databases at os level [message #381280 is a reply to message #381278]

Fri, 16 January 2009 02:23

surachart
Messages: 19
Registered: December 2008

Junior Member

Check fron pfile and spfile
You can go to $ORACLE_HOME/dbs PATH.
$ ls init*
$ ls spfile*

Or use "dbca" command and then check from window screen.

Report message to a moderator

Re: finding all databases at os level [message #381284 is a reply to message #381278]

Fri, 16 January 2009 02:34

Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

suresh.wst wrote on Fri, 16 January 2009 09:15

I want to know how many databases are present in my server from os level. How to find this.

Regards,
suresh

There is no way to get a sure list.

Regards
Michel

Report message to a moderator

Re: finding all databases at os level [message #381369 is a reply to message #381280]

Fri, 16 January 2009 08:34

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

surachart wrote on Fri, 16 January 2009 03:23

Check fron pfile and spfile
You can go to $ORACLE_HOME/dbs PATH.
$ ls init*
$ ls spfile*

This will not work when you have multiple ORACLE_HOME's.

Report message to a moderator

Re: finding all databases at os level [message #381372 is a reply to message #381369]

Fri, 16 January 2009 08:39

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

plus the init.ora / spfile don't have to be in that directory.

Report message to a moderator

Re: finding all databases at os level [message #383208 is a reply to message #381275]

Tue, 27 January 2009 14:22

Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida

Senior Member

If this is your box, then you should know what is installed. Else check the ORATAB file (provided that it is up to date).

Else look at the pfiles as mentioned before here.

looking for pmon processes will tell you what is up and running.
--
Sanjay B.

[Updated on: Tue, 27 January 2009 14:23]

Report message to a moderator

Previous Topic:	I've got the ORA-600 error, but metalink can not help me much more!
Next Topic:	Difference in connecting as sqlplus / as sysdba, sqlplus "/ as sysdba" and sqlplus '/ as

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 21:04:39 CST 2024