pfile ----> init.ora
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: pfile ----> init.ora

  1. #1
    Join Date
    Dec 2005
    Posts
    6

    pfile ----> init.ora RESOLVED

    Hi!

    Im a student learning Oracle.
    Ive encounterd a problem with the startup of my database.
    in sqlplus, after logging, when i run "startup" command I get this errormessage;

    ORA-01078: failure in processing system parameters
    LRM-00110: syntax error at '{\rtf1\ansi\ansicpg1252\deff0\deflang1053{\fonttbl{\f0\fswiss\fcharset0'

    Ive no clue what it means.

    In order for me to startup the database I have to run command "startup pfile=(searchpath to the init.ora)" Instead of just "startup"

    Any ideas on how to resolve this problem?

    Best regards

    /skalman

    Any idea on how to resolve the problem.
    Last edited by skalman; 12-13-2005 at 08:11 AM. Reason: problem resolved

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    go to ORACLE_HOME/dbs and find the init.ora file you are using, then remove the bad parameters

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Looks like you've used a word processing program to create/edit the init.ora file. You must use a plain text editor, e.g. vi or Notepad.
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman

  4. #4
    Join Date
    Dec 2005
    Posts
    6

    problem resolved

    Thanks DaPi.
    Your suggestion with the editorchange resolved the problem, did not know it was dependent on what type of editor you are using. Thanks again!
    /skalman

  5. #5
    Join Date
    May 2003
    Location
    Pretoria, Rep of South Africa
    Posts
    191
    while your bussy,why not create/use spfile?
    Able was I ere I saw Elba

  6. #6
    Join Date
    Dec 2005
    Posts
    6
    ----------robertbalmer
    ----------while your bussy,why not create/use spfile?


    Mainly because im in an educational mode where we got to choose between using spfile and pfile/init.ora.
    I find pfile more easy to use,but in a "real situtation" I would consider using spfile because it seems to be more dynamic and flexible.

    /skalman

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