Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2002
    Posts
    5

    Unanswered: Oracle Server went down

    Hi there:
    I have a question about under what situation oracle could be cloesd and shutted down by itself?
    I am working with Oracle 9i2, Win2000, front-end is .net.
    What happened is:
    Ten minutes after I finished logical backup, the server was closed and went down automatically. The backup was successful and I didn't have any script running against Oracle during that time.

    Any clue?
    Thanks in advance!
    Tina

  2. #2
    Join Date
    Jan 2003
    Location
    Vienna, Austria
    Posts
    102

    Re: Oracle Server went down

    have you checked the alert.log of the database?
    ^/\x

  3. #3
    Join Date
    Oct 2002
    Posts
    5

    Re: Oracle Server went down

    Yes, I did.
    But what I found is, Oracle was closed first and shutted down. Looked like under very normal condition.

    Originally posted by berxh3g
    have you checked the alert.log of the database?

  4. #4
    Join Date
    Oct 2002
    Location
    greenwich.ct.us
    Posts
    279
    Well, there you go. If it looks like somebody shut it down, than it probably wasn't an error. Maybe you could post the lines from the alert.log where the error occurred...

  5. #5
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Smile

    Check for any batch jobs enabled on this machine:

    c:\>at

    Was the service OracleService<SID> running after you discovered Oracle went down? What about the EventLog? Anything there ??


    Hope that helps,

    clio_usa
    OCP - DBA

Posting Permissions

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