could not open parameter file -Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: could not open parameter file -Urgent

  1. #1
    Join Date
    Aug 2002
    Posts
    13

    could not open parameter file -Urgent

    Hi all,

    I have tried to start Oracle8i in svrmgrl

    Getting following errors.
    LRM-00109: could not open parameter file 'E/oracle/ora81/initorgs.ora'
    ORA-01078: failure in processing system parameters

    I've specified pfile path in the registry as 'E\oraadmin\orgs\initorgs.ora' but it is seraching in the oracle home for the pfile and so am unable to startup the database.

    Plz help me in solving this problem.

    Thanks,
    dsr

  2. #2
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    You can put a init.ora file in $ORACLE_HOME/database which has an IFILE='remote_file_name' parameter to point to your remote parameter file.

    Also I think you may need to restart the service on NT for it to re-read the registry entries (not 100% on this one)

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Hi
    Try this

    c:\winnt>svrmgrl

    svrmgrl> connect internal
    svrmgrl> startup pfile='E\oraadmin\orgs\initorgs.ora'

    Regards
    Amar

  4. #4
    Join Date
    Aug 2002
    Posts
    13
    Hi,

    startup with pfile specified works. But what i want to knw is
    ---If i give startup(w/o pfile specified), it is luking into Oraclehome(oracle\ora81\database\init.ora) but in registry i've specifed another path(oradmin\orgs\init.ora) for pfile.
    Since it is looking into wrong place for pfile, database is unable to startup.

    Jim, if u want me to copy init.ora into oraclehome\database n then specify ifile = 'remote filename'...then guess i can as well have my pfile in oracle home itself but that is not the solution am looking for.

    Thanx 4 ur responses.

    dsr.

  5. #5
    Join Date
    May 2002
    Posts
    2,645
    Why are you playing with the registry? And what does this have to do with certification?

  6. #6
    Join Date
    Aug 2002
    Posts
    13
    well...am not playing with the registry.

    Can any please answer my questions.

    1.Where will the path for parameter file be taken from(if we dont specify it during startup)?
    2.Should i place pfile only in Oraclehome\database?
    3.Or is it ok if i place it in a different directory and give that path in the registry.

    Waiting for ur responses,
    dsr.

  7. #7
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    Originally posted by dsr
    1.Where will the path for parameter file be taken from(if we dont specify it during startup)?
    2.Should i place pfile only in Oraclehome\database?
    1. In Windows it will be taken from ORA_%ORACLE_SID%_PFILE reg parameter.

    2. Not necessary.. Good practice will be to place in
    ?\ADMIN\%ORACLE_SID%\PFILE\init%ORACLE_SID%.ora

    Originally posted by dsr
    3.Or is it ok if i place it in a different directory and give that path in the registry.
    3. Its okay.. Not a good practice

  8. #8
    Join Date
    May 2002
    Posts
    2,645
    You need to disabuse yourself of the notion that you "need" to do anything with the registry. Find an Oracle installation guide or pretty much any other documentation that tells you to go dinking around in the registry. It's not like the registry is a sacred Indian burial ground, and if you mess with it, you're going to have 20 years of bad luck. However, as there is no valid reason for you to alter anything in there, well, it is just plain dumb.

    And again, what does this question have to do with certification, this being the certification forum?
    Last edited by stecal; 11-28-2002 at 05:28 PM.

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