ORA-01078: Failure in processing system parameters LRM-00109: cocould not open parameter file'

Spfile file not found when oracle was started, reporting ORA-01078 and LRM-00109 errors

[Oracle @ localhost ~] $ Sqlplus "/As sysdba"

SQL * Plus: Release 11.2.0.1.0 production on Wed Apr 11 17:45:40 2012

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-01078: Failure in Processing System Parameters

LRM-00109: cocould not open parameter file '/oradata/Oracle/112/dbs/initorcl. ora'

 

Solution:

1. Specify the pfile at startup

SQL> startup pfile =/oradata/Oracle/admin/orcl/pfile/init. ora.3102012232637

Oracle instance started.

 

Total system global area 523108352 bytes

Fixed size 1337632 bytes

Variable Size 314574560 bytes

Database buffers 201326592 bytes

Redo buffers 5869568 bytes

Database mounted.

Database opened.

2. After startup, re-create the spfile File

SQL> Create spfile from pfile = '/oradata/Oracle/admin/orcl/pfile/init. ora.3102012232637 ';

 

File Created.

3. Shut down the database

SQL> shutdown immediate

Database closed.

Database dismounted.

Oracle instance shut down.

4. You do not need to specify the pfile when starting the file. By default, the file is started as a spfile.

SQL> startup

Oracle instance started.

 

Total system global area 523108352 bytes

Fixed size 1337632 bytes

Variable Size 314574560 bytes

Database buffers 201326592 bytes

Redo buffers 5869568 bytes

Database mounted.

Database opened.