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.
