Home » RDBMS Server » Server Administration » total server
total server [message #192267] Mon, 11 September 2006 11:35 Go to next message
vijaychauhan
Messages: 106
Registered: December 2005
Senior Member
hi!
Is there any way to find out how many oracle servers are located on a particular host using sql query on linux platform?
Re: total server [message #192272 is a reply to message #192267] Mon, 11 September 2006 11:46 Go to previous messageGo to next message
goudelly
Messages: 52
Registered: August 2006
Location: India
Member

Hi,

ps -ef | grep oracle
ps -ef | grep smon

like thsi check oracle as well as background process in oracle.

thanks,

Mohan Reddy G
Re: total server [message #192273 is a reply to message #192267] Mon, 11 September 2006 11:47 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> using sql query on linux platform
Nope.
The sql will talk to only one database. Unless you have a database link to all other databases , you cannot do it.
>>Is there any way to find out how many oracle servers are located on a particular host
You can check the oratab file.
For every database created, there should be an entry here.
But, it is not a reliable method. Anyone with proper access can edit/remove those entries.
Previous Topic: Inserting data into a table - Slow Performance
Next Topic: Diskspace question on NAS
Goto Forum:
  


Current Time: Sun Dec 11 07:59:01 CST 2016

Total time taken to generate the page: 0.07082 seconds