Highlighted
alexisracr Respected Contributor.
Respected Contributor.
397 views

(OMi) Support Tip: OMi fails to connect encrypted Oracle DB with error ORA-12660

This is an encryption/driver configuration issue as seen from the error returned by Oracle:

[Oracle JDBC Driver]ORA-12660: Encryption or crypto-checksumming parameters incompatible.

Make sure that the encryption settings in Oracle Server match the ones in both <HPBSM>/conf/jdbc.drivers.properties and <HPBSM>/odb/conf/jdbc.properties files. E.g.:

Server side settings (sqlnet.ora 😞
NETWORK ENCRYPTION
SQLNET.ENCRYPTION_SERVER=REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER=(AES256,RC4_256)
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA1,MD5)
SQLNET.CRYPTO_CHECKSUM_SERVER=REQUIRED

The correlating settings between server and client are:
"SQLNET.ENCRYPTION_SERVER" matches client side "EncryptionLevel"
"SQLNET.ENCRYPTION_TYPES_SERVER" matches client side "EncryptionTypes"
"SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER" matches client side "DataIntegrityTypes"
"SQLNET.CRYPTO_CHECKSUM_SERVER" matches client side "DataIntegrityLevel". If "REQUIRED" on server side, then "accepted" should be used on client side

Client side settings for this example (<HPBSM>/conf/jdbc.drivers.properties and <HPBSM>/odb/conf/jdbc.properties files):
ddoracle.EncryptionLevel=required
ddoracle.EncryptionTypes=(AES256,RC4_256)
ddoracle.DataIntegrityTypes=(SHA1,MD5)
ddoracle.DataIntegrityLevel=accepted

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.