Database Administration (MOSC)

MOSC Banner

Database link throws ORA-04052 ORA-00604 ORA-12170

edited Oct 7, 2010 9:13AM in Database Administration (MOSC) 3 commentsAnswered
 Hi!

When trying deploy an mapping, the database link get this error:

ORA-06550: PACKAGE BODY, line 0, column 0:
ORA-04052: error occurred when looking up remote object db1.someC@db1@LOC_db
ORA-00604: error occurred at recursive SQL level 1
ORA-12170: TNS:Connect timeout occurred

			


I can use tnsping towards the db. I can use

select * from v$instance@db1@loc_db

			


Any ideas?
Regards
H

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center