在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.