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

December 3, 2018 437 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)
Initora is a service name

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 to start from this example start 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

Talking about the trivial matters of life and talking about the whole world, that's all

Article review