ORA-04052: error occurred when looking up remote object

I got ” ORA-04052: error occurred when looking up remote object” error in Oracle database.

 

ORA-04052: error occurred when looking up remote object

 

Details of error are as follows.

ORA-04052 error occurred when looking up remote object

Cause: An error has occurred when trying to look up a remote object.

Action: Fix the error. Make sure the remote database system has run KGLR.SQL to
 create necessary views used for querying/looking up objects stored in the database.
                                          
ERROR at line 1:
ORA-04052: error occurred when looking up remote object
[email protected]_TO_APPS.AAAA.COM
ORA-00604: error occurred at recursive SQL level 1
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
    

 

 

error occurred when looking up remote object

This ORA-04052 errors are related with the error has occurred when trying to look up a remote object.

This is due to invalid database link APPS_TO_APPS.AAAA.COM.

 

To solve this error, Recreate the database link using the following:

1. Drop database link by issuing the following command:

drop database link <link_name>;

2. Recreate the database link by executing the following command:

create database link <link_name>
connect to <apps_schema normally apps>
identified by <apps_schema normally apps>
using '<db_name>';

3. Recompile EDW_HR_ASG_CHNG_M_C by issuing the following command:

alter package EDW_HR_ASG_CHNG_M_C compile body;

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 2 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply

IT Tutorial