ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to enable encryption for ODBC connections to Oracle databases?


Article ID: 16934


Updated On:


CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On


In order to configure our Oracle database for connectivity, our DBAs are asking us to enable the following settings to enable encryption when connecting to the database:

How we can configure the settings above in our Linux and Windows Policy Servers? 


Policy Server R12.52 SP1 CR05


For Linux Policy Servers, the following parameters should be added in the system_odbc.ini file:

The level value 3 means the encryption and/or the data integrity check are required, and the types parameters specify which algorithms are allowed.

For Windows Policy Servers, you need to open the ODBC Data Source administrator (x32) and modify the settings for your Oracle connection using the Oracle Wire protocol driver clicking on "Configure", and going to the Advanced Security tab, where you can specify the same values as above:

Encryption Level: 3 - Required
Encryption Types: (select the types allowed by enabling the corresponding checkboxes; in this case you only need: AES256)
Data Integrity Level: 3 - Required
Data Integrity Types: (select the types allowed by enabling the corresponding checkboxes; in this case you only need: SHA1)

Note that you can use the "Test Connect" button to ensure the connection is done properly after changing the settings. After the changes are set, click the Ok button twice to save the changes.


Additional Information

You can find more information on these parameters at the following locations: