UCP/FCF: SQLRECOVERABLEEXCEPTION AFTER FAILOVER
Last updated on AUGUST 13, 2015
Applies to:Universal Connection Pool - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 11.2 to 12.1]
Information in this document applies to any platform.
When using UCP 18.104.22.168.0 or 22.214.171.124.0 with RAC 126.96.36.199.0 server, FCF does not work. To observe the problem, either turn on UCP logging or obtain
FCF statistics after an injected outage. The log would show the received FAN event as invalid; and the statistics string would show no FCF processing has taken place.
UCP throws java.sql.SQLRecoverableException as follows:
The issue reproduces with both UCP 188.8.131.52 and 184.108.40.206.
The JDBC version is not relevant to to the reproducibility.
UCP 220.127.116.11 + JDBC 18.104.22.168 -> Y(reproduced)
UCP 22.214.171.124 + JDBC 126.96.36.199 -> Y
UCP 188.8.131.52 + JDBC 184.108.40.206 -> Y
UCP 220.127.116.11 + JDBC 18.104.22.168 -> N
target DB is 22.214.171.124 in all cases above.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms