Oracle boot error ora-01078:failure in processing system parameters

Error:

In the startup Oracle database The Times is wrong as follows:

[Oracle@localhost ~]$ Sqlplus/as SYSDBA

Sql*plus:release 11.2.0.1.0 Production on Sat Feb 16 19:43:43 2013

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

Connected to a idle instance.

Sql> Startup
Ora-01078:failure in processing system parameters
Lrm-00109:could not open parameter file '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/initorcl.ora '

Reason analysis:

This is because in oracle10g and oracle11g, the database will use SPFile to start the database by default, and this error will occur if SPFile does not exist.

Solve one:

Use the Find/u01-name pfile command to find the location of the Pfile file,/u01/app/oracle/admin/orcl/pfile/
Name the init.ora.2212013132036 file copy in the $oracle_base/admin/orcl/pfile directory to the $oracle_home/dbs directory as Initorcl.ora.

(Note: The ORCL in Initorcl.ora is your instance name Oracle_sid, here my SID is: center)

Method Two:

The $oracle_home/dbs directory under the Spflieorcl.ora renamed to Spfilecenter.ora can be. (Note: Center in Spfilecenter.ora is the SID set in the environment variable, Mine is center)

Method Three:

Copy pfile file under init.ora.61420130339 to DBS, and rename to init+ instance name. Ora can

{{{
[Oracle@localhost oracle]$ Find/u01-name Pfile
/u01/app/admin/orcl/pfile
[Oracle@localhost oracle]$ Cd/u01/app/admin/orcl/pfile
[Oracle@localhost pfile]$ ls
init.ora.61420130339
[Oracle@localhost pfile]$ CP Init.ora.61420130339/u01/app/oracle/dbs/initdevdb.ora
}}}