OraFAQ Forum: Server Administration » Need to configure watchdog for Oracle DB 11g on Redhat linux

Home » RDBMS Server » Server Administration » Need to configure watchdog for Oracle DB 11g on Redhat linux (Oracle DB 11g, Redhat linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490897]

Fri, 28 January 2011 01:54

sumittambekar
Messages: 5
Registered: January 2011

Junior Member

Hi,

I need to configure a watchdog (or any other) utility which will constantly monitor database health. And if something goes wrong with the database, the utility should restart the DB instance.

Can anyone please help me on this ?

Thanks,
Sumit

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490899 is a reply to message #490897]

Fri, 28 January 2011 02:07

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

You could use Oracle Restart, it is the 11.2 facility for doing just that.

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490906 is a reply to message #490899]

Fri, 28 January 2011 02:42

sumittambekar
Messages: 5
Registered: January 2011

Junior Member

Thank you John.
But can it be used as a monitoring tool ?
Do I need to write a unix script which will monitor the log file generated by DB; and need to take action accordingly ?

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490914 is a reply to message #490897]

Fri, 28 January 2011 02:59

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Define "something goes wrong".

Regards
Michel

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490915 is a reply to message #490914]

Fri, 28 January 2011 03:02

sumittambekar
Messages: 5
Registered: January 2011

Junior Member

Hi Michel,

By "something goes wrong" I mean if DB server is facing any issue or if it have stopped functioning or CPU utilization is very high.

Thanks,
Sumit

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490932 is a reply to message #490915]

Fri, 28 January 2011 03:41

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Define "issue".
You have to precisely define each type of action you want for each type of "issue" you define.
"database is shutdown" is an example of issue, what should be the action in this case? Is it possible to make an automatic action? Maybe the first action should be to know the reason, is this possible to do it automatically?
"CPU utilization is high" for me it is not a problem, it is the indication that I use what I have paid for. But run queue is high is an indication that I have not CPU enough. Once again what could be the action? Is it possible to do it automatically? In your first post you say, "the utility should restart the DB instance", are you sure this is the correct way to solve this CPU problem?

Regards
Michel

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490935 is a reply to message #490932]

Fri, 28 January 2011 03:58

sumittambekar
Messages: 5
Registered: January 2011

Junior Member

Hi Michel,

Sorry I mixed-up many issues in my last post.
For me "if database is shutdown or it have stopped working, the utility should automatically restart the DB & should also send an email to admin person" is important.
In rest other scenarios (for example - CPU utilization is very high), I need to send an email to admin person.

Thanks,
Sumit

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490936 is a reply to message #490935]

Fri, 28 January 2011 04:02

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Create a SHELL script that check each point you want to check, then execute the action you want to execute in this case, and put this script in the crontab.

Regards
Michel

Report message to a moderator

Re: Need to configure watchdog for Oracle DB 11g on Redhat linux [message #490939 is a reply to message #490936]

Fri, 28 January 2011 04:14

sumittambekar
Messages: 5
Registered: January 2011

Junior Member

Thank you Michel Smile

Report message to a moderator

Previous Topic:	setup Remote DB
Next Topic:	ORA-03113: end-of-file on communication channel

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 23:16:25 CDT 2024