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

By -
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.
Location: Plot No 1, Knowledge Park III, Greater Noida, Uttar Pradesh 201308, India

Comments

Post a Comment

Popular posts from this blog

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

By -
How to set the root password after creating instance on oracle cloud? since you have created instance on oracle cloud, it requires you private .ppk key file to login from putty you can login on your instance by directly providing that private key. and on Linux/Unix defult user is "opc". since during creation of instance it  will not ask you for  root password. You dont need any password to connect to root. to connect to root type below command as opc user. [opc@sts ~]$ sudo su [root@sts opc]# by this you will login as root. Now change your password [root@sts opc]# passwd Changing password for user root. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@sts opc]# All done. Thanks & Regards Nikhil Kumar.
Read more
By -
How to kill IMPDP/EXPDP job: nohup impdp \"/ as sysdba\" directory=PUMP dumpfile=FULL_EXPORT.dmp logfile=FULL_IMPORT.log & check import process from database: sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Thu Mar 21 10:01:05 2019 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select JOB_NAME,state from dba_datapump_jobs; JOB_NAME STATE ------------------------------ ------------------------------ SYS_IMPORT_FULL_02 EXECUTING SYS_IMPORT_SCHEMA_02 NOT RUNNING SYS_IMPORT_SCHEMA_01 NOT RUNNING SYS_IMPORT_FULL_01 NOT RUNNING SYS_IMPORT_SCHEMA_03 NOT RUNNING exit You can see that IMPORT process is run with SYS_IMPORT_FULL_02 EXECUTING name like above. We can attach or connect to this process like following: impdp \"/ as sysdba\" attach=SYS_IMPORT_FULL_02 check st...
Read more