LRM-00109: could not open parameter,ORA-01078: failure in processing system parameter
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: LRM-00109: could not open parameter,ORA-01078: failure in processing system parameter

Hybrid View

  1. #1
    Join Date
    Jun 2007
    Posts
    42

    LRM-00109: could not open parameter,ORA-01078: failure in processing system parameter

    Dear Gurus,
    I installed oracle 9i enterprise on windows xp.I created the pfile from spfile.
    Then I shutdown the database.I want to start with pfile.I did it as follows.
    SQL> startup pfile='C:\oracle\admin\shihab\pfile\init.ora'
    LRM-00109: could not open parameter file 'C:\oracle\admin\shihab\pfile\init.ora'
    ORA-01078: failure in processing system parameters

    Can you advice me,

    Thanks in advance

    Shabu

  2. #2
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249
    Make sure about pfile location and file name.

  3. #3
    Join Date
    Feb 2007
    Location
    UNDER MOON
    Posts
    44

    Lrm-00109//ora-01078

    LRM-00109
    --This error indicate Your init.ora file could not be found. Make sure it exists in the location what you specified.

    ORA-01078
    --This error message indicate that you have INVALID parameter, or INVALID value for a parameter in your INIT.ORA parameter file. see ALERT log for more info...!!

  4. #4
    Join Date
    Apr 2007
    Posts
    33
    Is your pfile actually called init.ora. Please take your time and check the location, file name etc.

    Thanks

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