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

今天在自己的环境中创建pfile报错了。环境是：OS:11.2.0.2 RAC，OS:RHEL 5.6创建pfile，报ORA-01565这个是因为不能找到spfile。
[Oracle@11rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Sun Oct 7 22:25:05 2012

Copyright （c） 1982, 2010, Oracle. All rights reserved.

Connected to an idle instance.

SQL> create pfile="/tmp/123.ora" from spfile;
create pfile="/tmp/123.ora" from spfile
*
ERROR at line 1:
ORA-01565: error in identifying file "？/dbs/spfile@.ora"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
查看spfile文件位置
SQL> ！srvctl config database -d power
Database unique name: power
Database name:
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +data/power/PARAMETERFILE/spfile.257.795051357
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: power
Database instances: power1,power2
Disk Groups: DATA,ARCH
Mount point paths:
Services: server1,server2
Type: RAC
Database is administrator managed
创建pfile到/tmp空间下面，/tmp空间一般是所有用户都有w权限的
SQL> create pfile="/tmp/123.ora" from spfile="+data/power/PARAMETERFILE/spfile.257.795051357";
create pfile="/tmp/123.ora" from spfile="+data/power/PARAMETERFILE/spfile.257.795051357"
*
ERROR at line 1:
ORA-07391: sftopn: fopen error, unable to open text file.
查看错误解释
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.

晕报了ORA-07391,这个是由于权限不对，换个目录正常
SQL> create pfile="/home/oracle/123.ora" from spfile="+data/power/PARAMETERFILE/spfile.257.795051357";

File created.

SQL> ！ls -ld /tmp
drwxrwxrwt 14 root root 4096 Oct 7 22:32 /tmpOracle 11g 修改DB为 archivelog 模式用XtraBackup实现MySQL的主从复制快速部署【主不锁表】相关资讯 Oracle错误代码 ORA-07391

Oracle错误代码大全（02/16/2015 21:31:57）
Oracle中登陆时报ORA-28000: the （03/06/2013 20:06:23）
Oracle 11g startup时报ORA-03113 （02/21/2013 17:25:55）

Oracle Grid Control OUI-25031错（03/09/2013 09:01:36）
ORA-04091:触发器/函数不能读（02/25/2013 08:28:13）
Oracle错误 ORA-12514 解决方法（02/18/2013 08:50:10）

本文评论查看全部评论（0）