linux redhat & Oracle

解决oracle参数系统文件出错

2019-10-11  本文已影响0人  重庆思庄

故障现象: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"

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Thu May 30 07:33:10 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> conn / as sysdba

Connected to an idle instance.

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/oracle/app/product/10g/db_1/dbs/initoracle.ora'

解决:

[oracle@RHEL5 ~]$ find /u01 -name pfile //查看pfile位置

/u01/ora/admin/orcl/pfile

[oracle@RHEL5 ~]$ ls -l /u01/app/admin/orcl/pfile

total 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

复制/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/dbs

[root@localhost dbs]# ll

总计 52

-rwxrwxr-x 1 oracle dba 1544 05-28 09:06 hc_oracle.dat

-rwxrwxr-x 1 oracle dba 12920 2001-05-03 initdw.ora

-rwxrwxr-x 1 oracle dba 8385 1998-09-11 init.ora

-rwxrwxr-x 1 oracle dba 799 2013-05-30 oracleinit.ora

[oracle@RHEL5 ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.1.0 Production on Sat Jan 21 13:26:28 2013

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to an idle instance.

上一篇下一篇

猜你喜欢

热点阅读