ORA-00119

11.2.0.3 DBCA Raises ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00130: Invalid listener address (Doc ID 1489763.1)

APPLIES TO:

Oracle Database Configuration Assistant - Version 11.2.0.3 and later
Information in this document applies to any platform.

SYMPTOMS

After a software install, the first run of DBCA raises

ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00130: Invalid listener address (ADDRESS = PROTOCOL=TCP)(HOST=<....host name.....>)(port =1521))

CAUSE

Check for a mismatch or other issue in nsswitch.conf


 

SOLUTION

Either workaround by :

Creating a manual tnsnames entry
i) create tnsnames.ora under $ORACLE_HOME/network/admin
ii) Add entry :

REGISTER_LOCAL =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =rmm01.rexam.com )(PORT = 1521))
)



Or user netmgr if you have a syntax problem.

iii) Use tnsping to confirm the value was parsing correctly.
tnsping register_local , if you hit TNS-12533 then use netmgr to add the entry instead of manually adding it in tnsnames.ora

iv) Then set local_listener in the dbca to this new tested tnsnames entry.

And try to create the database again.

 or Contact your system / network admin or your hardware vendor to verify if there is a mismatch in nsswitch.conf