My Oracle Support Banner

Oracle Text and CTXSYS.DRVDML are INVALID After Applying Fix For 32454339 (Doc ID 2797503.1)

Last updated on NOVEMBER 03, 2021

Applies to:

Oracle Text - Version 19.11.0.0.0 to 19.11.0.0.0 [Release 12.2]
Information in this document applies to any platform.

Symptoms

After applying patch.32454339 for 19.11, CTXYS.DRVDML is INVALID and fails to recompile successfully.

32454339     : applied on Thu Jul 29 12:02:11 GMT 2021
Unique Patch ID:  24148180
Patch description:  "CTXCAT TRIGGER FAILS WITH THE INVALID OBJECT NAME ERROR"
   Created on 28 Mar 2021, 17:38:11 hrs PST8PDT


Post patch apply log shows:

Validating logfiles...done
Patch 32454339 apply: WITH ERRORS
  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/32454339/24148180/32454339_apply_ORCL_2021Jul29_12_05_43.log (errors)
   Error at line 25: script ctx/admin/drvdml.plb
      - Warning: Package Body created with compilation errors.



Queries from dba_objects and dba_errors show:

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.