Unzip the RiskDBScripts.zip file. This file contains the script to extend the database and sample configuration files. The file is located at the following location:
/opt/novell/rba-core/lib/webapp/WEB-INF/RiskDBScripts.zip
On the Oracle server, run the following script to create database objects for risk-based authentication:
Oracle 21c, 19c, 18c, and 12c: netiq_risk_oracle_12c_style_install.sql
Earlier to Oracle 12c: netiq_risk_oracle_install.sql
Download the JDBC connector for the Oracle database from Oracle.com.
NOTE:Oracle 19.x supports two JDBC connectors, ojdbc8.jar and ojdbc10.jar. However, ojdbc10.jar is not supported with JDK 8. Hence you must use the ojdbc8.jar file while using Oracle Database 19.c.
Copy the JDBC connector jar to /opt/novell/rba-core/lib/webapp/WEB-INF/lib/.
Restart Identity Server.