ORA-01078 LRM-00109 ORA-00119 ORA-00132报错处理

来源:这里教程网 时间:2026-03-03 11:56:02 作者:

数据库启动发现如下报错: [oracle@test01 ~]$ !sql sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 22 08:52:24 2018 Copyright (c) 1982, 2014, Oracle.  All rights reserved. Connected to an idle instance. SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initwls.ora' SQL> ! #文件不存在 执行以下操作: [oracle@test01 pfile]$ cp /u01/app/admin/wls/pfile/init.ora.722201883016 $ORACLE_HOME/initwls.ora 然后执行启动数据库的操作: sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Wed Aug 22 09:11:05 2018 Copyright (c) 1982, 2014, 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_WLS' SQL> ! 依旧报错 执行以下操作: 将initwls.ora 文件中local_listener做出如下修改: local_listener= "(ADDRESS =(PROTOCOL = TCP)(HOST = test01)(PORT = 1521))" 再次执行起库操作: SQL> tartup ORACLE instance started. Total System Global Area 4194304000 bytes Fixed Size                  2932336 bytes Variable Size            2348810640 bytes Database Buffers         1828716544 bytes Redo Buffers               13844480 bytes ???????? ???????? SQL> 启动成功!

相关推荐