TNS-12541 after listener goes idle...!

From: Guy Boulais <ve2gyb_at_my-deja.com>
Date: Fri, 19 Nov 1999 13:36:58 GMT
Message-ID: <813jpq$ka8$1@nnrp1.deja.com>

I've got a really strange problem:

I've setup Oracle 8.0.5 on a Sun Enterprise 450 with 4 CPU and 1.5Gb of RAM, 2 databases are running and 1 listerner.

If I start the listener, workstations can access databases. BUT, If nothing is happening on the listener for a while and workstations try to access databases they receive: TNS-12541: TNS:no listener

If I tnsping from the server it's OK!

I found that 2 ways can re-activate the listener:
-stop and restart the listener via lsnrctl
-starting SQL*Plus locally on the server by forcing use of listener
(sqlplus system_at_cltup201.world)

What could cause the listener to idle-out and not respond remote client?

Any clue?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Nov 19 1999 - 07:36:58 CST