DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: How I obtains this information?

  1. #1
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    How I obtains this information?

    The company where work has one database that it is not managed internally, was passed the administration to great multi national with three letters only in the name, the problem is that this database was unavailable in last the two months 3 times and me was requested that raised the following information: in the dates where database was unavailable how much down time of this database had? Detail I do not have access to the alert(sid).ora.

    How I obtains this information?
    With one it prays for GOD?
    Crying?
    Cursing the Larry?
    Saying with the Boss
    that of the one not
    to make?

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    When your company is not worrying about the DB, why should you bother?

    Tamil

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    three letters

    EDS, DMR or CSC?

  4. #4
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114
    Pando, You forgot the IBM, but is EDS.

  5. #5
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    Tamil

    Because it is my function to verify if to another company this correctly making everything....

  6. #6
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Tell the great multinational to send you the alert logs for the database?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Tamil

    Originally posted by hhbrazil
    Because it is my function to verify if to another company this correctly making everything....
    I love it. You outsource your DB operations to another company but you have to hire people to monitor the uptime. Let me know the company, I want to short their stock
    Jeff Hunter

  8. #8
    Join Date
    Aug 2000
    Location
    Sao Paulo
    Posts
    114

    slimdave

    Already I asked for a time and them they had not only played rock in me because they estvam working remotely. They speak that not necessary to know what has in alert therefore I have that to trust the administration of them.... BLA BLA BLA BLA.... Bulsheet (Besteira in portuguese). I know that they mask many things...

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by slimdave
    Tell the great multinational to send you the alert logs for the database?
    Nah, they'll just edit out the shutdow/startup commands.
    Jeff Hunter

  10. #10
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    If this were me, I would make sure auditing is turned on and then I would audit the connect/disconnects. This would give me a database perspective of what is going on during all times.

    Also, I would create a DDL trigger that would capture the shutdown/startup of the database so I have proof of when this beast was down.

    I would also write a script that tried to connect to the database every X minutes and record when I couldn't connect.

    Oh wait, I already do this, forget it.
    Jeff Hunter

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