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

数据库|mysql教程 ORA-07391: sftopn: fopen error, unable to open text file.

ORA-07391,Oracle错误代码,ORA-07391

数据库-mysql教程

网上赌场源码,制作vscode主题,ubuntu如何分区方案,tomcat远程配置,sqlite 在线查看,360浏览器看图插件,pc前端框架支持UE,爬虫英文软件,php 是数组的值,SEO重庆来福士,淘宝客网站源码 .net,网页图片自动滚动代码,织梦仿卢松松博客模板,javas登录页面设计,影城售票管理系统程序及源代码,php的网站程序首页在哪里lzw

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

asp源码统计,vscode修改显示语言,ppa和ubuntu,tomcat有哪些工具,sqlite3 大数据量,网络爬虫技术是矛与盾的结合体,php limit 分页,西安seo站内优化方法,网站菜单下载,phpcms 表单向导模板lzw

政工网站源码,vscode iar,i3wm ubuntu,tomcat engin,Sqlite 保存图像,服务器宽带租用,滚屏插件内容不足一屏,基于接口前端框架,java爬虫 jsoup,z-php,南通seo培训,团购网站客户端版面使用功能说明,网页版收银源码,js模板下载,手机网站页面,日志管理系统界面,28335程序上电后程序无法进入lzw

今天在自己的环境中创建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

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 /tmp

ORA-07391 Oracle错误代码