Q

DBMS JOB Configuration error in RAC system

I experienced the following error in the database controller for my RAC system: "DBMS JOB Configuration. The Availability calculations for the cluster database target are disabled. Please enable the DBMS JOB EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS for Database Control."

I experienced the following error in the database controller for my RAC system (four nodes, RedHat EL4, OCFS2): "DBMS JOB Configuration. The Availability calculations for the cluster database target are disabled. Please enable the DBMS JOB EMD_MAINTENANCE.EXECUTE_EM_DBMS_JOB_PROCS for Database Control."

Apparently there is a problem with the SYSMAN owned dbms_job that executes this OEM procedure. Start by looking to see of the job is broken. You can unbreak it with dbms_job.broken(jobno,FALSE) procedure. If it begins failing and breaking again you will need to determine what is wrong in your configuration.

You may need to shutdown the Management Server(s), connect to the Grid repository and issue the exec emd_maintenance.remove_em_dbms_jobs, exec emd_maintenance.submit_em_dbms_jobs commands if you are getting hung statuses. But start by looking at the dbms_job itself. It may be something very simple like a manually broken job that needs to be unbroken.

Good luck.

This was first published in May 2007

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close