- 30 Jun, 2019
- 0 Comments
- 1 Min Read
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