Re: expertise with FCF or FAN
Date: Wed, 16 Feb 2022 01:47:57 -0500
Message-ID: <CAB44qRTeWVRqXiVxaMsh1Y8+9FzUOkX8UgN7HxbRODSDmx0QoA_at_mail.gmail.com>
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-lReceived on Wed Feb 16 2022 - 07:47:57 CET