系统版本:Centos 5.5 x64
数据库版本:Oracle 11G R2 11.2.0
报错如下:
- [oracle@server253 ~]$ sqlplus / as sysdba
- SQL*Plus: Release 11.2.0.1.0 Production on 1 17:38:49 2012
- Copyright (c) 1982, 2009, Oracle. All rights reserved.
- SQL> startup
- ORA-01078: failure in processing system parameters
- LRM-00109: ???????????????? '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initmander.ora'
- SQL>
解决过程如下:
- [oracle@server253 pfile]$ cat init.ora.6212012171120 >/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initmander.ora
- [oracle@server253 pfile]$ pwd
- /u01/app/oracle/admin/benguo/pfile
- [oracle@server253 pfile]$
这是因为在oracle9i和oracle10g中,数据库默认将使用spfile启动数据库,如果spfile不存在,则就会出现上述错误。
解决方法:(过程代码上——)
将$ORACLE_BASE/admin/数据库名称/pfile目录下的init.ora.012009233838形式的文件copy到$ORACLE_HOME/dbs目录下initoracle.ora即可。(注:initoracle.ora中的oracle为你的实例名 ORACLE_SID)
- SQL> startup
- ORA-01078: failure in processing system parameters
- LRM-00109: ???????????????? '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initmander.ora'
- SQL>
- SQL>
- SQL> e^Hs
- SP2-0042: δ֪ "s" -
- SQL>
- SQL>
- SQL> startup
- ORACLE
- Total System Global Area 417546240 bytes
- Fixed Size 2213936 bytes
- Variable Size 268437456 bytes
- Database Buffers 142606336 bytes
- Redo Buffers 4288512 bytes
- SQL>