error when make pfile from spfile
I am trying to make the pfile from spfile, when I create the pfile, I specify the location and I got the error:
SQL> connect sys/vms700 as sysdba
SQL> create pfile='c:\temp\init.ora' from spfile;
create pfile='c:\temp\init.ora' from spfile
ERROR at line 1:
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
I did similar to this on another instance on different server and it worked fine.
I think that you don't have a spfile in the default directory, as your on Windows there should be a spfile on.
ORACLE_HOME\database\spfiledba.ora (or whatever your sid is)
If you have create an SP file in another location then you will have to point to it in your create pfile command
sql > create pfile='c:\temp\init.ora' from spfile='c:\oracle\spfiledba.ora';
The reason that this worked on the other database is because the spfile had been created and the database was probably used it to start up (although as long as it exists then you don't have to be using it to run your command successfully)
You can use the command
SQL> SHOW PARAMETER SPFILE;
NAME TYPE VALUE
------- ----------- ------------------------------
spfile string %ORACLE_HOME%\DATABASE\SPFILE%
Hope this helps - get back if you need anything else
Last edited by alison; 10-21-2003 at 11:32 AM.
What's the sound of one hand clapping - "CL"
Click Here to Expand Forum to Full Width