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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s