Re: notifications from ONS in Oracle Restart when the node dies

Weblogic by any chance? If not then take a look at this:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/JDBC-support-Oracle-FAN.html#GUID-069265AF-BBEE-4682-9906-98D8429BFC1C Oracle JDBC Support for FAN Events

If Weblogic then have a look at using the GridLink data source - this will let you setup the JDBC data source in WLS as a subscriber to the primary and standby ONS config.

Just been through a testing cycle with this setup on 19c RAC primary and standby and it works really well. The WLS connection pools automatically detected the different ONS events across each site and adjusted the connection pools accordingly.

Regards,

Mark
On 16 Mar 2022, 3:23 PM +1100, Tim Gorman <tim.evdbt_at_gmail.com>, wrote:
> They are all JDBC connections.
>
>
>
> On 3/15/2022 2:31 PM, Mark Burgess wrote:
> > Hi Tim,
> >
> > what client type is connecting? JDBC or OCI based client?
> >
> > Regards,
> >
> > Mark
> > On 16 Mar 2022, 8:25 AM +1100, Tim Gorman <tim.evdbt_at_gmail.com>, wrote:
> > > Colleagues and friends,
> > >
> > > I have a customer who is testing FAN-FCF failovers in a DataGuard
> > > configuration, and the problem is that when the ONS (Oracle Notification
> > > Service) dies along with the host on which the primary database resides,
> > > how is the FAN-FCF client informed of the failure?
> > >
> > > Is there a way reference the ONS via a load balancer that is based on
> > > the ONS on both the host on which the DataGuard primary database resides
> > > as well as the ONS on the host on which the DataGuard standby database
> > > resides?
> > >
> > > Everything is working well until the primary host goes down, so
> > > shouldn't the standby ONS take over and send the necessary notification?
> > >
> > > Thoughts?
> > >
> > > Thanks!
> > >
> > > -Tim
> > > --
> > > http://www.freelists.org/webpage/oracle-l
> > >
> > >
>

--
http://www.freelists.org/webpage/oracle-l