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

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

book

Article ID: 247510

calendar_today

Updated On:

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 [arcotdsn]. user [S0ECDBA] 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.]
Wed Jun 15 18:06:51.364 2022 INFO:    pid 19604 tid 19604: 2: 0: ArDBPool::createNewConnections: Pool [(primary)] is grown by [0] connections. Current total size is [0]. Current available size is [0]
Wed Jun 15 18:06:51.364 2022 INFO:    pid 19604 tid 19604: 2: 0: ArDBPoolManagerImpl::init: Backup database parameters are not available
Wed Jun 15 18:06:51.364 2022 FATAL:   pid 19604 tid 19604: 2: 0: StartupWithAnyPool is ON, but none of the pools are active.
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: ArDBPoolManagerImpl::clean: Destroying primary pool
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: ArDBPool::clean Pool [(primary)]: entering with [0x1877430]
Wed Jun 15 18:06:51.364 2022 INFO:    pid 19604 tid 19604: 2: 0: ArDBPool::clean Pool [(primary)]: All connection are released by threads. Cleaning the connections...
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: ArDBPool::clearDBConnections entering with this [0x1877430]
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: ArDBPool::clearDBConnections exiting with this [0x1877430]
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: ArDBPool::clean Pool [(primary)]: exiting with [0x1877430]
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: ArDBPoolManagerImpl::clean: Destroying backup pool
Wed Jun 15 18:06:51.364 2022 INFO:    pid 19604 tid 19604: 2: 0: ArDBPoolManagerImpl::clean: Both primary and backup pools destroyed successfully
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: Entering ArcotListenerService::handleDBFailure
Wed Jun 15 18:06:51.364 2022 WARNING: pid 19604 tid 19604: 2: 0: Database Init: Unknown error [2]
Wed Jun 15 18:06:51.364 2022 LOW:     pid 19604 tid 19604: 2: 0: Exiting ArcotListenerService::handleDBFailure
Wed Jun 15 18:06:51.364 2022 INFO:    pid 19604 tid 19604: 2: 0: Exiting the function                                                                                                                                                           ArcotListenerService::initTempDBPoolManager()
Wed Jun 15 18:06:51.364 2022 FATAL:   pid 19604 tid 19604: 2: 0: [214]: Failed Temporary DBPoolManager initialization
Wed Jun 15 18:06:51.364 2022 FATAL:   pid 19604 tid 19604: 2: 0: Cannot continue due to setConfigData failure, SHUTTING DOWN
Wed Jun 15 18:06:51.364 2022 INFO:    pid 19604 tid 19604: 3: 0: CA Risk Authentication Service is STOPPED!

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=1521)))(CONNECT_DATA=(SERVICE_NAME=<service-name>)(SERVER=DEDICATED)))
Username.1=DBA

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
#PortNumber=1521
TNSNamesFile=/apps/CA/AdvAuth/odbc64/tns.ora
ServerName=Servername
TimestampEscapeMapping=0

tns.ora
ServerName =
  (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST=<HostName>)(PORT=1521)))
    (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