My Oracle Support Banner

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

Last updated on AUGUST 16, 2019

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 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.



Changes

 

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
Changes
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.