Applying Patch 37057643 may cause ORA-00972
Hi sirs
After applying the following patch 37057643:
Oracle Enterprise Manager 13c Release 5 Update 25 ( 13.5.0.25 ) for Oracle Management Agent (System Patch)
causes the "ORA-00972: identifier is too long" error to appears on the "Database Job Status" metric on Database Target.
The problem occurs in file ../agent_13.5.0.0.0/plugins/oracle.sysman.db.agent.plugin_13.5.1.0.0/metadata/database.xmlp
between lines 5271 and 5327 in these metrics:
WITH
last_failed_jobs AS
(
SELECT OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE
FROM DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE STATUS = 'FAILED'
GROUP BY OWNER, JOB_NAME
),
last_succeeded_jobs AS
(
SELECT OWNER,
JOB_NAME,
MAX(ACTUAL_START_DATE) AS START_DATE