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