ORA-01078: failure in processing system parameters_flying

解决oracle 11g 问题之ORA-01078: failure in processing system parameters

(2011-08-22 23:21:02)

转载

标签：

杂谈

昨天刚刚将oracle 11G安装完成，今天想通过sqlplus来连接数据库，在启动oracle时，突然报错：

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.1.0/db_1/dbs/initDATATEST.ora'

[oracle@datatest ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 15 10:54:03 2010

Copyright (c) 1982, 2007, 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.1.0/db_1/dbs/initDATATEST.ora'

 

原来打不开initDATATEST.ora，于是进入/u01/app/oracle/product/11.1.0/db_1/dbs/目录，

[oracle@datatest ~]$ cd /u01/app/oracle/product/11.1.0/db_1/dbs/

[oracle@datatest dbs]$ ls

hc_datatest.dat  hc_mm.dat  initdw.ora  init.ora  lkMM  orapwmm  spfilemm.ora

 

原来是没有initDATATEST.ora文件

解决此问题的方法就是到cd /u01/app/oracle/admin/datatest/pfile/目录下，将ora.1114201016265复制到dbs目录下：

cp init.ora.1114201016265 /u01/app/oracle/product/11.1.0/db_1/initDATATEST.ora

 

然后再次用sqlplus连接数据库

[oracle@datatest dbs]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Wed Dec 15 11:04:25 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area  954155008 bytes

Fixed Size                  1303916 bytes

Variable Size             239078036 bytes

Database Buffers          708837376 bytes

Redo Buffers                4935680 bytes

ORA-01102: cannot mount database in EXCLUSIVE mode

 

OK,可以了