Oracle 11g Release 2: ORA-00119: invalid specification for system parameter LOCAL_LISTENER
I’ve recently installed an Oracle 11g Release 2 database (18.104.22.168) and when I bounce the database (using the shutdown and startup commands), the database is unable to start:
SQL> startup ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_LAB11'
This is due to the lack of a LOCAL_LISTENER, that must be defined in the TNSNAMES.ORA, according to the Oracle Database Reference 11gR2:
LOCAL_LISTENERspecifies a network name that resolves to an address or address list of Oracle Net local listeners (that is, listeners that are running on the same machine as this instance). The address or address list is specified in the
TNSNAMES.ORAfile or other address repository as configured for your system.
So, in your TNSNAMES.ORA (not in LISTENER.ORA) you must define this entry for the local listener:
LISTENER_LAB11.WORLD = (ADDRESS = (PROTOCOL = TCP)(HOST = toralin1)(PORT = 1523))
And now you can startup the database. Be sure to set the .WORLD if you have the parameter names.default_domain set at sqlnet.ora.
You can learn more about the LOCAL_LISTENER in this excellent post of Ed Stevens: Exploring the LOCAL_LISTENER parameter