You can use server side callout scripts. see http://forums.oracle.com/forums/thread.jspa?threadID=938756 or http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/restart001.htm#ADMIN13186 so you should get a notification if an Instance start/stops/fails - and you can adapt your environment for it. hope this is what you are looking for, Martin On Tue, Jun 14, 2011 at 17:20, Anupam Pandey <my.oralce@xxxxxxxxx> wrote: > Hi All, > I am searching for solution for a following scenario. > > I have a two node RAC .I have linux machine from where I execute a shell > script which in turn calls other pl/sql packages for data > processing.Multiple instance of that shell script can run with different > input parameters. > > Suppose I started the 1st instance of shell script and the whole data > processing was limited to node 1(N1). > Now I execute the 2nd instance of the shell script (with different input > params) and processing is shared between node 1 (N1) and node 2(N2) . > > Suddenly due to some network failure N2 goes down . > > So is there a way to get the message that N2 has gone down in shell script > .We want this message so that we can update the status accordingly. > > I tried following :- > I tried to emulate this in single instance oracle DB because I didnt have > any RAC test machine. The DB is hosted on machine S1 and the shell script I > executed from S2. After I executed the shell script in S2 to do some insert > ,I removed the network cable from S1(after sometime).But I didnt see any > failure message in S2. > > Let me know if there is anything I missing . > > Thanks, > Anupam -- //www.freelists.org/webpage/oracle-l