ORA-07391: sftopn: fopen error, unable to open text file.
Cause:
I was unable to create pfile from spfile due to lack of permission on the directory
SQL> create pfile='/home/initorcldgp.ora' from spfile;
create pfile='/home/initorcldgp.ora' from spfile
*
ERROR at line 1:
ORA-07391: sftopn: fopen error, unable to open text file.
Workaround:
Verify the permission
[oracle@orcl /]$ ls -lrt|grep home
drwxr-xr-x. 5 root root 4096 Mar 6 13:59 home
Use different directory to create pfile or give permission to the existing directory
[oracle@orcl /]$ chown oracle:oinstall /home/
[or]
SQL> create pfile='/tmp/initorcldgp.ora' from spfile;
File created.