Search code examples
oracle-database

On startup of database it denies with error ORA-01078: failure in processing system parameters | LRM-00109: could not open parameter file?

SQL*Plus: Release 12.2.0.1.0 Production on Thu Jul 9 15:06:37 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

SQL> conn sys@Databasename as sysdba
Enter password:
Connected to an idle instance.
SQL> shutdown abort;
ORACLE instance shut down.
SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'C:\APP\ADMINISTRATOR\VIRTUAL\PRODUCT\12.2.0\DBHOME_1\DATABASE\INITdatabasename.ORA'
SQL>

If I go to C:\APP\ADMINISTRATOR\VIRTUAL\PRODUCT\12.2.0\DBHOME_1\DATABASE\ There is no file with this name INITdatabasename.ORA

After search I found that I should create a pfile from spfile.

SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file '?=\DATABASE\SPFILE%ORACLE_SID%.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

SPfile is available in database folder. But is unable to open. Please help.

Solution

  • You can specify spfile and pfile locations:

    create pfile='path_to_pfile' from spfile='path_to_spfile';