My Oracle Support Banner

datapatch fails with Error :ORA-00904: "PATCH_DIRECTORY"' & 'ORA-00904: "INSTALL_ID" and DBMS_SQLPATCH INVALID (Doc ID 2287561.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 12.1]
Information in this document applies to any platform.


datapatch fails with following errors:

Bootstrapping registry and package to current versions...done
Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_38207578_2017_06_29_03_33_47/bootstrap1_WMORSTG.log:
Error at line 94: Warning: Package Body created with compilation errors.
Error at line 100: 311/9 PL/SQL: SQL Statement ignored
Error at line 101: 313/24 PL/SQL: ORA-00904: "PATCH_DIRECTORY": invalid identifier
Error at line 102: 951/5 PL/SQL: SQL Statement ignored
Error at line 103: 951/20 PL/SQL: ORA-00904: "INSTALL_ID": invalid identifier
Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log
for information on how to resolve the above errors.

SQL Patching tool complete on Thu Jun 29 03:33:52 2017



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

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

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