ORA-04045 ORA-04042 ORA-00604 Error After Applying July 2019 RU Patches (Doc ID 2569427.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Symptom1

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 ERRORS
logfile: <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 object
Error at line 4185: ORA-00604: error occurred at recursive SQL level 2
Error 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.log
for 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 2
ORA-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.

Symptom 2

When rolling back patch 30088912, during the execution datapatch

Patch 30088912 rollback: WITH ERRORS
logfile: $ORACLE_HOME/cfgtoollogs/sqlpatch/30088912/23055600/30088912_rollback_PDSQ2_2020Mar30_07_42_39.log (errors)
    Error at line 43: ORA-04045: errors during recompilation/revalidation of
    Error at line 45: ORA-04052: error occurred when looking up remote object
    Error at line 47: ORA-00604: error occurred at recursive SQL level 2
    Error at line 48: ORA-02019: connection description for remote database not found