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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s