Invalid specification for system parameter LOCAL_LISTENERORA-00119: invalid specification ORA-00132: syntax error

ISSUE: 

sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu 12 07:37:51 2018

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-00119: invalid specification for system parameter LOCAL_LISTENER
ORA-00132: syntax error or unresolved network name 'LISTENER'
SQL>




CAUSE




Your INIT file by default will look for an ALIAS name of Listener in

TNSNAMES.ora which doesnt exist in the file.




SOLUTION




#OPTION:1

Hence create a same entry for LISTENER in tnsnames.ora file.




LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

 #OPTION 2:

You can directly insert the entry of Local Listener in the INIT file like below.

*.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))'