ORA-07391: sftopn: fopen error, unable to open text file

Hiya Buddies,

Hope you all are doing well.

Recently, we have faced this ORA-07391: sftopn: fopen error, unable to open text file error while creating pfile from spfile.

SQL> create pfile='/u01/clone/backup/pfile_ORA-DATA.ora' from spfile;

create pfile='/u01/clone/backup/pfile_ORA-DATA.ora' from spfile

*

ERROR at line 1:

ORA-07391: sftopn: fopen error, unable to open text file.

Here, the main thing is there is some access or permission issue which can be avoid by changing the backup directory location.

Please find the below details:

SQL> !

oracle@host:/u01/clone/backup

>># pwd

After changing directory:

>># cd /home/oracle/ora-data

oracle@host:/home/oracle/ora-data

>># pwd

/home/oracle/ora-data

oracle@host:/home/oracle/ora-data

>># sqlplus '/as sysdba'

SQL> create pfile='/home/oracle/ora-data/pfile_ORA-DATA.ora' from spfile;

File created.

SQL>