Home » RDBMS Server » Networking and Gateways » Listener intermittently drops (Oracle 10g, 10.2.0.1, Windows XP)
Listener intermittently drops [message #394756] Mon, 30 March 2009 03:36 Go to next message
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 #394764 is a reply to message #394756] Mon, 30 March 2009 04:10 Go to previous messageGo to next message
babuknb
Messages: 1717
Registered: December 2005
Location: NJ
Senior Member


Post TNSPING output from your session.

Babu
Re: Listener intermittently drops [message #394771 is a reply to message #394756] Mon, 30 March 2009 04:49 Go to previous messageGo to next message
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 #394901 is a reply to message #394771] Mon, 30 March 2009 14:30 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10615
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Comment all entries in sqlnet.ora and try again(server and client).
Is there a firewall involved?
If this is home based PC, it worthwhile to have a look into loopback adapater
http://youngcow.net/doc/oracle10g/install.102/b14316/reqs.htm#BABGCEAI

If this is just for learning and you are directly working in hostmachine where oracle is installed, you do not need
a listener at all.
One can just connect as
sqlplus scott/tiger
Re: Listener intermittently drops [message #394904 is a reply to message #394756] Mon, 30 March 2009 14:44 Go to previous messageGo to next message
BlackSwan
Messages: 22535
Registered: January 2009
Senior Member
>OK (18940 msec)
18+ SECONDS!?

What is the distance (network?) between client & server?
Re: Listener intermittently drops [message #395019 is a reply to message #394904] Tue, 31 March 2009 01:48 Go to previous messageGo to next message
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.
Re: Listener intermittently drops [message #395287 is a reply to message #395019] Wed, 01 April 2009 01:20 Go to previous message
brent33
Messages: 4
Registered: March 2009
Junior Member
Hi.

I installed the loopback adapter, but still getting the same problem.
Previous Topic: oracle listener problem TNS12518
Next Topic: listener stopped suddenly
Goto Forum:
  


Current Time: Wed Jul 30 14:51:14 CDT 2014

Total time taken to generate the page: 0.12829 seconds