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

    Login

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top