系统:Linux redhat-4 2.6.18-194.el5
oracle:10G _R2
[oracle@lrz ~]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 19 09:13:32 2011
Copyright (c) 1982, 2005, 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 '/opt/oracle/product/10.2.0/db1/dbs/initwqy.ora'
上面错误提示我们找不到initwqy.ora这个文件,直观一点说就是(环境变量中sid设置错误,找不到这个sid对应的启动文件),这就需要我们从其它地方cp一个或者创建一个,
cp $ORACLE_BASE/admin/$ORACLE_SID/pfile/init.ora.9182011161612 /oracle/product/10g/dbs/initorc1.ora
完成上面的操作之后,我就启动了一次,但是还是报错,经过几番周折,想到了文件的属主属组,果然:
[root@lrz dbs]# ll
total 48
-rw-r----- 1 oracle oinstall 1544 Oct 18 16:16 hc_orcl.dat
-rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 8385 Oct 18 17:45 init.ora
-rw-r----- 1 root root 2440 Oct 18 17:52 initwqy.ora
-rw-r----- 1 oracle oinstall 24 Oct 18 16:12 lkORCL
-rw-r----- 1 oracle oinstall 1536 Oct 18 16:16 orapworcl
-rw-r----- 1 oracle oinstall 2560 Oct 18 17:00 spfileorcl.ora
[root@lrz dbs]# chown -R oracle:oinstall initwqy.ora
然后:
[root@lrz dbs]# chown -R oracle:oinstall initwqy.ora
[root@lrz dbs]# ll
total 48
-rw-r----- 1 oracle oinstall 1544 Oct 18 16:16 hc_orcl.dat
-rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora
-rw-r----- 1 oracle oinstall 8385 Oct 18 17:45 init.ora
-rw-r----- 1 oracle oinstall 2440 Oct 18 17:52 initwqy.ora
-rw-r----- 1 oracle oinstall 24 Oct 18 16:12 lkORCL
-rw-r----- 1 oracle oinstall 1536 Oct 18 16:16 orapworcl
-rw-r----- 1 oracle oinstall 2560 Oct 18 17:00 spfileorcl.ora
再次启动数据库:
SQL> startup
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
问题解决了!
转载于:https://blog.51cto.com/wangqiyong/691670