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

Below error occur while checking the status of listener or starting the listener services.
TNS-01150: The address of the specified listener name is incorrect
NL-00303: syntax error in NV string

Above error can get due to syntax error in listner.ora file. listener.ora file is case sensitive. small changes to files lead to an big problem.

We got TNS-01150 and NL-00303 error code due to wrong formatting of listener.ora file. This type of issue happen when we create the listener.ora file directly with copy and paste option. recommended way to create listener.ora and tnsnames.ora is with netca utility. netca is the gui utility.

Following description shows the changes in listener.ora file.

Before listener.ora file

listener.ora Network Configuration File: /data/oracle/app/oracle/product/12.1.0.2/db_1/network/admin/listener.ora

Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cdb1)
(ORACLE_HOME = /data/oracle/app/oracle/product/12.1.0.2/db_1)
(SID_NAME = cdb1)
)
(SID_DESC =
(GLOBAL_DBNAME = standdb)
(ORACLE_HOME = /data/oracle/app/oracle/product/12.1.0.2/db_1)
(SID_NAME = standdb)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.oracle.com)(PORT = 1521))
)
ADR_BASE_LISTENER = /data/oracle/app/oracle

After making the changes to listener.ora file. Correct listerner.ora file

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle.oracle.com)(PORT = 1521))
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = cdb1)
(ORACLE_HOME = /data/oracle/app/oracle/product/12.1.0.2/db_1)
(SID_NAME = cdb1)
)
(SID_DESC =
(GLOBAL_DBNAME = standdb)
(ORACLE_HOME = /data/oracle/app/oracle/product/12.1.0.2/db_1)
(SID_NAME = standdb)
)
)
ADR_BASE_LISTENER = /data/oracle/app/oracle

After correcting listener.ora file, We were able to start the listener.

if you want to know about the listener.ora and tnsnames.ora file then you can read from oracle official site.

In above example we have seen how to resolve the error of TNS-01150: The address of the specified listener name is incorrect

Thanks for visiting this post. Please contact us if you are looking for training.
Subscribe to our channel for unlimited learning. Thank you!!!

Leave a Reply

Your email address will not be published. Required fields are marked *