Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to Check whether Server is up in Oracle Stored Procedure

How to Check whether Server is up in Oracle Stored Procedure

From: Srini <aone1504_at_yahoo.com>
Date: 11 Oct 2004 00:29:39 -0700
Message-ID: <e5aecd60.0410102329.3f53cc9f@posting.google.com> 





We have a Oracle client where a trigger is present. A Stored procedure
is associated with the trigger. And link between Oracle client and
server is using DBLINK.



When Oracle server machine is down or database server has crashed, we
want the stored procedure not to be executed. The problem is we do not
always come to know when the server machine is down ( for say,
maintenance ).



Can any one tell me how we can code this check (on the server) inside
the Stored Procedure ?



Regards,


Srini
Received on Mon Oct 11 2004 - 02:29:39 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US