ORA-01078 failure in processing system parameters解决方法

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:796

[font=SimSun, STSong]oracle11g中启动该实例时都会出现如下错误:
[font=SimSun, STSong]ORA-01078: failure in processing system parameters
[font=SimSun, STSong]LRM-00109: could not open parameter file '/oracle/product/10.2.0/dbs/initorcl.ora'

[font=SimSun, STSong]解决方法如下:
[font=SimSun, STSong]通过sqlplus来连接数据库,在启动oracle时,突然报错:
[font=SimSun, STSong]ORA-01078: failure in processing system parameters
[font=SimSun, STSong]LRM-00109: could not open parameter file '$ORACLE_HOME/db_1/dbs/initfstest.ora'
[font=SimSun, STSong][oracle@datatest ~]$ sqlplus "/as sysdba"
[font=SimSun, STSong]SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 15 10:54:03 2010
[font=SimSun, STSong]Copyright (c) 1982, 2007, Oracle. All rights reserved.
[font=SimSun, STSong]Connected to an idle instance.
[font=SimSun, STSong]SQL> startup
[font=SimSun, STSong]ORA-01078: failure in processing system parameters
[font=SimSun, STSong]LRM-00109: could not open parameter file '/oracle/product/11.1.0/db_1/dbs/initfstest.ora'
[font=SimSun, STSong]
[font=SimSun, STSong]原来打不开initfstest.ora,于是进入/oracle/product/11.1.0/oradata/dbs/目录,
[font=SimSun, STSong][oracle@datatest ~]$ cd /oracle/product/11.1.0/oradata/dbs/
[font=SimSun, STSong][oracle@datatest dbs]$ ls
[font=SimSun, STSong]hc_datatest.dat hc_mm.dat initdw.ora init.ora lkMM orapwmm spfilemm.ora
[font=SimSun, STSong]
[font=SimSun, STSong]原来是没有initfstest.ora文件
[font=SimSun, STSong]解决此问题的方法就是到cd $ORACLE_BASE/admin/fstest/pfile/目录下,将ora.1114201016265复制到dbs目录下:
[font=SimSun, STSong]cp init.ora.1114201016265 /oracle/product/11.1.0/oradata/initfstest.ora
[font=SimSun, STSong]
[font=SimSun, STSong]然后再次用sqlplus连接数据库
[font=SimSun, STSong][oracle@datatest dbs]$ sqlplus "/as sysdba"
[font=SimSun, STSong]SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 15 11:04:25 2010
[font=SimSun, STSong]Copyright (c) 1982, 2007, Oracle. All rights reserved.
[font=SimSun, STSong]Connected to an idle instance.
[font=SimSun, STSong]SQL> startup
[font=SimSun, STSong]ORACLE instance started.
[font=SimSun, STSong]Total System Global Area 954155008 bytes
[font=SimSun, STSong]Fixed Size 1303916 bytes
[font=SimSun, STSong]Variable Size 239078036 bytes
[font=SimSun, STSong]Database Buffers 708837376 bytes
[font=SimSun, STSong]Redo Buffers 4935680 bytes
[font=SimSun, STSong]ORA-01102: cannot mount database in EXCLUSIVE mode
[font=SimSun, STSong] OK了
[font=SimSun, STSong]如还是报错。也可将SPFILE文件重新建立。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】