Monday, January 7, 2013

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

Have gotten this error a number of times while attempting to create a PFILE from SPFILE:
CREATE PFILE='/u01/oracle/product/' FROM SPFILE='/u01/oracle/product/'
Cause: Not sufficient permisiions to read from SPFILE

Solution: Run chmod 777 /u01/oracle/product/ to set appropriate permissions


  1. Hello,

    have you tried this..???its not creating any file...still i am getting this error

    1. It worked for me. Everything posted here is from my personal experience. Of course it is possible that your issue is different

  2. I was searching online and was fed i could not solve this error finally this blog helped me to get the right info thanks a lot Elna for sharing your experience it helped me to solve my problem