Re: expertise with FCF or FAN

FAN relies on ONS, which runs as node app in Clusterware. Not sure if it can be run independently.

We've heard rumors (from Oracle) that cman with proxy resident connection pool can notify client if something happens with the database. Unfortunately our POC is still in the works, so I can't comment much on it ;)

On Wed, 16 Feb 2022 at 16:22, Tim Gorman <tim.evdbt_at_gmail.com> wrote:

> Sorry, I should have specified; I can't believe I left out these
> important details...
>
> This environment is for DataGuard FSFO, not RAC. The dbTier will stay
> Restart. Current version is 12.1.0.2.0, but they promise an upgrade to 19c
> soon.
>
> Thank you.
>
>
>
> On 2/15/2022 10:47 PM, Jon Crisler wrote:
>
> So the POC will be an Oracle Restart configuration, but will the final
> platform be a multinode RAC ? Most of the functionality for JDBC
> connectivity is part of the jdbc.jar, so if you have both the local and
> target DB in the connect strings, it will connect fine without any app
> changes. A common problem is the failure to open up ONS between the app
> and db, port 6200 by default. Metalink has a ONS java validation program
> somewhere that is good to check the network and db setup. Also check that
> ONS is responding properly on the db side, but this is pretty reliable in
> 12c and beyond. Also try to use a very recent ojdbc.jar- generally use the
> same or higher version on the client . versions 11 and early 12.1 had
> some nasty and difficult to find bugs dealing with Scan-IP, but I found
> that 19c has been pretty solid.
>
> On Tue, Feb 15, 2022 at 12:39 PM Tim Gorman <tim.evdbt_at_gmail.com> wrote:
>
>> Friends and colleagues,
>>
>> I have a customer interested in setting up FCF (fast connection failover)
>> and FAN (fast application notification) on their JDBC applications for a
>> POC using Oracle DataGuard.
>>
>> Does anyone have expertise and/or gotchas in setting FCF/FAN over a
>> single-instance Oracle Restart configuration?
>>
>> We've reviewed doc pages on About FCF
>> <https://docs.oracle.com/en/database/oracle/oracle-database/19/jjucp/fast-connection-failover.html#GUID-126F8C9B-C0B3-426B-B07D-4B127BBDD867>
>> and Automating FCF
>> <https://docs.oracle.com/database/121/HABPT/config_fcf.htm#HABPT4967>,
>> and we're hoping to chat with someone with practical expertise?
>>
>> Thanks!
>>
>> -Tim
>>
>
>

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