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.
2 Answers
You can specify spfile and pfile locations:
create pfile='path_to_pfile' from spfile='path_to_spfile'; Maybe you could try to restore it from backups if you have any. Bellow you have a good guide:
