Perl script to verify DB is up.

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_000_01BFDB88.0F0E95B4

Content-Type: text/plain

Hello all,

I and my group are pretty new DBA's and have a question for you all.

Do any of you have a UNIX Perl script that monitors each of your instances to verify the DB is up? If not, pages you?

Also, if you have any suggestions on better ways of handling this, I would really appreciate it.

Thanks! Jennifer :-)

Thanks :)

Jennifer Mabry
Information Access
jennifer.mabry_at_gwl.com
Phone: 303.737.6422
Cell: 303.324.6603

------_=_NextPart_000_01BFDB88.0F0E95B4

Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IhUNAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0AcGABUABwA1ABQAAwBFAQEggAMADgAAANAHBgAV AAcANQAUAAMARQEBCYABACEAAAA3QkE0ODc2Qzc2NDdENDExQTg4RjAwQzA0RkYxRDc5RAA7BwEE gAEAIAAAAFBlcmwgc2NyaXB0IHRvIHZlcmlmeSBEQiBpcyB1cC4A1QoBDYAEAAIAAAACAAIAAQOQ BgAsBQAAHAAAAEAAOQAQw/0OiNu/AR4AcAABAAAAIAAAAFBlcmwgc2NyaXB0IHRvIHZlcmlmeSBE QiBpcyB1cC4AAgFxAAEAAAAWAAAAAb/biA6GbIekhEd2EdSojwDAT/HXnQAAHgAxQAEAAAAFAAAA REVSUwAAAAADABpAAAAAAB4AMEABAAAABQAAAERFUlMAAAAAAwAZQAAAAAACAQkQAQAAAHoCAAB2 AgAA6wMAAExaRnUZiHsfAwAKAHJjcGcxMjX+MgD/AgYCpAPkBesCgwBQEwNUAgBjaArAc2V0/jIG AAbDAoMOUAPVBxMCgzIzE89mNAPFAgBwckJxEuJzdGVtAoM1kxYsBxMgQgtgY2sCg142EecWswXi EUc3FixMoHVjaWRhBgRVAwB3BaAOcAKAfQqACM8J2Tt7Hn8OMDUCgAqBDnELYG4pDhAwMxTgaAWw emTUb2MAACoSVSACkSKAHmwitQr7GaEL8SBIZcpsHhAgB0BsLAqFCoUCSSVwbmQgbXkg2wnACGBw JXAegCAWsBLACnQnEG4H0URCQSe3BCAmwhKAdiewHKBxClC1FyBpAiAgAhAFwHkIYK0lci4mJgqF RCVhbicQDG9mKlMpJVVOSVjcIFAEkAMgBPV0EoAFQFsEYAMAdAWwBCBlANBo3yw1BcALgBcgAHBj B5EuwP4gKUAGgScQLjAnsCiAL9AzBCAnYD8gJpAsUG5vZHQsJ8BhZweRKmE/4SXMQWxzbzJwBpAs afEsEXN1ZzKxKdIEICnxxmIn8QSQIHdhFxAsMusSgCbQbAuAZy4hBAAycPUmoHcIYGwm4B6AJYEn EHxhcCfRHHAuUCewLrAuRSXMVDdRa3MhMfAgFkoJ8AMAZjahOi0p7wqPC5EU4gwBYwBAJiYLRv0X sjEZoD4AJQA69DwQPEaXPk8/UjuITQGgcnkmNk5uKiEAwCnTQWMwQXM1PFVqO6UuAMBC8UBn1ncq wAWgbTxVUCHwKEAKOjHwMyGwLjczN6AuNjQyMjxVQyUxR0dBO2FHcjMyNEfgNmchsAtGG2IxOCYm HaEAAUugAAADAPE/CQQAAAMA/T/kBAAAAwAmAAAAAAADADYAAAAAAAIBRwABAAAALQAAAGM9VVM7 YT0gO3A9R1dMO2w9RUJNQUlMMy0wMDA2MjExMzUzMjBaLTY5MjcyAAAAAB4AOEABAAAABQAAAERF UlMAAAAAHgA5QAEAAAAFAAAAREVSUwAAAABAAAcw5IL7DojbvwFAAAgwtJUOD4jbvwEeAD0AAQAA AAEAAAAAAAAAHgAdDgEAAAAgAAAAUGVybCBzY3JpcHQgdG8gdmVyaWZ5IERCIGlzIHVwLgAeADUQ AQAAADsAAAA8NDkxQTMxNTFFMzEyRDMxMUI4N0UwMDkwMjc0Njg2QUMwNUIwRjIyMkBlYm1haWwz Lmd3bC5jb20+AAALACkAAQAAAAsAIwAAAAAAAwAGENzIl5YDAAcQUwEAAAMAEBAAAAAAAwAREAAA AAAeAAgQAQAAAGUAAABIRUxMT0FMTCxJQU5ETVlHUk9VUEFSRVBSRVRUWU5FV0RCQVNBTkRIQVZF QVFVRVNUSU9ORk9SWU9VQUxMRE9BTllPRllPVUhBVkVBVU5JWFBFUkxTQ1JJUFRUSEFUTU9OSVRP AAAAAAIBfwABAAAAOwAAADw0OTFBMzE1MUUzMTJEMzExQjg3RTAwOTAyNzQ2ODZBQzA1QjBGMjIy QGVibWFpbDMuZ3dsLmNvbT4AAOFM Received on Wed Jun 21 2000 - 08:53:20 CDT