Home » RDBMS Server » Server Administration » Database link throws ORA-04052 ORA-00604 ORA-12170 (OWB 11.2.0.1, RDBMS 10.2.0.3, SLES11 x64)
Database link throws ORA-04052 ORA-00604 ORA-12170 [message #478240] Thu, 07 October 2010 07:15 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
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

[Updated on: Thu, 07 October 2010 07:21]

Report message to a moderator

Re: Database link throws ORA-04052 ORA-00604 ORA-12170 [message #478245 is a reply to message #478240] Thu, 07 October 2010 07:51 Go to previous message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12170: TNS:Connect timeout occurred
 *Cause:  The server shut down because connection establishment or
 communication with a client failed to complete within the allotted time
 interval. This may be a result of network or system delays; or this may
 indicate that a malicious client is trying to cause a Denial of Service
 attack on the server.
 *Action: If the error occurred because of a slow network or system,
 reconfigure one or all of the parameters SQLNET.INBOUND_CONNECT_TIMEOUT,
 SQLNET.SEND_TIMEOUT, SQLNET.RECV_TIMEOUT in sqlnet.ora to larger values.
 If a malicious client is suspected, use the address in sqlnet.log to
 identify the source and restrict access. Note that logged addresses may
 not be reliable as they can be forged (e.g. in TCP/IP).

Regards
Michel
Previous Topic: Describing all the tables in a database
Next Topic: connection error
Goto Forum:
  


Current Time: Sun May 19 17:35:03 CDT 2024