Lost ALERT file on WinNT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Lost ALERT file on WinNT

  1. #1
    Join Date
    Feb 2000
    Location
    Alexandria, VA, 22314
    Posts
    41

    Lightbulb

    Hi there,

    I have created a database (8.1.6) on WindowsNT, and I have BACKGROUND_DUMP_DEST set to c:\oracle\admin\vpdev\bdump in the initVPDEV.ora file.

    However, there is no ALERT file there - Oracle does not seem to write one to this directory. Am i missing something that i need to set?

    Please help - this has never happened before.

    Thanks, KA

  2. #2
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    just to double-check (that the correct init file is in use) try this --

    select value from v$parameter where name = 'background_dump_dest';

    If this still points to the directory you mentioned above then --

    Try to do a log switch (so that it writes to the Alert file) --

    alter system switch logfile;

    and then search for the recently modified files on NT

    - Rajeev
    Rajeev Suri

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