Listener intermittently drops [message #394756] |
Mon, 30 March 2009 03:36  |
brent33
Messages: 4 Registered: March 2009
|
Junior Member |
|
|
Hi all.
I have a problem with my listener that I cant figure out.
When I start my PC up, the listener is running and I can tnsping the machines IP. The response time is 10msec. But as I repeat the tnsping the response time then keeps increasing until its past 20sec and then the tnsping times out and I get a TNS-12560 error. When I look at the log file, after the last successful tns ping I get:
27-MAR-2009 07:43:48 * service_died * ticpc * 12547
TNS-12547: TNS:lost contact
Initially I thought it was caused by the dynamic IP I had, so I got a static IP, but it did not help.
I dont think its a problem with my ora files because the listener does connect initially.
The other strange thing is that if after the listener drops and I disconnect the lan cable and then reconnect the cable, the tnsping works again. But thereafter again the repsonse times keep increasing like before until the listener times out...
Any advise would be most helpful.
Thanks.
|
|
|
|
Re: Listener intermittently drops [message #394771 is a reply to message #394756] |
Mon, 30 March 2009 04:49   |
brent33
Messages: 4 Registered: March 2009
|
Junior Member |
|
|
Hi Babu,
I have posted the last successful tnsping before the fail occurs
as well:
C:\Documents and Settings\ABC>tnsping ticpc
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-MAR-2
009 14:13:59
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 147.110.224.22)(PORT = 1521)(IP = FIRST))) (CONNECT_DATA = (SID = ticpc)
(SERVER = DEDICATED)))
OK (18940 msec)
C:\Documents and Settings\ABC>tnsping ticpc
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 27-MAR-2
009 14:15:14
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 147.110.224.22)(PORT = 1521)(IP = FIRST))) (CONNECT_DATA = (SID = ticpc)
(SERVER = DEDICATED)))
TNS-12560: TNS:protocol adapter error
|
|
|
|
|
Re: Listener intermittently drops [message #395019 is a reply to message #394904] |
Tue, 31 March 2009 01:48   |
brent33
Messages: 4 Registered: March 2009
|
Junior Member |
|
|
Thanks for the replies.
-->Mahesh Rajendran
I tried commenting the sqlnet.ora file, but this did not sort out the problem.
The machine is on the network, but I am working directly on the host machine at the moment.
I am trying to set the machine up as a disaster recovery PC for another application we have running, so I need to get the listener working....
Can you maybe elaborate on the loopback adapter. From my understanding, a loopback is used to simulate a network on a stand alone PC. If my PC is connected to a network, is the loopback still required.
-->BlackSwan
There is no distance(well almost if you exclude 10meters to the switch). I am quering from the host PC. As I mentioned, the initial response time is 10 msec, which I think is fine. The 18sec I posted from the tnsping is how slow the response time eventually gets before the TNS error occurs.
|
|
|
|