ORA-04052 , ORA-00604 , ORA-12514 DBLINK AND TNS:LISTENER

ORA-04052 , ORA-00604 , ORA-12514 


As per the below screenshot we can see that we face the below ora-errors during import.

The error shows that remote object could not be looked up and pointing to dblink DB_LIK_TO_OLAP


So we checked the DBLINKs

From the above screenshot we found out that a dbink with name DB_LINK_TO_OLAP is created in the database and is pointing to the host WIN-JVDUMNL3TDN


When we checked the tns entry we found out that the database is residing at different host i.e. winserver

So we dropped the dblink and recreated with the correct hostname.

And recompiled the invalid procedure.







I hope this will help you to diagnose and resolve if you face the same problem 😊