Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.3.0.0.0 [Release 12.2 to 18]Information in this document applies to any platform.

Symptoms

After installing July 2019 RU following errors are observed during the execution of datapatch. Datapatch is trying to compile NON-SYS objects and hence the error

Patch 29757449 apply (pdb PDB1): WITH ERRORSlogfile: <ORACLE_BASE>/cfgtoollogs/sqlpatch/29757449/23009673/29757449_apply_xxxx_yyyyy_2019Jul19_07_22_36.log (errors)Error at line 4182: ORA-04045: errors during recompilation/revalidation of <APPS.OBJECTNAME>Error at line 4183: ORA-04052: error occurred when looking up remote objectError at line 4185: ORA-00604: error occurred at recursive SQL level 2Error at line 4186: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:Error at line 4191: ORA-02063: preceding 2 lines from FILEHANDLER

Please refer to MOS Note 1609718.1 and/or the invocation log<ORACLE_BASE>/cfgtoollogs/sqlpatch/sqlpatch_124214_2019_07_19_07_22_09/sqlpatch_invocation.logfor information on how to resolve the above errors.

begin*ERROR at line 1:ORA-04045: errors during recompilation/revalidation of <APPS.OBJECTNAME>ORA-04052: error occurred when looking up remote object <DB LINK>ORA-00604: error occurred at recursive SQL level 2ORA-28500: connection from ORACLE to a non-Oracle system returned this message:[unixODBC][Easysoft][SQL Server Driver][SQL Server] Cannot open database "<DBNAME>" requested by the login. The login failed.