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文件造成的,该文件位于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,一切正常。