Enterprise Manager Generic (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center