Hello !<\/p>\n\n\n
Got this issue when checking alert log:<\/p>\n\n\n
BEGIN EM_LOADERJOB.unlock_target(hextoraw(:1 )); END;\nAdditional information: hd=0xfc429b90 phd=0x63888408 flg=0x100476 cisid=107 sid=107 ciuid=107 uid=107\n2020-01-14T16:36:37.705267-06:00\nWARNING: too many parse errors, count=148547900 SQL hash=0x7533e331\nPARSE ERROR: ospid=25178, error=6550 for statement:\n2020-01-14T16:36:37.705493-06:00<\/pre>\n\n\nAnd this repeat each 5 seconds. Around 1 month my alert log reached 100M and got other error – <\/p>\n\n\n
Alert log is 100.088027954102M, consider using rotate_generic.pl<\/pre>\n\n\nSolution for this error:<\/p>\n\n\n
First – check if your package EM_LOADERJOB have the procedure UNLOCK_TARGET<\/p>\n\n\n
col owner for a25
col object_name for a25
col PROCEDURE_NAME for a35
col OBJECT_TYPE for a25
set lines 200
SELECT Owner,
Object_Name,
Procedure_Name,
Object_Type
FROM DBA_Procedures
WHERE Object_Name = ‘EM_LOADERJOB’
ORDER BY Procedure_Name
\/<\/p>\n\n\nSample Output:<\/p>\n\n\n
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<\/p>\n\n\nIf not – Copy the procedure contents from another OEM database.<\/p>\n\n\n
Follow the steps below:<\/p>\n\n\n
Please ensure a full database backup is take prior to proceeding
—————————————-<\/p>\n\n\nLogin in to EM Console:<\/p>\n\n\n
1a. Navigate to Targets -> Databases -> click on Repository database -> Schema -> Programs -> Package Bodies -> Select schema name as SYSMAN and object name as “EM_LOADERJOB” –> click Search<\/p>\n\n\n
2b. Here you will see the EM_LOADERJOB package, click Edit.<\/p>\n\n\n
Find the uploaded EM_LOADERJOB_packge_body attachment, copy it and past it in the “Source” Box and click apply.<\/p>\n\n\n
3c. On the right side of the page select object_type as “packages” — drop down button –> Select schema name as SYSMAN and object name as “EM_LOADERJOB” –> click Search<\/p>\n\n\n
3) We can see the EM_LOADERJOB package, click Edit.<\/p>\n\n\n
Find the uploaded EM_LOADERJOB_packge_definition attachment, copy it and past it in the “Source” Box and click apply.<\/p>\n\n\n
3. Connect to Repository as SYSMAN and run the below query again.<\/p>\n\n\n
col owner for a25
col object_name for a25
col PROCEDURE_NAME for a35
col OBJECT_TYPE for a25
set lines 200
SELECT Owner,
Object_Name,
Procedure_Name,
Object_Type
FROM DBA_Procedures
WHERE Object_Name = ‘EM_LOADERJOB’
ORDER BY Procedure_Name
\/<\/p>\n\n\nNow we can see the unlock_target procedure in the output. If so, Monitor the alert.log and check if the issue remains.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hello ! Got this issue when checking alert log: BEGIN EM_LOADERJOB.unlock_target(hextoraw(:1 )); END; Additional information: hd=0xfc429b90 phd=0x63888408 flg=0x100476 cisid=107 sid=107 ciuid=107 uid=107 2020-01-14T16:36:37.705267-06:00 WARNING: too many parse errors, count=148547900 SQL hash=0x7533e331 PARSE ERROR: ospid=25178, error=6550 for statement: 2020-01-14T16:36:37.705493-06:00 And this … Continue lendo