Database startup exception, error code ORA-00119, ORA-00132

The following error is reported when starting Oracle in SQLplus

 ORA-00119: invalid specification for system parameter LOCAL_LISTENER ORA-00132: syntax error or unresolved network name 'LISTENER_ORCL'

Resolution process:

Create spfile parameter file

 create pfile from spfile;

From the
Database folder (% ORACLE_HOME% database)
Find this file,
The file name format is as follows (INIT% ORACLE_SID%. ORA)
Namely, init database service name.ora

Of course, it depends on the situation,
For example, I found this folder in the dbs folder under Linux..

Open and edit the file after finding it
search local_listener='LISTENER_ORCL'
Then delete the line and save it.
Specify Start From

 #Specify Start From #Example startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'

It should start successfully under normal conditions

Then create a pfile file through spfile

 create spfile from pfile;

Attempt to start

 startup

If prompted
ORA-01081: cannot start already-running ORACLE - shut it down first
Just close it

 shutdown

do it again

 startup

OK, it's done~

Oracle can be started normally.

Some operation records:

 [ oracle@dbserver1051  ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 3 14:07:35 2018 Copyright (c) 1982, 2013, 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_ORCL' SQL> create pfile from spfile; File created. #Split line, see the above steps. Please modify the initorcl.ora file before continuing SQL> startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'; ORACLE instance started. Total System Global Area 2421825536 bytes Fixed Size            2255632 bytes Variable Size          805307632 bytes Database Buffers     1593835520 bytes Redo Buffers           20426752 bytes SQL> create spfile from pfile;  File created. SQL> startup   ORA-01081: cannot start already-running ORACLE - shut it down first SQL> shutdown  ORA-01507: database not mounted ORACLE instance shut down. SQL> startup  ORACLE instance started. Total System Global Area 2421825536 bytes Fixed Size            2255632 bytes Variable Size          805307632 bytes Database Buffers     1593835520 bytes Redo Buffers           20426752 bytes Database mounted. Database opened.