DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: error when make pfile from spfile

  1. #1
    Join Date
    Oct 2003
    Posts
    312

    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
    Connected.
    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.

  2. #2
    Join Date
    Feb 2001
    Location
    Scotland
    Posts
    200
    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%
    ORACLE_SID%.ORA

    Hope this helps - get back if you need anything else

    Allie
    Last edited by alison; 10-21-2003 at 11:32 AM.
    What's the sound of one hand clapping - "CL"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width