My Oracle Support Banner

EM 13.5 : OMS Patching Fails with PLS-00904: insufficient privilege to access object CTXSYS.DRVDML (Doc ID 3052402.1)

Last updated on OCTOBER 21, 2024

Applies to:

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

Symptoms

In Enterprise Manager (EM) Cloud Control 13.5 while patching the OMS with the latest Release Update (RU) with OMSPatcher failed with error code 245.

From /<OMS_HOME>/cfgtoollogs/omspatcher/<PATCH_NUM>/omspatcher_<time_stamp>_apply.log

Some error occurred during RCU update. Please refer individual log file(s) for details.
Log file location: <OMS_HOME>/cfgtoollogs/omspatcher/2024-10-08_10-44-54AM_SystemPatch_36494040_12/rcu_applypatch_original_patch_2024-10-08_10-55-44AM.log
[Oct 8, 2024 10:56:13 AM] Stack Description: java.lang.RuntimeException: OMSPatcher failed to execute some of the OMS operations. Please refer log file(s) for details.
[Oct 8, 2024 10:56:13 AM] StackTrace: oracle.opatchauto.oms.OMSApplySession.process(OMSApplySession.java:1789)
[Oct 8, 2024 10:56:13 AM] StackTrace: oracle.opatchauto.oms.OMSPatchingSession.applySession(OMSPatchingSession.java:1528)
[Oct 8, 2024 10:56:13 AM] StackTrace: oracle.opatchauto.oms.OMSPatchingSession.main(OMSPatchingSession.java:1009)
[Oct 8, 2024 10:56:13 AM] StackTrace: oracle.opatchauto.oms.OPatchAuto.main(OPatchAuto.java:832)
[Oct 8, 2024 10:56:13 AM] Sucessfully created the add oms script
[Oct 8, 2024 10:56:13 AM] OMSPatcher failed to execute some of the patching steps. Please check the Patching summary,individual logs and try to resolve the issue. Once the issue is resolved,Please execute below command to complete patching session:
omspatcher resume

From /<OMS_HOME>/oracle_common/rcu/log/empatch/logs/em_patch_apply_original_patch_<time_stamp>.log

JDBC SQLException - ErrorCode: 29855SQLState:99999 Message: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-06512: at line 21
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drepopen
ORA-06550: line 1, column 21:
PLS-00904: insufficient privilege to access object CTXSYS.DRVDML
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored

ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 320
ORA-06512: at line 4

 

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.