2012-01-23

ORA-20110: Unexpected error executing MGMT_SET_JOB_Q_PROC

Grid Control 11g: Post Install Script For PSU Patch 12423703 gives Error: "ORA-20110:Unexpected error executing MGMT_SET_JOB_Q_PROC" (Doc ID 1359157.1)

Applies to:

Enterprise Manager Base Platform - Version: 11.1.0.1 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

When applying post install script for the PSU Patch 12423703, getting the following error:

$ORACLE_HOME/bin/rcuJDBCEngine sysman@abcd:1521:EMREP JDBC_SCRIPT apply.sql $PWD $ORACLE_HOME
Please enter database password:
###### SQL Patching operation has started. The Pre-requisites check   ######
###### may take upto 3 minutes. Please do not cancel the operation.   ######
###### Refer to My Oracle Support note 1326515.1 for more information ######

##### Start Patch Pre-requisites Check ######
job_queue_processes value before patching
---------------- ---------------
SID              Job Queue value
---------------- ---------------
OEMB11           1000
--------------------------------

Error encountered. Cleaning up in prereq-check exception block
###### Patch Pre-requisites check FAILED. Exiting Patching process. ######


>>>A SQL Error occurred!
java.sql.SQLException: ORA-20110:  Unexpected error executing MGMT_SET_JOB_Q_PROC. Check if patch of Bug#12620174 has been applied. Error:ORA-06576: not a valid function or procedure name. Refer to My Oracle Support note 1326515.1 for additional information.
ORA-06512: at line 480
>>

Cause

Verified "opatch lsinventory" output from 11g OMS ORACLE_HOME which shows the Patch 12620174 is applied:

abcd:/oraem/11.1/oms11g/bin$opatch lsinventory |grep 12620174
Patch  12620174     : applied on Fri Sep 16 12:28:21 EST 2011
    12620174
If the Patch 12620174 is not applied, first apply this pre-requisite patch.
If the patch is already applied, then verify the repository database for the   object "MGMT_SET_JOB_Q_PROC". If this is not found, it indicates that the post install script from Patch 12620174 is not executed.

SQL> select owner, object_name, object_type, status from dba_objects where object_name like 'MGMT_SET_JOB_Q_PROC%';

no rows selected

Solution

Please follow the below steps to resolve the issue:

Apply the Patch 12620174 if it is not applied.
If the patch is already applied and missed to execute the post install script, then follow the steps:

1. Run the post install script from the Patch 12620174
2. Ensure that the "MGMT_SET_JOB_Q_PROC" object is created in the repository database
3. Now execute the post install script from Patch 12423703

Niciun comentariu:

Trimiteți un comentariu