Oracle 10 spfile

oracle Sweden
  • 14 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.

“The greatest performance improvement of all is when a system goes from not-working to working.” - John Ousterhout