Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

create pfile from spfile ORA-27037

user594143Nov 7 2007 — edited Nov 7 2007

This always worked on some other Databases I worked in past. however this Database raise error. Here are the steps on how I did it

Old initSID.ora file located in directory below
cd $ORACLE_HOME/dbs

sqlplus / as sysdba...

SQL> create pfile from spfile ;
create pfile from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

Any idea why this does not work?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2007

Added on Nov 7 2007

#general-database-discussions

8 comments

1,359 views