Error: ORA-01078: failure in processing system parameters
SQL> create spfile from pfile;
create spfile from pfile
*
ERROR at line 1:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file
'/data/oracle/product/11.2.0/db_1/dbs/initorcl.ora'
As shown below:
Solution:
Copy the init.ora.xxx file from the $ORACLE_BASE/admin/orcl/pfile directory to the $ORACLE_HOME/dbs directory and rename it to initorcl.ora. Note that the exact paths depend on your Oracle installation directory structure:
cp /data/oracle/admin/orcl/pfile/init.ora.914201625650 /data/oracle/product/11.2.0/db_1/dbs/initorcl.ora
Then recreate it:
SQL> create spfile from pfile;
File created.