ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ERROE:

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



Solution:

~]$ cd $ORACLE_HOME/dbs

dbs]$ vi initprod.ora

You've only one listener i.e. LISTENER where MYSID is your service. Since you're using only one default listener you don't need to have local_listenerset. Hence, you can remove the local_listener entry from your pfile initialization parameters and save (:wq!)  the parameter file.


~]$ sqlplus / as sysdba

SQL> startup
ORACLE instance started.
Total System Global Area  830930944 bytes
Fixed Size                  2232920 bytes
Variable Size             490737064 bytes
Database Buffers          335544320 bytes
Redo Buffers                2416640 bytes
Database mounted.
Database opened.
SQL>