Are all these database similar versions of Oracle, or are they all different versions?
When I did something similar I had my monitoring script connect to a database, poll for the necessary information, disconnect, and then connect to another database. Of course this was a shell script, not PL/SQL. Is there any way you could do something similar?
> -----Original Message-----
> From: Smith, Ron L. [mailto:[EMAIL PROTECTED]]
> Sent: mercredi, 2. avril 2003 06:24
> To: Multiple recipients of list ORACLE-L
> Subject: Query through database link gets lost
>
>
> I have a monitoring script that polls and monitors all the
> databases through
> a database link. If someone happens to shutdown or delete a
> database, the
> SQL connection through the database link just seems to hang
> forever and
> screws everything up. Can someone tell me how to set a time
> limit on the
> calling server so the connection will time out? I already have
> SQLNET.EXPIRE_TIME = 60 set in the sqlnet.ora but it doesn't
> appear to help.
>
> Thanks!
>
> Ron Smith
> If you are not the intended recipient of this e-mail message, any use,
> distribution or copying of the message is prohibited. Please
> let me know
> immediately by return e-mail if you have received this
> message by mistake,
> then delete the e-mail message. Thank you.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
