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/11.2.0.3/dbs/initdb1.ora' FROM SPFILE='/u01/oracle/product/11.2.0.3/dbs/spfiledb1.ora'
Cause: Not sufficient permisiions to read from SPFILE

Solution: Run chmod 777 /u01/oracle/product/11.2.0.3/dbs/spfiledb1.ora to set appropriate permissions
Posted by at
Labels: ,

3 comments:

  1. learningawsOctober 9, 2014 at 7:34 AM

    Hello,

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

    ReplyDelete
    Replies
    1. ElenaSeptember 29, 2015 at 9:21 AM

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

      Delete
  2. UnknownJuly 12, 2016 at 1:51 PM

    I was searching online and was fed up...as 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

    ReplyDelete

Subscribe to: Post Comments (Atom)