Start database exception, error code ora-00119, ora-00132

December 3, 2018 925 point heat 0 liked it 0 comments

 Theme map
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'

Solution 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)
The init database service name. Ora

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

When you find the file, open to edit it
search local_ listener='LISTENER_ ORCL'
Then delete the line and save it.
Specify start from

 #Specify start from #Examples startup nomount pfile='/u01/app/oracle/product/11.2.0/db_ 1/dbs/initorcl.ora'

Under normal conditions, it should be able to start successfully

 Operation screenshot

Then create pfile file through SPFILE

 create spfile from pfile;

 Operation screenshot
Try to start

 startup

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

 shutdown

 Operation screenshot

do it again

 startup

 Operation screenshot

OK, it's done~

Oracle can start 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.

Gcod

If life is just like the first sight, what is the sad autumn wind painting fan

Article review