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?

Report message to a moderator

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

Report message to a moderator

Re: total server [message #192273 is a reply to message #192267] Mon, 11 September 2006 11:47 Go to previous message
Mahesh Rajendran
Messages: 10708
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.

Report message to a moderator

Previous Topic: Inserting data into a table - Slow Performance
Next Topic: Diskspace question on NAS
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 05 00:37:03 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.