Database Down
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Database Down

Hybrid View

  1. #1
    Join Date
    Nov 2006
    Posts
    23

    Database Down

    I have two question.
    My database was down and I had to reboot it back. what are the few things I need to see first and analyze what went wrong in database so that it became slower and slower. Once database was shut down but still the uptime on unix was showing the same when database was slow. I dont know why the jptime on unix remained the same even after database was shut down.

    Thanks

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Did you look into alert_.log file for the root cause?

    Tamil

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    becuase uptime is the uptime of the server, not of the database

  4. #4
    Join Date
    Nov 2006
    Posts
    23
    yes but it didnt show up anything. Alert log file look normal how it is everyday.

  5. #5
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    show me
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #6
    Join Date
    Nov 2004
    Location
    Mumbai, India
    Posts
    452
    My database was down and I had to reboot it back
    Could you please elaborate the above statement?
    How was the database brought down? Did you do it normally or it crashed?
    There are three kinds of lies: Lies, damned lies, and benchmarks...

    Unix is user friendly. It's just very particular about who it's friends are.

    Oracle DBA

  7. #7
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    Quote Originally Posted by alpesh
    I have two question.
    My database was down and I had to reboot it back. what are the few things I need to see first and analyze what went wrong in database so that it became slower and slower. Once database was shut down but still the uptime on unix was showing the same when database was slow. I dont know why the jptime on unix remained the same even after database was shut down.

    Thanks
    Dear Alpesh,

    Your Database was down - How ?
    shutdown immediate ? or Crashed.

    You had to reboot it back ? Again, what, do you mean to say you reboot the Server, correct me if i am wrong.

    In case you reboot the Server, the uptime is misleading you, if not it is correct as the DB Server was running and only the instance was down.

    Paste the exceprts from Alert_SID.log just before and after the time all this happened

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