I could not dind alert file in bdump folder
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: I could not dind alert file in bdump folder

  1. #1
    Join Date
    Apr 2007
    Posts
    2

    I could not dind alert file in bdump folder

    Hello

    I could not dind alert file in bdump folder
    SQL> startup nomount pfile=C:\oracle\admin\arundb\pfile\initarundb.ora
    ORACLE instance started.

    Total System Global Area 118255568 bytes
    Fixed Size 282576 bytes
    Variable Size 83886080 bytes
    Database Buffers 33554432 bytes
    Redo Buffers 532480 bytes
    SQL> SHOW PARAMETER DUMP

    NAME TYPE VALUE
    ------------------------------------ ----------- -----------------------------
    background_core_dump string partial
    background_dump_dest string C:\oracle\admin\arundb\bdump
    core_dump_dest string C:\oracle\admin\arundb\cdump
    max_dump_file_size string UNLIMITED
    shadow_core_dump string partial
    user_dump_dest string C:\oracle\admin\arundb\udump
    SQL> alter database mount;
    database mounted
    ----------------------
    now when i try to run alter database open i find error
    ORA-01092: ORACLE instance terminated. Disconnection forced
    i could not locate alert file to trouble shoot
    Please help

  2. #2
    Join Date
    Jun 2007
    Location
    İstanbul/Turkey
    Posts
    25
    go to C:\oracle\admin\arundb\bdump
    alert log should be there alert_{ORACLE_SID}.log
    you need to look alert log file.Because the detailed information is there.
    This error can make you drop and recreate the database in the worst case.
    So alert log file is important.According to details in alert log file,there are different solutions..

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