I’ve recently installed an Oracle 12c Release 2 database on Linux 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 12cR2:
LOCAL_LISTENER specifies 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.ORA file 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 = 1521))
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
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 12cR2:
LOCAL_LISTENER specifies 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.ORA file 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 = 1521))
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