in reply to Trap DB Connect

What type of system is your script running on - *nix, Win32, Win32/Cygwin etc? At the sacrifice of portability, that would tell you if the alarm approach will work on your system.

One thing you could do is try to telnet to the port on the remote machine - you won't get a sensible response, but if you get a connection refused or other error, that means network connectivity or other more fundamental issues are your problem.
e.g. telnet oracle_host 3306
would try to telnet to machine oracle_host on port 3306 (which happens to be the default port for MySql - use the Oracle port number that you have configured!)

Replies are listed 'Best First'.
Re^2: Trap DB Connect
by bitman (Scribe) on Jul 30, 2007 at 14:31 UTC
    It's Solaris, 8 I think. I just need the darn thing to fail again so I can verify the the ALRM signal will work for me.

    Thank you very much for all your help.

      Couldn't you just change the URL or unplug the network temporarily?