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:
<msg time='2011-11-16T10:55:08.236+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> System parameter file is /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora </txt> </msg> <msg time='2011-11-16T10:55:08.237+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> Log messages written to /u01/app/oracle/diag/tnslsnr/oracle1/listener/alert/log.xml </txt> </msg> <msg time='2011-11-16T10:55:08.237+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> Trace information written to /u01/app/oracle/diag/tnslsnr/oracle1/listener/trace/ora_11850_47802449326800.trc </txt> </msg> <msg time='2011-11-16T10:55:08.237+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> Trace level is currently 0 </txt> </msg> <msg time='2011-11-16T10:55:08.237+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> </txt> </msg> <msg time='2011-11-16T10:55:08.238+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> Started with pid=11850 </txt> </msg> <msg time='2011-11-16T10:55:08.239+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.Domain.com)(PORT=1521))) </txt> </msg> <msg time='2011-11-16T10:55:08.239+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1)) </txt> </msg> <msg time='2011-11-16T10:55:08.239+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oracle.Domain.com)(PORT=1521))) </txt> </msg> <msg time='2011-11-16T10:55:08.239+01:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='oracle.Domain.com' host_addr='127.0.0.1'> <txt> TNS-12557: TNS:protocol adapter not loadable TNS-12560: TNS:protocol adapter error TNS-00527: Protocol Adapter not loadable </txt> </msg>
Hi, I tried using a sample listener.ora
, but got the same error, the file is not ignored it just doesn't work.
There's no listener process, I need to have a process like that, I suppose :
/u01/app/oracle/product/11.1.0/db_1/bin/tnslsnr LISTENER -inherit
I see nothing on the 1521 port :
netstat |grep 1521
By the way, I have not upgraded from Oracle 10g to Oracle 11g.
oracle.domain.com
?listener.ora
pleasePROTOCOL=ipc
there?