Wednesday, April 20, 2011

TNS-01150: The address of the specified listener name is incorrect


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
$



2 comments:

Anonymous said...

It worker for me

vi listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ip-10-10-161-70.ec2.internal)(PORT = 1521))
)
)


SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PROD)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_home1)
)
)


ADR_BASE_LISTENER = /u01/app/oracle




[oracle@ip-10-10-161-70 admin]$ lsnrctl status listener

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 19-SEP-2017 06:55:10

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

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias listener
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 19-SEP-2017 06:54:49
Uptime 0 days 0 hr. 0 min. 21 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0/db_home1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/ip-10-10-161-70/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ip-10-10-161-70.ec2.internal)(PORT=1521)))
Services Summary...
Service "PROD" has 2 instance(s).
Instance "PROD", status UNKNOWN, has 1 handler(s) for this service...
Instance "PROD", status READY, has 1 handler(s) for this service...
The command completed successfully

Jyoti HRM said...

really helpful description.