Home » RDBMS Server » Server Administration » finding all databases at os level (oracle10g, Linux AS4)
finding all databases at os level [message #381275] Fri, 16 January 2009 01:59 Go to next message
suresh.wst
Messages: 48
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
Re: finding all databases at os level [message #381277 is a reply to message #381275] Fri, 16 January 2009 02:12 Go to previous messageGo to next message
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.


Re: finding all databases at os level [message #381278 is a reply to message #381277] Fri, 16 January 2009 02:15 Go to previous messageGo to next message
suresh.wst
Messages: 48
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
Re: finding all databases at os level [message #381280 is a reply to message #381278] Fri, 16 January 2009 02:23 Go to previous messageGo to next message
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.
Re: finding all databases at os level [message #381284 is a reply to message #381278] Fri, 16 January 2009 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: finding all databases at os level [message #381369 is a reply to message #381280] Fri, 16 January 2009 08:34 Go to previous messageGo to next message
joy_division
Messages: 4641
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.
Re: finding all databases at os level [message #381372 is a reply to message #381369] Fri, 16 January 2009 08:39 Go to previous messageGo to next message
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.
Re: finding all databases at os level [message #383208 is a reply to message #381275] Tue, 27 January 2009 14:22 Go to previous message
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:
  


Current Time: Wed Dec 07 04:50:16 CST 2016

Total time taken to generate the page: 0.06173 seconds