Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
Are you really oracle.domain.com? –  Gaius Nov 16 '11 at 12:01
    
no I can't put the real one. I can ping the real one and he is on /etc/hosts –  user1049372 Nov 16 '11 at 12:27
    
Post your listener.ora please –  Gaius Nov 16 '11 at 12:30
    
LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = oracle.domain.com)(PORT = 1521)) ) ) –  user1049372 Nov 16 '11 at 12:39
    
I don't see any reference to PROTOCOL=ipc there? –  Gaius Nov 16 '11 at 12:50

1 Answer 1

up vote 4 down vote accepted

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.

share|improve this answer
    
He is here : /var/yp/tmp/.oracle srwxrwxrwx 1 oracle oinstall 0 Mar 2 2011 s#16428.1 srwxrwxrwx 1 oracle oinstall 0 Mar 2 2011 s#16428.2 srwxrwxrwx 1 oracle oinstall 0 Mar 2 2011 sEXTPROC1521 I'm trying putting lvl16 tracing. Thx –  user1049372 Nov 17 '11 at 11:03
    
permissions problems on temporary directory thx. You're good. /var/tmp/.oracle –  user1049372 Nov 17 '11 at 13:40

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.