Troubleshooting Tip: Oracle Database connection ORA-12269 error

Description

This article provides workaround to resolve ORA-12269 error when connecting to Oracle Database.

Scope

FortiSIEM.

Solution

When connecting to an Oracle Database with high encryption, FortiSIEM may encounter error ORA-12269. Based on Oracle documentation, this error indicates the client is using weak encryption not accepted by the Oracle Database server. As a workaround, the following configuration can be performed on the Oracle database:

vi /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/sqlnet.ora

*** Add lines below***

SQLNET.ALLOW_WEAK_CRYPTO_CLIENTS = TRUE

If an Oracle user's environment needs to have high encryption, contact support to check JDBC driver compatibility with the FortiSIEM version in use. Attach the ojbc*.jar version of the Oracle Database to the ticket.

Notes:

Oracle driver version compatibility can be verified from the Oracle downloads page.