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

Thread: NT service&db ???

  1. #1
    Join Date
    Nov 2000


    I using oracle8.1.6 on NT.
    the problem is every day I have to stop my oracle service and restart is again in order for me access the database.
    I've checked NT event viewer and the only message I get
    is 'service shutdown unexpectedly'. and There is no jobs running scripts to shutdown the services.

    is it from the database or NT???any idea on why is this happining ??? are there tables
    in the database that store information about these kind of errors ????

    thanks in advance,

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    Look at the alertSID.ora and trace files in your background dump destination directory. If you don't know where this directory is, find it with this select:

    SELECT value FROM v$parameter WHERE name = 'background_dump_dest';

    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Apr 2000
    Baltimore, MD
    Check alert log and trace files for errors relating to the unexpected shutdown.

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