在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.
文章评论