When running a Policy Server, this one can't connect to the ODBC
Oracle 12c Session Store and report the error :
[19597/139941391099680][Fri Mar 12 2021 14:23:22][SmSSProvider.cpp:259]
[ERROR][sm-Server-07001] Exception: Unexpected local error code -1063 while making database call.
Error code -1063
[19597/139940292347648][Fri Mar 12 2021 14:23:22][CSmDbUtilities.cpp:465]
[ERROR][sm-Odbc-00060] Failed to connect to datasource 'Session Data Source'.
Policy Server system_odbc.ini is configured with :
as per Driver instructions (1)(2)(3)(4).
Policy Server 12.8SP2 on RedHat 6;
Session Store on Oracle 12c;
12.8SP2 Policy Server has Datadirect driver 08.01 :
/opt/CA/siteminder/odbc/lib : strings NSora28.so | grep 8.0
08.01.0081 (B0125, U0091)
and from 12.8SP3, the driver is on 08.02. According Datadirect release
note, the encryption is supported only from 08.02 driver version (5).
Upgrade Policy Server to 12.8SP3 and above to solve the issue.
Data Integrity Level
Data Integrity Types
The Oracle driver has been enhanced to support the following new data
integrity algorithms for Oracle 12c and higher: SHA256, SHA384,
SHA512. To use these algorithms, specify their values using the Data
Integrity Types connection option and enable data integrity checks
with the Data Integrity Level connection option.