Home » RDBMS Server » Enterprise Manager » OEM status check through PL/SQL procedure
OEM status check through PL/SQL procedure [message #313694] Mon, 14 April 2008 04:02 Go to next message
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 Go to previous messageGo to next message
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 #313766 is a reply to message #313694] Mon, 14 April 2008 08:32 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
I guess you can write an external procedure that executes the command and returns the status. Nevertheless, that would be quite a lot of work. Why do you need to do this in a database procedure?
Re: Check OEM status through procedure [message #313933 is a reply to message #313766] Tue, 15 April 2008 04:25 Go to previous messageGo to next message
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,
Re: Check OEM status through procedure [message #313960 is a reply to message #313933] Tue, 15 April 2008 06:16 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
See http://download-east.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg11rtn.htm#997854
Previous Topic: Db console cost?
Next Topic: Enterprise manager deinstallation
Goto Forum:
  


Current Time: Tue Dec 06 12:19:32 CST 2016

Total time taken to generate the page: 0.11958 seconds