Unexpected Network Error when connecting to Oracle RAC DB 19c with TAC feature enabled in Advanced Authentication

Products

• CA Strong Authentication
• CA Advanced Authentication
• CA Risk Authentication

Issue/Introduction

We are migrating AA 8.1.3 to 9.1. We approached the migration starting migrating all database data (from an oracle 11g -> 12c then 19c) from the current prod instance to the new one, that is a RAC 19c. 

We are able to connect with sql clients (advanced and also the simple sqlplus) but the AA server get refused connection with this error during the startup

Wed Jun 15 18:06:51.364 2022 WARNING: pid 19604 tid 19604: 2: 0: ArDBConnection::connect: Connection to database [<DSN-Name>]. user [<DB-User>] failed. Error detail [SQL State:HY000, Native Code: FFFFFFFB, ODBC code: [CA AA][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.]
Wed Jun 15 18:06:51.364 2022 WARNING: pid 19604 tid 19604: 2: 0: ArDBPool::createNewConnections: Failed to grow the pool [(primary)] : Error [ArDBPool::createDBContextObjs: SQL State:HY000, Native Code: FFFFFFFB, ODBC code: [CA AA][ODBC Oracle Wire Protocol driver][Oracle]Unexpected Network Error.]
All network routes seems open and this is the connection string in the arcotcommon.ini file

URL.1=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<HostName>)(PORT=<Port-No>)))(CONNECT_DATA=(SERVICE_NAME=<service-name>)(SERVER=DEDICATED)))
Username.1=<User-name>

this is the odbc driver conf

[arcotdsn]
ApplicationUsingThreads=1
EnableTimestampWithTimeZone=0
ReportCodepageConversionErrors=2
Description=Oracle
Driver=/apps/CA/AdvAuth/odbc64/lib/WFora28.so
ProcedureRetResults=0
ClientVersion=strOracleClientVersion
ConnectionRetryDelay=3
DescribeAtPrepare=0
LockTimeOut=-1
EnableDescribeParam=0
ArraySize=60000
CatalogIncludesSynonyms=1
DefaultLongDataBuffLen=1024
QueryTimeout=0
#HostName=
EnableStaticCursorsForLongData=0
ReportCodePageConversionErrors=0
LoadBalancing=0
#SID=
ConnectionRetryCount=0
CatalogOptions=0
EnableNcharSupport=0
UseCurrentSchema=1
EnableScrollableCursors=1
ReportRecycleBin=0
OptimizeLongPerformance=0
TNSNamesFile=/apps/CA/AdvAuth/odbc64/tns.ora
ServerName=Servername
TimestampEscapeMapping=0

tns.ora
ServerName =
  (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST=<HostName>)(PORT=<Port-No>)))
    (CONNECT_DATA=(SERVICE_NAME = <Service-Name>)))

AA host server is Linux RH 7.8

We are still reading that the driver included in the 9.1 version is

[ODBC Data Sources]
SQL Server Wire Protocol=DataDirect 8.0 SQL Server Wire Protocol
Oracle Wire Protocol=DataDirect 8.0 Oracle Wire Protocol

 

Environment

Release : 9.1

Component : Strong Authentication

Risk Authentication

Cause

Progress Data Direct driver which is branded in Advanced Authentication does not support Oracle TAC feature.

Resolution

Progress Data Direct team is aware of this feature, but there are other Oracle specific features that the driver would also need to support in order for the driver to support it. This feature is not currently available in the Data Direct ODBC drivers and this is an enhancement request for them and will be done in future.

If customers want to use the product with Oracle 19C DB then TAC feature should be disabled at the moment.

Additional Information

https://datadirect.ideas.aha.io/ideas/DDIDEAS-I-569