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.

Leave a Reply