| TNS-12541: Tns no listener [message #648687] |
Tue, 01 March 2016 01:23  |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear All,
Here, listener is up for 2 min 30 sec and getting down after that. We are trying to find out the solution but unable to.
We have asked os team to clear-up os logs. Here, we observe one more issue. Login prompt through telnet is taking very much time.
Please assist me to make it available.
$ cat listener.ora
SID_LIST_LISTENER=
(SID_LIST =
(SID_DESC =
(SID_NAME = liveprod)
(ORACLE_HOME = /oracledb/app/oracle/OraHome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = liveprod)(PORT = 1521))
)
)
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=liveprod)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
Start Date 01-MAR-2016 18:37:26
Uptime 0 days 0 hr. 2 min. 29 sec
Trace Level off
Security ON: Local OS Authentication
SNMP ON
Listener Parameter File /oracledb/app/oracle/OraHome_1/network/admin/listener.ora
Listener Log File /oracledb/app/oracle/OraHome_1/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=liveprod)(PORT=1521)))
Services Summary...
Service "liveprod" has 2 instance(s).
Instance "liveprod", status UNKNOWN, has 1 handler(s) for this service...
Instance "liveprod", status READY, has 1 handler(s) for this service...
Service "liveprodXDB" has 1 instance(s).
Instance "liveprod", status READY, has 1 handler(s) for this service...
The command completed successfully
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=liveprod)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
IBM/AIX RISC System/6000 Error: 79: Connection refused
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROT
TNS-12541: Tns no listener
Regards,
Ashish Kumar Mahanta
[Updated on: Tue, 01 March 2016 01:30] Report message to a moderator |
|
|
|
|
|
|
|
| Re: TNS-12541: Tns no listener [message #648690 is a reply to message #648687] |
Tue, 01 March 2016 02:46  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You could do some simple investigation:
What is in /oracledb/app/oracle/OraHome_1/network/log/listener.log for the time of the failure?
Is this s a new installation that has never worked, or an old one that has stopped working?
What is your AIX release?
What is the reason for using the unpatched DB release 10.2.0.1, rather than a supported version?
|
|
|
|
| Re: TNS-12541: Tns no listener [message #648695 is a reply to message #648690] |
Tue, 01 March 2016 03:54 |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
During the time of failure -
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 01-MAR-2016 21:06:41
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /oracledb/app/oracle/OraHome_1/network/admin/listener.ora
Log messages written to /oracledb/app/oracle/OraHome_1/network/log/listener.log
Trace information written to /oracledb/app/oracle/OraHome_1/network/trace/listener.trc
Trace level is currently 0
Started with pid=323776
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=liveprod)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
01-MAR-2016 21:06:41 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=liveprod)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
01-MAR-2016 21:06:58 * service_register * liveprod * 0
01-MAR-2016 21:07:07 * service_update * liveprod * 0
01-MAR-2016 21:07:10 * service_update * liveprod * 0
01-MAR-2016 21:07:13 * service_update * liveprod * 0
WARNING: Subscription for node down event still pending
01-MAR-2016 21:08:36 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=liveprod)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production on 01-MAR-2016 21:27:34
Copyright (c) 1991, 2005, Oracle. All rights reserved.
System parameter file is /oracledb/app/oracle/OraHome_1/network/admin/listener.ora
Log messages written to /oracledb/app/oracle/OraHome_1/network/log/listener.log
Trace information written to /oracledb/app/oracle/OraHome_1/network/trace/listener.trc
Trace level is currently 0
Started with pid=503914
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=liveprod)(PORT=1521)))
Listener completed notification to CRS on start
TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
WARNING: Subscription for node down event still pending
01-MAR-2016 21:27:34 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=liveprod)(USER=oracle))(COMMAND=status)(ARGUMENTS=64)(SERVICE=LISTENER)(VERSION=169869568)) * status * 0
01-MAR-2016 21:27:41 * service_register * liveprod * 0
This is old one and stopped working.
AIX release is 6
client has not upgraded.
Please assist me to make listener up and running.
Regards,
Ashish Kumar Mahanta
|
|
|
|
| Re: TNS-12541: Tns no listener [message #648697 is a reply to message #648695] |
Tue, 01 March 2016 04:13 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You should enable trace for the listener, that may give you more information.
Note that 10.2.0.1 was never certified for AIX6, only AIX5. Is this installation actually legal? It certainly won't be supported.
|
|
|
|
| Re: TNS-12541: Tns no listener [message #648698 is a reply to message #648697] |
Tue, 01 March 2016 04:25 |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear John,
This was done long back. We are not aware of supportive part. Last time we has asked os team to cleanup oslogs and after that listener started up. Now, again same issue occured after 2 years. Now os team has done their job. Even after that, listener is getting down after certain time.
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
|
|
|
|
| Re: TNS-12541: Tns no listener [message #648706 is a reply to message #648705] |
Tue, 01 March 2016 06:36 |
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
|
Senior Member |
|
|
Dear John,
I know, there is nothing wrong at listener side. Something problem from os level. But we don't know what is the issues?
If you know about it, then please let me know.
Regards,
Ashish Kumar Mahanta
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
