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’;

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.

Leave a Reply

Discover more from XscalibaL

Subscribe now to keep reading and get access to the full archive.

Continue reading