Database link throws ORA-04052 ORA-00604 ORA-12170 [message #478240] |
Thu, 07 October 2010 07:15 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|