db up script

Hello -

Does anyone have a script that checks if a series of databases are up and available that they would be willing to share? I set out to write a ksh script to do this and found that I would have to write C to do what I needed to do, since trying to connect to a hung or down instance will result in a hung process. There wasn't an easy way to fire off the connect process, sleep, and kill it if it hadn't come back yet. I really don't want to spend my day writing C code, it will exacerbate the headache my job gave me today.

Any suggestions / script snippets are appreciated Thanks Received on Wed May 10 2000 - 10:13:08 CDT