oracle10g ora-01078,解决oracle 10g 问题之ORA-01078: failure in processing system parameter...

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，一切正常。