DATE :-- 1st Sep 2014

Error Starting Listener

Error:-- 

[oracle@PR11G admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 01-SEP-2014 00:38:45

Copyright (c) 1991, 2009, 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.1.0 - Production

System parameter file is /u01/app/oracle/product/11.2.0/db_1/network/admin/liste

Log messages written to /u01/app/oracle/diag/tnslsnr/PR11G/listener/alert/log.xm

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.161)(PORT=152

TNS-01155: Incorrectly specified SID_LIST_LISTENER parameter in LISTENER.ORA

 NL-00303: syntax error in NV string

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

Listener.ora entry

# Generated by Oracle configuration tools.

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

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

    )

  )

SID_LIST_LISTENER =

  (SID_LIST =

   (SID_DESC =

        (GLOBAL_DBNAME = PR11G.localdomain)

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

        (SID_NAME = DBPR11G)

        (SERVICE_NAME = DBPR11G)

   )

  )

Resolution :-- 

 SID_LIST_LISTENER was not properly formatted 

Once i alligned the brackets as shown above it worked

DATE :-- 1st Sep 2014

Error Creating Listener using netca

Error :--

Use another port number

The information provided for this listener is currently in use by other software on this computer. You can proceed with the configuration as it is, but it will not be possible to start this listener until the conflict is resolved.

Issue :--

In localuser (oracle) .profile / .bash_profile has ORACLE_HOSTNAME value different than /etc/sysconfig/network

Resolution :--

After correcting the ORACLE_HOSTNAME value in .profile/.bash_profile as same as /etc/sysconfig/network issue resolved

                                                           

DATE :-- 1st Sep 2014

               Error at time of listener startup Linux Error: 111: Connection refused

Error :-- 

LSNRCTL>reload

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

TNS-12541: TNS:no listener

 TNS-12560: TNS:protocol adapter error

  TNS-00511: No listener

   Linux Error: 111: Connection refused

Issue :--

Incorrect Entry in /etc/hosts files

The Entry in the /etc/hosts was

[oracle@PR11G ~]$ cat /etc/hosts

127.0.0.1 localhost.localdomain

192.168.56.161 PR11G.localdomain PR11G

Resolution :-- 

I edited the /etc/hosts and put localhost at the last of 127.0.0.1

The new entry

[oracle@PR11G ~]$ cat /etc/hosts

127.0.0.1 localhost.localdomain localhost

192.168.56.161 PR11G.localdomain PR11G

LSNRCTL> reload

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

The command completed successfully

LSNRCTL> LSNRCTL> status

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

STATUS of the LISTENER

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

Alias                     LISTENER

Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production

Start Date                31-AUG-2014 22:49:24

Uptime                    0 days 0 hr. 1 min. 52 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/PR11G/listener/alert/log.xml

Listening Endpoints Summary...

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

Services Summary...

Service "DBPR11G" has 1 instance(s).

  Instance "DBPR11G", status READY, has 1 handler(s) for this service...

Service "DBPR11GXDB" has 1 instance(s).

  Instance "DBPR11G", status READY, has 1 handler(s) for this service...

The command completed successfully

LSNRCTL> [oracle@PR11G admin]$