Oracle Database Discussions

Hi, I don't know why the listener is no more working. I tried to start it but that doesn't work. There no linux processus 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 him via netca, and remake an other one but the problem still here...
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 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>

Rly thx for the help I'm dsapointed :/

I tried using a sample listener.ora, but got the same error, the file is not ignored but that doesn't work.

There's no listener proc, I need to have a proc 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

I didn't upgrade from 10g to 11g

Edited by: user8833504 on 16 nov. 2011 04:24