ORA-01078: failure in processing system parameters-LRM-00109: could not open parameter file ‘E:\APP\PRODUCT\11.2.0\DBHOME_2\DATABASE\INITSAEUV07.ORA’-SQL> create spfile from pfile=’E:\APP\PRODUCT\11.2.0\DBHOME_2\dbs\initsaeuv07.ora’;
Cause:
The following error occur due to wrong location of pfile taken by database itself
SQL> startup upgrade;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'E:\APP\PRODUCT\11.2.0\DBHOME_2\DATABASE\INITSAEUV07.ORA'
Workaround:
By default your instance take pfile to startup. So you can create spfile from pfile
SQL> create spfile from pfile='E:\APP\PRODUCT\11.2.0\DBHOME_2\dbs\initsaeuv07.ora';
File created.
Try to start instance
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 9386692608 bytes
Fixed Size 2289080 bytes
Variable Size 4865393224 bytes
Database Buffers 4496293888 bytes
Redo Buffers 22716416 bytes
Database mounted.
Database opened.