datapatch fails with Error :ORA-00904: "PATCH_DIRECTORY"' & 'ORA-00904: "INSTALL_ID" and DBMS_SQLPATCH INVALID

(Doc ID 2287561.1)

Last updated on AUGUST 28, 2017

Applies to:

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

Symptoms

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
/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_38207578_2017_06_29_03_33_47/sqlpatch_invocation.log
for information on how to resolve the above errors.

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

 

Changes

 

Cause

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 hundreds of Community platforms