Re: expertise with FCF or FAN

Priit,

Oracle Restart (a.k.a. single-instance Grid Infrastructure) includes ONS and ASM.

Thanks!

-Tim

On 2/19/2022 5:13 AM, Priit Piipuu wrote:
> 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