Error is occurring while starting the listener.
Below is the error that I am getting while starting the listener:
$ lsnrctl start listener
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:06:46
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jeetdev/listener/alert/log.xml
TNS-01150: The address of the specified listener name is incorrect
Listener failed to start. See the error message(s) above...
$
$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:16:46
Copyright (c) 1991, 2010, Oracle. All rights reserved.
TNS-01150: The address of the specified listener name is incorrect
NL-00303: syntax error in NV string
$
In order to check on what is happening my first check would be to see if the listener.ora file have got the correct information and check if the opening and closing brackets are present. My current listener file is:
LISTENER=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(ORACLE_HOME=/u01/app/oracle/product/11.2.0.2)
(SID_NAME=orcl))
)
ADR_BASE_LISTENER = /u01/app/oracle
I have observed that there is a missing closing bracket in LISTENER for DESCRIPTION. What I have done is added that closing bracket and saved the listener file and then tried starting the listener again.
$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:17:20
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
$
$ lsnrctl start listener
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 20-APR-2011 06:17:26
Copyright (c) 1991, 2010, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.2/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.2.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.2/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/jeetdev/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 20-APR-2011 06:17:26
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.2/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/jeetdev/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=jeetdev)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
$
