Oracle 10 spfile

oracle Sweden
  • 13 years ago

    I edited the spdile (ora file) and in some way it got corupt. I need to create a new file but don't know how. This is what I read:

     

    if you are on unix,

    $ cd $ORACLE_HOME/dbs
    $ strings spfilename  temp_pfile.ora

    edit the temp_pfile.ora, clean it up if there is anything "wrong" with it.

    then

    SQL> startup pfile=temp_pfile.ora
    SQL> create spfile from pfile;
    SQL> shutdown
    SQL> startup


    On windows -- just try editing the spfile, create a pfile from it.  save it, and do the same.














    Does anyone understand the Windows way?

     

    Regards,

    Magnus

  • 13 years ago

    Hi

    try

    SQL> startup force ;

    RAfeek

     

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer lets you make more mistakes faster than any other invention in human history, with the possible exceptions of handguns and tequila” - Mitch Ratcliffe