今天在创建pfile文件的时候，发现提示ORA-07391错误

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

后来又仔细查看了spfile文件的位置；

[oracle@HBCADB001 ~]$ srvctl config database -d hbcadb
Database unique name: hbcadb
Database name: hbcadb
Oracle home: /u01/sys_software/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATADG/hbcadb/spfilehbcadb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: hbcadb
Database instances: hbcadb1,hbcadb2
Disk Groups: DATADG,ARCHDG
Services:
Database is administrator managed

查看错误代码解释

SQL> !oerr ora 07391
07391, 00000, "sftopn: fopen error, unable to open text file."
// *Cause: Fopen library routine returned an error.
// *Action: Verify existence and permissions.

SQL>
好像是由于权限无法写入导致的；重新指定oracle自己的目录就可以

SQL> create pfile='/home/oracle/init20121019.ora' from spfile;

File created.

------The End

ITPub博客

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

最新文章