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

Thank you so very much, Mark!

On 3/15/2022 9:34 PM, Mark Burgess wrote:
> 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
> <https://docs.oracle.com/en/database/oracle/oracle-database/12.2/jjdbc/JDBC-support-Oracle-FAN.html#GUID-069265AF-BBEE-4682-9906-98D8429BFC1C>
>
> 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