DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle 9i on Windows 2000 Adv server

  1. 12-09-2003, 03:58 PM #1
    Bigity
    Bigity is offline Junior Member
    Join Date
    Dec 2003
    Location
    West Texas
    Posts
    5

    Oracle 9i on Windows 2000 Adv server

    Using Oracle 9i, how can I force the Windows service that controls the database to startup using the init parameter file instead of the spfile?

    I am attempting to cluster the database using Oracle FailSafe, but it appears that just using the Windows service does not successfully start the database. It cannot be accessed via logon using SQL Plus.

    However, when I use OEM to start the database specifying the init file instead of the spfile, the database works as expected.

    I have added a registry key ORA__PFILE pointing to the pfile, but it seems to be ignored.
    Lonewolf *SH*
    Reply With Quote Reply With Quote
  2. 12-09-2003, 05:54 PM #2
    sysdba
    sysdba is offline Senior Member
    Join Date
    Jun 2000
    Posts
    295
    the order of init is: spfile first, and then pfile
    So you can delete/rename spfile to force pfile is used.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width