TNS-12541 TNS-12560 TNS-00511 TNS:protocol adapter error No listener

Oracle Listener does not start with errors: 
TNS-12541: TNS:no listener TNS-12560, TNS-00511, Linux Error: 2: No such file or directory, The listener supports no services

euls25002.sgp.st.com:oraSID 51> ps -ef | grep -i tns
root       330     2  0 Jul19 ?        00:00:00 [netns]
oraSID   17512     1  0 Jul20 ?        00:01:25 /oracleSID/SID/121/bin/tnslsnr LISTENER_SID -inherit
oraSID   56223 56131  0 08:02 pts/1    00:00:00 grep --color=auto -i tns
euls25002.sgp.st.com:oraSID 52> lsnrctl status LISTENER_SID

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:02:19

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=eup25002)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
 
euls25002.sgp.st.com:oraSID 53> lsnrctl stop LISTENER_SID

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:02:50

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=eup25002)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
euls25002.sgp.st.com:oraSID 54>
euls25002.sgp.st.com:oraSID 54> lsnrctl start LISTENER_SID

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:02:56

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

TNS-01106: Listener using listener name LISTENER_SID has already been starte



   euls25002.sgp.st.com:oraSID 61> lsnrctl service LISTENER_SID

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:05:30

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory
Connecting to (ADDRESS=(COMMUNITY=SAP.WORLD)(PROTOCOL=TCP)(HOST=eup25002)(PORT=1521))
TNS-12541: TNS:no listener
 TNS-12560: TNS:protocol adapter error
  TNS-00511: No listener
   Linux Error: 2: No such file or directory

 
But tnsping is working:

euls25002.sgp.st.com:oraSID 86> tnsping SID

TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:11:27

Copyright (c) 1997, 2014, Oracle.  All rights reserved.

Used parameter files:
/oracleSID/SID/121/network/admin/sqlnet.ora


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = eup25002) (PORT = 1521))) (CONNECT_DATA = (SID = SID) (GLOBAL_NAME = SID.WORLD)))
OK (0 msec)


Than checked the file where listener makes it socket files:

euls25002.sgp.st.com:oraSID 103> ls -ld /var/tmp/.oracle
drwxrwxrwt 2 root root 4096 Jul 20 20:28 /var/tmp/.oracle

Changed the ownership from root : root to oraSID : dba as its belong to ora user also , listener should be start from ora user not from root.

euls25002.sgp.st.com:oraSID 170> ls -ld /var/tmp/.oracle
drwxr-xr-x 2 oraSID dba 4096 Jul 20 20:28 /var/tmp/.oracle

Now as we were unable to stop the listener so killed the listener process.

euls25002.sgp.st.com:oraSID 172> ps -ef |grep -i tns
root       330     2  0 Jul19 ?        00:00:00 [netns]
oraSID   17512     1  0 Jul20 ?        00:01:25 /oracleSID/SID/121/bin/tnslsnr LISTENER_SID -inherit
oraSID   59795 56131  0 08:35 pts/1    00:00:00 grep --color=auto -i tns

euls25002.sgp.st.com:oraSID 174> kill -9 17512
euls25002.sgp.st.com:oraSID 175>
euls25002.sgp.st.com:oraSID 175> ps -ef | grep -i tns
root       330     2  0 Jul19 ?        00:00:00 [netns]
oraSID   59804 56131  0 08:36 pts/1    00:00:00 grep --color=auto -i tns


Now start the Listener

euls25002.sgp.st.com:oraSID 176> lsnrctl start LISTENER_SID

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 25-SEP-2017 08:36:25

Copyright (c) 1991, 2014, Oracle.  All rights reserved.

Starting /oracleSID/SID/121/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 12.1.0.2.0 - Production
System parameter file is /oracleSID/SID/121/network/admin/listener.ora
Log messages written to /oracleSID/SID/saptrace/diag/tnslsnr/euls25002/listener_SID/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID.WORLD)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.75.134.151)(PORT=1521)))

Connecting to (ADDRESS=(PROTOCOL=IPC)(KEY=SID.WORLD))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_SID
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                25-SEP-2017 08:36:25
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /oracleSID/SID/121/network/admin/listener.ora
Listener Log File         /oracleSID/SID/saptrace/diag/tnslsnr/euls25002/listener_SID/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID.WORLD)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=SID)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.75.134.151)(PORT=1521)))
Services Summary...
Service "SID" has 1 instance(s).
  Instance "SID", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully

All Done.

Comments

Popular posts from this blog

How to set the root password after creating instance on oracle cloud

Queryable inventory could not determine the current opatch status.