My Oracle Support Banner

EM13c: Applying Release Update Patch on OMS Fails with Error While Executing SQL Statement FileName Runbook_tables.sql (Doc ID 2960218.1)

Last updated on JULY 11, 2023

Applies to:

Enterprise Manager Base Platform - Version 13.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Applying 13.5 RU12 patch 34795383 on OMS fails.

\em_patch_apply_original_patch_2023_05_8__20_52_20.log
======================================

Mon May 8 21:00:59.469 EDT 2023 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/admin/emdrep/sql/core/13.5.0.v/13.5.0.5/runbooks/runbook_tables.sql'Line Number: 316
Mon May 8 21:00:59.469 EDT 2023 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 904SQLState:42000 Message: ORA-00904: "CREATED_BY": invalid identifier

Error encountered executing SQL statement FileName: '/u01/app/oracle/middleware/sysman/admin/emdrep/sql/core/13.5.0.v/13.5.0.5/runbooks/runbook_tables.sql' LineNumber: '316'
SQL Statement: [COMMENT ON COLUMN em_runbook_session_comments_e.created_by IS
'The EM Username of the person that created the comment']
java.sql.SQLSyntaxErrorException: ORA-00904: "CREATED_BY": invalid identifier

Mon May 8 21:07:05.949 EDT 2023 rcu:Executing SQL statement: ALTER SESSION SET CURRENT_SCHEMA=SYSMAN
Mon May 8 21:07:06.022 EDT 2023 rcu:Extracted SQL Statement: []
Mon May 8 21:07:06.022 EDT 2023 rcu:Extracted SQL Statement: []
Mon May 8 21:07:06.023 EDT 2023 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/emdrep/config/patch/sql/patchPostAction.sql'Line Number: 21
Mon May 8 21:07:06.023 EDT 2023 rcu:Extracted SQL Statement: [DEFINE NZDT_MODE = &1;]
Mon May 8 21:07:06.025 EDT 2023 rcu:Extracted SQL Statement: [DEFINE NZDT_MODE = &1;]
Mon May 8 21:07:06.025 EDT 2023 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/emdrep/config/patch/sql/patchPostAction.sql'Line Number: 22
Mon May 8 21:07:06.026 EDT 2023 rcu:Statement Type: 'DEFINE Statement'
Mon May 8 21:07:06.026 EDT 2023 rcu:Extracted SQL Statement: [DECLARE

BEGIN

SYSMAN.MGMT_PATCH_UTIL.MGMT_PATCH_POST_ACTION(SYSMAN.MGMT_PATCH_UTIL.G_PATCH_MODE_APPLY,'&NZDT_MODE');

END;
]
Mon May 8 21:07:06.031 EDT 2023 rcu:Extracted Statement from File Name: '/u01/app/oracle/middleware/sysman/emdrep/config/patch/sql/patchPostAction.sql'Line Number: 31
Mon May 8 21:07:06.031 EDT 2023 rcu:Statement Type: 'BEGIN/END Anonymous Block'

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.