Re: question
Date: Wed, 15 Jun 2011 20:53:19 +0200
Message-ID: <BANLkTikr8s5ocagJsyjKv7fnM6044hv8+Q_at_mail.gmail.com>
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_at_gmail.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 15 2011 - 13:53:19 CDT