Ask the Expert

DBMS JOB Configuration error in RAC system

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."

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: