Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007

    Unanswered: Bad spfile - Oracle won't start - online log dest

    Hi, My Oracle 9i instance on Win2K will not start. The error I receive is "ORA-01261: Parameter db_create_online_log_dest_1 destination string cannot be tr
    ORA-01263: Name given for file destination directory is invalid
    OSD-04018: Unable to access the specified directory or device.
    O/S-Error: (OS 2) The system cannot find the file specified."

    My spfile is corrupt. I am able to start the db using my init.ora file, but I want to use my spfile. How can I edit the spfile to make the changes for my online_log_dest_1? I created a pfile from my spfile and it does not show anything for online_log_dest_1, just dest_2 through dest_5.

    Thanks very much.


  2. #2
    Join Date
    Jan 2003
    Provided Answers: 17
    Edit the init file to what you want, then create a new spfile.

Posting Permissions

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