Oracle 11g Listener not working

The listener on my Oracle 11g instance is no longer working.

I tried to start it but that doesn't work.

There are no Linux processes for the listener:

> lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 16-NOV-2011 10:55:08

Copyright (c) 1991, 2007, 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.6.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/diag/tnslsnr/oracle/listener/alert/log.xml
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)
(HOST=oracle.Domain.com)(PORT=1521)))
TNS-12557: TNS:protocol adapter not loadable
TNS-12560: TNS:protocol adapter error
TNS-00527: Protocol Adapter not loadable

Listener failed to start. See the error message(s) above...

I tried to delete it via netca, and make another one but the problem remains...

My Environment variables are properly set.

> tnsping oracle.Domain.com 1521

TNS Ping Utility for Linux: Version 11.1.0.6.0 -
Production on 16-NOV-2011 10:56:47

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

Used parameter files:
/u01/app/oracle/product/11.1.0/db_1/network/admin/sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))
(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=
(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)
(HOST=127.0.0.1)(PORT=1521)))
TNS-12541: TNS:no listener"

the alert log in XML:


System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora



Log messages written to /u01/app/oracle/diag/tnslsnr/oracle1/listener/alert/log.xml



Trace information written to /u01/app/oracle/diag/tnslsnr/oracle1/listener/trace/ora_11850_478024493

The error message means that one (or more) of the shared libraries required for TCP communications to work could not be loaded, perhaps due to o/s package updates? or it can mean that the /tmp/.oracle directory is not writeable by the oracle user (or doesn't exist perhaps because someone did some 'housekeeping' on /tmp . In either case tracing the listener at level 16 as Gaius suggested should reveal the issue.

StackExchange Database Administrators Q#7963, answer score: 6