Home » RDBMS Server » Networking and Gateways » listener getting hanged (10.2.0.1)
listener getting hanged [message #342991] Mon, 25 August 2008 15:16 Go to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
My Oracle listener got hanged last week and I did following steps to make it work again:-
1. Kill the hanging listener
2. rm -rf "/var/tmp/.oracle"
3. Restart the listener
Today samething happened and i repeated same steps to make it work it again.I am just curious to know the reason that why listener is getting hanged.

Regards,
Varun Punj,
Re: listener getting hanged [message #342993 is a reply to message #342991] Mon, 25 August 2008 15:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What does the listener log /sqlnet log say?
Re: listener getting hanged [message #342997 is a reply to message #342993] Mon, 25 August 2008 16:16 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
can you tell me the command to check listener log.

Regards,
Varun Punj,
Re: listener getting hanged [message #343000 is a reply to message #342997] Mon, 25 August 2008 16:40 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
varunvir wrote on Mon, 25 August 2008 14:16
can you tell me the command to check listener log.

Regards,
Varun Punj,


http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

Why do you expect us to tell you what command when you do not tell us the Operating System you are (ab)using?

Open the log file with the editor of your choosing.
Re: listener getting hanged [message #343005 is a reply to message #343000] Mon, 25 August 2008 18:27 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
I am working on solaris 9.Is log for listener is different.Information about listener is not present in alert log file.I am not able to understand why you want me to read the orafaq/forms everytime.Please let me know what mistake i am doing while posting forms.
Regards,
Varun Punj,
Re: listener getting hanged [message #343006 is a reply to message #342997] Mon, 25 August 2008 18:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just do a cat on the listener.log file.
And yes, Listener log is different from the alert_sid.log.
Re: listener getting hanged [message #343007 is a reply to message #343005] Mon, 25 August 2008 18:34 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>I am not able to understand why you want me to read the orafaq/forms everytime
Had you read the forum guide, you would have realized that
you need to provide atleast some basic information (oracle/OS versions), something
to start about (logfiles, actual errors etc) ,format the post & provide some test cases (if applicable) and first search before posting.

[Updated on: Mon, 25 August 2008 18:39]

Report message to a moderator

Re: listener getting hanged [message #343008 is a reply to message #342991] Mon, 25 August 2008 18:36 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
If you are unwilling or incapable to read & follow the posting guidelines, then you do not deserve any further response(s).

You're On Your Own (YOYO)!
Re: listener getting hanged [message #343009 is a reply to message #343008] Mon, 25 August 2008 18:47 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Thanks for the responses.
Regards,
Varun Punj,
Re: listener getting hanged [message #343011 is a reply to message #343007] Mon, 25 August 2008 19:33 Go to previous messageGo to next message
varunvir
Messages: 389
Registered: November 2007
Senior Member
Fatal NI connect error 12514, connecting to:


VERSION INFORMATION:
TNS for Solaris: Version 10.2.0.2.0 - Production
TCP/IP NT Protocol Adapter for Solaris: Version 10.2.0.2.0 - Production
Time: 26-JUL-2007 04:06:06
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
This is the output of sqlnet.log.
Re: listener getting hanged [message #343026 is a reply to message #343011] Mon, 25 August 2008 23:31 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Quote:
Time: 26-JUL-2007 04:06:06

Not very useful.
Re: listener getting hanged [message #343041 is a reply to message #343011] Tue, 26 August 2008 00:54 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
 *Cause:  The listener received a request to establish a connection to a
 database or other service. The connect descriptor received by the listener
 specified a service name for a service (usually a database service)
 that either has not yet dynamically registered with the listener or has
 not been statically configured for the listener.  This may be a temporary
 condition such as after the listener has started, but before the database
 instance has registered with the listener.
 *Action:
  - Wait a moment and try to connect a second time.
  - Check which services are currently known by the listener by executing:
    lsnrctl services <listener name>
  - Check that the SERVICE_NAME parameter in the connect descriptor of the
    net service name used specifies a service known by the listener.
  - If an easy connect naming connect identifier was used, check that
    the service name specified is a service known by the listener.
  - Check for an event in the listener.log file.

ORA-12564: TNS:connection refused
 *Cause: The connect request was denied by the remote user (or TNS software).
 *Action: Not normally visible to the user.  For further details, turn on
 tracing and reexecute the operation.

Regards
Michel
Previous Topic: WARNING: Subscription for node down event still pending
Next Topic: SRVCTL STATUS: Listener is not running [Merged]
Goto Forum:
  


Current Time: Thu Mar 28 09:01:24 CDT 2024