My Oracle Support Banner

Object Recompilation fails with ORA-4045 ORA-4052 ORA-1045 ORA-6508 (Doc ID 1293027.1)

Last updated on FEBRUARY 24, 2020

Applies to:

Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Any objects that deals with Database Links


Symptoms

OracleUser has been granted CREATE and EXECUTE on object. And that object includes a reference to a remote DB.

Error Message example;

ERROR at line 1:
ORA-04045: errors during recompilation/revalidation of
<owner>.<procedure>
ORA-04052: error occurred when looking up remote object
<owner>.<procedure>@<dblink>
ORA-00604: error occurred at recursive SQL level 2
ORA-01045: user <owner> lacks CREATE SESSION privilege; logon denied
ORA-02063: preceding line from <dblink>
ORA-06508: PL/SQL: could not find program unit being called:
"<owner>.<procedure>"
ORA-06512: at line 2

 

Changes

Upgraded to Oracle 11g 11.2.0.2.

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.