EM_LOADERJOB.unlock_target(hextoraw(:1 )) error=6550 for statement

Recently when removed an old target (Oracle RDBMS 11g target) the Enterprise Manager Cloud repository starts to through below error messages

POEMREP(5):WARNING: too many parse errors, count=66200 SQL hash=0x7533e331
POEMREP(5):PARSE ERROR: ospid=10982, error=6550 for statement: 
2019-01-17T16:18:40.454989+01:00
POEMREP(5):BEGIN EM_LOADERJOB.unlock_target(hextoraw(:1 )); END;
POEMREP(5):Additional information: hd=0x184b613b0 phd=0x196281148 flg=0x100476 cisid=107 sid=107 ciuid=107 uid=107 
2019-01-17T16:18:45.713905+01:00
POEMREP(5):WARNING: too many parse errors, count=66300 SQL hash=0x7533e331
POEMREP(5):PARSE ERROR: ospid=10982, error=6550 for statement: 
2019-01-17T16:18:45.714134+01:00
POEMREP(5):BEGIN EM_LOADERJOB.unlock_target(hextoraw(:1 )); END;
POEMREP(5):Additional information: hd=0x184b613b0 phd=0x196281148 flg=0x100476 cisid=107 sid=107 ciuid=107 uid=107 
2019-01-17T16:18:50.933014+01:00

Checking out support.oracle.com I found one report bug, not explaining how to fix but a hint was provide: Bug 28534250 : EM13cR2: “Too many parse errors” in repo DB every 5 seconds

SELECT Owner, Object_Name, Procedure_Name, Object_Type FROM DBA_Procedures WHERE Object_Name = 'EM_LOADERJOB' ORDER BY Procedure_Name;

OWNER OBJECT_NAME PROCEDURE_NAME OBJECT_TYPE
---------- --------------- -------------------- -------------
SYSMAN EM_LOADERJOB DEQUEU_JOB PACKAGE
SYSMAN EM_LOADERJOB LOADERJOB_LOG PACKAGE
SYSMAN EM_LOADERJOB RELEASE_TARGET_LOCK PACKAGE
SYSMAN EM_LOADERJOB SUBMIT_JOB PACKAGE
SYSMAN EM_LOADERJOB UPDATE_DQ_TIME PACKAGE
SYSMAN EM_LOADERJOB UPDATE_END_TIME PACKAGE
SYSMAN EM_LOADERJOB UPDATE_JOB_STATUS PACKAGE
SYSMAN EM_LOADERJOB PACKAGE

8 rows selected.


To fix the above errors/issue executed as repository owner (sysman) the following 2 scripts.
sql> @/u01/app/oracle/product/13.2.0/mw_100/sysman/admin/emdrep/sql/core/latest/loaderjob/loaderjob_pkgbody.sql
sql> @/u01/app/oracle/product/13.2.0/mw_100/sysman/admin/emdrep/sql/core/latest/loaderjob/loaderjob_pkgdef.sql

Performed a recompile of the em_loaderjob package

alter package sysman.em_loaderjob compile;

And now:

OWNER OBJECT_NAME PROCEDURE_NAME OBJECT_TYPE
———- ————— ————————- ————-
SYSMAN EM_LOADERJOB DELETE_PROCESSED_PAYLOADS PACKAGE
SYSMAN EM_LOADERJOB DEQUEU_JOB PACKAGE
SYSMAN EM_LOADERJOB LOADERJOB_LOG PACKAGE
SYSMAN EM_LOADERJOB PURGE_EXECLOADER_BACKLOG PACKAGE
SYSMAN EM_LOADERJOB RELEASE_LOCKED_TARGETS PACKAGE
SYSMAN EM_LOADERJOB RELEASE_TARGET_LOCK PACKAGE
SYSMAN EM_LOADERJOB SUBMIT_JOB PACKAGE
SYSMAN EM_LOADERJOB UNLOCK_TARGET PACKAGE
SYSMAN EM_LOADERJOB UPDATE_DQ_TIME PACKAGE
SYSMAN EM_LOADERJOB UPDATE_END_TIME PACKAGE
SYSMAN EM_LOADERJOB UPDATE_JOB_STATUS PACKAGE

OWNER OBJECT_NAME PROCEDURE_NAME OBJECT_TYPE
———- ————— ————————- ————-
SYSMAN EM_LOADERJOB PACKAGE

12 rows selected.

After a few minutes no more error message in the alert.log

24 januari 2019|12c, 18c, rdbms|

Leave A Comment