07391: sftopn: fopen error, un

Connected to an idle instance.

SQL> create pfile='/tmp/123.ora' from spfile;

create pfile='/tmp/123.ora' from spfile

*

ERROR at line 1:

hi,allapr 17 09:34:13 localhost opensips: critical:core:yyerror: 2parse error in config file, line 192, column 1-6: syntax error apr 17 09:34:13 localhost opensips: critical:core:yyerror: 2parse error in config file, line 192, column 1-6: invalid arguments apr 17 09:34:13 localhost opensips: error:core:main: bad config file (2 errors)。/dbs/spfile@.ora。database spfile location: /u01/app/oracle/product/11.2.0/db_1/dbs/spfileorcl.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空间下面fopen linux 失败fopen linux 失败，/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."

the result is again two lines, each with a 0 in the first field, indicating no error. if an error occurred at any stage this would be non-zero and the next field would be an error message. the next field shows the number of results returned, then if there are results, they are provided as tab separated fields.。nginx: [emerg] bio_new_file("/opt/lnmp/nginx/conf/cert.pem") failed (ssl: error:02001002:system library:fopen:no such file or directory:fopen('/opt/lnmp/nginx/conf/cert.pem','r') error:2006d080:bio routines:bio_new_file:no such file)。while the database server was processing an update, it received anunexpected error. check the accompanying isam error code for moredetailed information on the cause. possible cause。

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

本文来自电脑杂谈，转载请注明本文网址：
http://www.pc-fly.com/a/jisuanjixue/article-111433-1.html