TNS-12541, TNS-12560, TNS-00511

In my test machine after finished with the database installation, when I was trying to start the listener, it failed with below error.

-bash-3.2$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0/db_1

-bash-3.2$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-AUG-2014 07:57:37

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNS-12537: TNS:connection closed
 TNS-12560: TNS:protocol adapter error
  TNS-00507: Connection closed
   Linux Error: 29: Illegal seek

Excerpts from  the listener.log file.

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

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

Trace information written to /u01/app/oracle/diag/tnslsnr/test/listener/trace/ora_2910_3086120640.trc

Trace level is currently 0

Started with pid=2910

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.0)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Listener completed notification to CRS on start

Fri Aug 01 07:59:32 2014

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

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

Trace information written to /u01/app/oracle/diag/tnslsnr/test/listener/trace/ora_2978_3086464704.trc

Trace level is currently 0

Started with pid=2978

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.0)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Listener completed notification to CRS on start

Fri Aug 01 08:08:55 2014

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

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

Trace information written to /u01/app/oracle/diag/tnslsnr/test/listener/trace/ora_3001_3085989568.trc

Trace level is currently 0

Started with pid=3001

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.0)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Listener completed notification to CRS on start

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE

Fri Aug 01 08:13:27 2014

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

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

Trace information written to /u01/app/oracle/diag/tnslsnr/test/listener/trace/ora_3319_3086780096.trc

Trace level is currently 0

Started with pid=3319

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.0)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Listener completed notification to CRS on start

Debugging.

I checked the listener file and tnsnames file and they are having with proper setting.

In Listener.ora 

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.0)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = db1)

      (SID_NAME = catalog)

      (SID_NAME = db2)

      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

    )

  )

ADR_BASE_LISTENER = /u01/app/oracle

In Tnsnames.ora

DB1 =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.0)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = db1)

    )

  )

CATALOG =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.0)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID = catalog)

    )

  )

DB2 =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.0)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID = db2)

    )

  )

Solution.

When I checked into the /etc/hosts file at the OS level, I found that an entry was somehow missing.

127.0.0.1       localhost.localdomain   localhost

After adding the above, I restarted the network services as root and then start the listener which get successful.

-bash-3.2$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 01-AUG-2014 08:13:26

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/11.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.3.0 - Production

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

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

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.0)(PORT=1521)))

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.0)(PORT=1521)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.3.0 - Production

Start Date                01-AUG-2014 08:13:27

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.2.0/db_1/network/admin/listener.ora

Listener Log File         /u01/app/oracle/diag/tnslsnr/test/listener/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.0)(PORT=1521)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))

Services Summary...

Service "db1" has 1 instance(s).

  Instance "db1", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

-bash-3.2$