listener getting hanged [message #342991] |
Mon, 25 August 2008 15:16  |
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 #343005 is a reply to message #343000] |
Mon, 25 August 2008 18:27   |
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 #343007 is a reply to message #343005] |
Mon, 25 August 2008 18:34   |
 |
Mahesh Rajendran
Messages: 10708 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 #343011 is a reply to message #343007] |
Mon, 25 August 2008 19:33   |
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 #343041 is a reply to message #343011] |
Tue, 26 August 2008 00:54  |
 |
Michel Cadot
Messages: 68745 Registered: March 2007 Location: Saint-Maur, France, https...
|
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
|
|
|