ORA-01078: failure in processing system parameters

 

ORA-01078: failure in processing system parameters

Posted by azardba on April 27, 2010

I tried to start my test db , it shows following errors, I struggled with these errors, though finally i find out and fix it. oops but It’s so easy

Enter user-name:sys/sys as sysdba
Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/home/oracle/oracle/product/10.2.0/db_1/dbs/initorcl.ora’
SQL> exit
Disconnected

[oracle@localhost dbs]# ls
hc_azar.dat  initdw.ora  lkAZAR  orapwazar  spfileazar.ora
hc_TEST.dat  init.ora    lkTEST  orapwTEST  spfileTEST.ora

Here inittest.ora file is does not exist, so i created pfile from spfile and then It’s working.

SQL> create pfile from spfile=’/home/oracle/oracle/product/10.2.0/db_1/dbs/spfileTEST.ora’;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              92276304 bytes
Database Buffers          188743680 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
SQL>