oracle错误 119,启动数据库异常，错误代码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.