An error occurred while creating pfile in your environment today.
Environment: OS: 11.2.0.2 RAC, OS: RHEL 5.6
Create pfile, reporting ORA-01565 this is because spfile cannot be found.
[Oracle @ 11rac1 ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.2.0 Production ction on Sun Oct 7 22:25:05 2012
Copyright (c) 1982,201 0, 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
View the spfile File Location
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
Create a pfile to the/tmp space. Generally, all users have the w permission for the/tmp space.
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:
The ORA-07391: sftopn: fopen error, unable to open text file.
View error description
SQL>! Oerr ora 07391.
07391,000 00, "sftopn: fopen error, unable to open text file ."
// * Cause: Fopen library routine returned an error.
// * Action: Verify existence and permissions.
Dizzy reported the ORA-07391, this is because the permission is wrong, change the directory normal
SQL> create pfile = '/home/oracle/123. ora' from spfile = '+ data/power/PARAMETERFILE/spfile.257.795051357 ';
File created.
SQL>! Ls-ld/tmp
Drwxrwxrwt 14 root 4096 Oct 7 22: 32/tmp