IQ: 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

Doc ID		SOLN242434
Version:		13.0
Status:		Published
Published date:		09 Nov 2017
Created Date:		27 Dec 2013

Author:

emilio

Details

IQ All IQ Versions, All Oracle Versions.

After the database is re-started via a restart (/etc/init.d/dbora stop | start), or reboot.

Confirm the Database is online (important), you can run the tests in SOLN244022 to confirm.

Then check status of the Oracle listener, it fails to start with these errors:

[oracle@SQ1PPLIQ001 ~]$ lsnrctl status

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 27-DEC-2013 13:14:57
Copyright 1991, 2008, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS rotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SQ1PPLIQ001.tor.quest.com)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

Problem Clarification

The following files must be owned by Oracle:

/var/tmp/.oracle

Cause

The likely cause was an administrator or user attempting to stop or start the listener by executing the command as a root or root-like user.

When this is done, the files and directories under /var/tmp/.oracle change ownership to root. Then when attempting to start the listener as oracle user, it cannot use these files because they are not owned by oracle.

[oracle@iqtkdbt4 ~]$ ls -ltd /var/tmp/.oracle

drwxrwxrwt 2 root oinstall 4096 Dec 27 10:51 /var/tmp/.oracle

[oracle@iqtkdbt4 ~]$ ls -ltd /var/tmp/.oracle/*

srwxrwxrwx 1 oracle oinstall 0 Dec 27 10:51 /var/tmp/.oracle/s#12987.1

. . .

Solution

Stop the listener (it may not stop cleanly)

su - oracle

lsnrctl stop

mv /var/tmp/.oracle /home/oracle (you may have to do this operation as root)

lsnrctl start

Example of the listener start:

$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.7.0 - Production on 27-DEC-2013 14:00:46
Copyright 1991, 2008, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.1.0.7.0 - Production
System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/11.1.0/db_1/log/diag/tnslsnr/SQ1PPLIQ001/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SQ1PPLIQ001.tor.quest.com)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.1.0.7.0 - Production
Start Date 27-DEC-2013 14:00:46
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.1.0/db_1/log/diag/tnslsnr/SQ1PPLIQ001/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SQ1PPLIQ001.tor.quest.com)(PORT=1521)))
The listener supports no services
The command completed successfully

If you get a message about "The listener supports no services", confirm the listener.ora file has this form (the IPC entry should not be commented out):

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = poppy.dr.avaya.com)(PORT = 1521))
    )
)

SECURE_REGISTER_LISTENER = (IPC)

then use /etc/init.d/dbora stop; /etc/init.d/dbora start, so that listener and instance synchronize properly.

Finally, after DB instance and listener start with no errors, restart IQ so that it also synchronizes properly.

Additional Relevant Phrases

ERROR: ORA-12541: TNS no listener Linux error: 111 connection refused DB server failing to start fully after maintenance reboot

Avaya -- Proprietary. Use pursuant to the terms of your signed agreement or Avaya policy