Troubleshooting for ORA-01078 and LRM-00109

System Version: CentOS 5.5x64

Database Version: Oracle 11G R2 11.2.0

The following error is reported:

 
 

  
  
[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>  
 
 

The solution is as follows:

 
 

  
  
[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]$  
 
 

This is because in oracle9i and oracle10g, the database will start with spfile by default. If spfile does not exist, the above error will occur.
Solution: (Process Code --)
Copy the file in the form of init. ora.012009233838 in the $ ORACLE_BASE/admin/database name/pfile directory to the initoracle. ora directory in the $ ORACLE_HOME/dbs directory. (Note: oracle in initoracle. ora is your instance name 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>