ORA-01078:failure in processing system parameters的问题
- 故障现象:ORA-01078: failure in processing system parameters
-
LRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl10g.ora'原理:在oracle9i和oracle10g中,数据库默认将使用spfile启动数据库,如果spfile不存在,则就会出现上述错误。www.2cto.com解决办法:方法一:将$ORACLE_BASE/admin/orcl/pfile目录下的init.ora.0212012125517形式的文件copy到$ORACLE_HOME/dbs目录下initoracl.ora即可。(注:initoracl.ora中的oracl为你的实例名 ORACLE_SID,这里我的SID为:orcl10g)方法二:将$ORACLE_HOME/dbs目录下spflieoracl.ora改名为spfileorcl10g.ora即可。(注:spfileorcl10g.ora中的orcl10g为环境变量中设置的SID,我的是orcl10g)---------------------------------------------------------------------------------------故障:[root@RHEL5 ~]# su – oracle[oracle@RHEL5 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 Production on Sat Jan 21 13:10:47 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.www.2cto.comSQL> startupORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/u01/app/oracle/product/10.2.0/db_1/dbs/initorcl10g.ora'解决:[oracle@RHEL5 ~]$ find /u01 -name pfile //查看pfile位置/u01/ora/admin/orcl/pfile[oracle@RHEL5 ~]$ ls -l /u01/app/admin/orcl/pfiletotal 4-rw-r----- 1 oracle oinstall 1909 Jan 21 12:45 init.ora.0212012125517[oracle@RHEL5 ~]$cp /u01/ora/admin/orcl/pfile/init.ora.0212012125517 /u01/app/oracle/product/10.2.0/db_1/dbs/ //把pfile下的init.ora.0212012125517复制/u01/app/oracle/product/10.2.0/db_1/dbs/initorc1.ora并改名为initorc1.ora[oracle@RHEL5 ~]$ cp /u01/app/admin/orcl/pfile/init.ora.0212012125517 /u01/app/oracle/product/10.2.0/db_1/dbs/initorc1.ora[oracle@RHEL5 ~]$ ls -l /u01/app/oracle/product/10.2.0/db_1/dbstotal 32-rw-r--r-- 1 oracle oinstall 2851 May 15 2009 init.oradrwx------ 2 oracle oinstall 4096 Jan 21 12:45 peshm_orcl_0-rw-rw---- 1 oracle oinstall 1544 Jan 21 12:45 hc_orcl.dat-rw-r----- 1 oracle oinstall 24 Jan 21 12:49 lkORCL-rw-r----- 1 oracle oinstall 1536 Jan 21 12:56 orapworcl-rw-r----- 1 oracle oinstall 2560 Jan 21 13:16 spfileorcl.ora-rw-r----- 1 oracle oinstall 1909 Jan 21 13:18 initorc1.orawww.2cto.com[oracle@RHEL5 ~]$ sqlplus "/as sysdba"SQL*Plus: Release 10.2.0.1.0 Production on Sat Jan 21 13:26:28 2012Copyright (c) 1982, 2009, Oracle. All rights reserved.Connected to an idle instance.