启动数据库异常,错误代码ORA-00119,ORA-00132

在SQLplus中startup启动Oracle报下面这个错

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

解决过程:

创建spfile参数文件

create pfile from spfile; 

从Oracle安装目录下面的
database文件夹(%ORACLE_HOME%\database)
找到这个文件 ,
文件名格式是这样的(INIT%ORACLE_SID%.ORA)
即 init数据库服务名.ora

当然,具体视情况而定,
例如我在Linux下面发现这个文件夹在dbs文件夹内。。

找到该文件之后打开编辑该文件
搜索local_listener='LISTENER_ORCL'
然后删除所在行保存即可。
指定从此启动

#指定从此启动  
#示例  
startup nomount pfile='/u01/app/oracle/product/11.2.0/db_1/dbs/initorcl.ora'

正常情况下应该可以成功启动

操作截图

然后通过spfile创建pfile文件

create spfile from pfile; 

操作截图
尝试启动

startup 
如果提示 ORA-01081: cannot start already-running ORACLE - shut it down first 就执行关闭下
shutdown 

操作截图

再试一次

startup 

操作截图

OK,搞定~

Oracle可以正常启动了。

部分操作记录:

[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.
#分割线,看上面步骤,请先修改initorcl.ora文件再继续
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.