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.

4

2 Answers

You can specify spfile and pfile locations:

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

Maybe you could try to restore it from backups if you have any. Bellow you have a good guide:

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.