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

SQL> create pfile='/u01/inittips1.ora' from spfile;  
create pfile='/u01/inittips1.ora' from spfile
*
ERROR at line 1:
ORA-07391: sftopn: fopen error, unable to open text file.  

再次執行

SQL> create pfile='/u01/inittips1.ora' from spfile='+DATA/tips/spfiletips.ora';  
create pfile='/u01/inittips1.ora' from spfile='+DATA/tips/spfiletips.ora'
*
ERROR at line 1:
ORA-07391: sftopn: fopen error, unable to open text file.

查看/u01目錄的權限得知，是權限導致的問題

[root@tip01 oracle]# ls -ld /u01/  
drwxr-xr-x 3 root oinstall 4096 05-30 00:55 /u01/

[root@tip01 ~]# ls -ld /u01/app/oracle/
drwxrwxr-x 7 oracle oinstall 4096 06-25 00:30 /u01/app/oracle/  

[root@tip01 ~]# chown oracle:oinstall /u01








在/u01/app/oracle/目錄下建立pfile

SQL> create pfile='/u01/app/oracle/inittips1.ora' from spfile='+DATA/tips/spfiletips.ora'; 
File created.

SQL> create pfile='/u01/app/oracle/inittips1.ora' from spfile;  
File created.