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

 

又出现新问题：ORA-01102: cannot mount database in EXCLUSIVE mode

解决方法如下：

发现是lk<SID>文件造成的，该文件位于ORALCE_HOME下的dbs目录下，马上检查该文件：

[root@localhost dbs]# fuser -u lkORCL
lkORCL:               3252(oracle)  3254(oracle)  3256(oracle)  3258(oracle)  3260(oracle)  3262(oracle)  3264(oracle)  3266(oracle)  3268(oracle)  3270(oracle)  3272(oracle)  3286(oracle)  3440(oracle)  3442(oracle)  3651(oracle)

果然该文件没释放，用fuser命令kill掉：

[root@localhost dbs]# fuser -k lkORCL

然后在：

SQL> startup
ORACLE instance started.

Total System Global Area 1224736768 bytes
Fixed Size                  2020384 bytes
Variable Size             318770144 bytes
Database Buffers          889192448 bytes
Redo Buffers               14753792 bytes
Database mounted.
Database opened.
SQL>

测试一下：

SQL> select * from user_tables；

------------------------------ ------------------------------ ---------------
TABLE_LOCK               SAMPLE_SIZE LAST_ANALYZED   PARTITION
------------------------ ----------- --------------- ---------
IOT_TYPE                             TEM SEC NESTED    BUFFER_POOL
---------ROW_MOVEMENT            GLOBAL_ST USER_STAT
DISABLED                 YES       NO


SQL>

OK，一切正常。