ORA-00119: invalid specification for system parameter LOCAL_LISTENER, ORA-00132

ORA-00119: invalid specification for system parameter LOCAL_LISTENER

ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

Solutions:

Step 1: using spfile starting up your database, create a pfile from it.

Enter Username:sys as sysdba
Passwd:

connected to an idle instance.

SQL> create pfile from spfile;

File created.

SQL>exit

Step 2: Edit the pfile and remove the parameter LOCAL_LISTENER

*.local_listener='LISTENER_ORCL'

Step 3: Create spfile from the pfile 

SQL> create Spfile from pfile;

File created.

Step 4: Startup the database

SQL>STARTUP