| OEM status check through PL/SQL procedure [message #313694] |
Mon, 14 April 2008 04:02  |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
Hi,
To check the status of OEM i use the following command.
oracle@linux:~> emctl status dbconsole
This command which i mentined is OS command.
But i want to check this in the procedure. How can i check this in the procedure?
Or is there any oracle package exists?
Thanks in advance.
|
|
|
|
| To check OEM agent status through PLSQL [message #313709 is a reply to message #313694] |
Mon, 14 April 2008 04:50  |
suhasSonawane
Messages: 1
Registered: April 2008
Location: Pune
|
Junior Member |
|
|
Hi All,
I want to check OEM agent status through PL/SQL procedure for that i have written a procedure. which looks for DBSNMP sessions, and if it finds none, reports the agent down; however, the some of the databases don't have DBSNMP sessions running, even though the agent is running.
Is there any other way to check OEM status through PL/SQL?
Thanks in advance.
|
|
|
|
|
|
| Re: Check OEM status through procedure [message #313933 is a reply to message #313766] |
Tue, 15 April 2008 04:25 |
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
|
Senior Member |
|
|
Thanks Frank for your reply.
Actually i am working with 150 databases and i want to check status of OEM at every database.
For that i have dblink for every database.
So if i can check through oracle package if any then it will be easy task for me to check OEM status.
Otherwise i need to connect to every terminal and need to execute the command at command prompt.
And as you suggests
| Quote: | you can write an external procedure that executes the command and returns the status.
|
How can i do that?
Thanks,
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
