ORA-12650: No common encryption or data integrity algorithm

ORA-12650: No common encryption or data integrity algorithm

Error

C:\Users\oracle>sqlplus hr@xepdb1
SQL*Plus: Release 12.1.0.2.0 Production on Thu May 21 12:57:45 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12650: No common encryption or data integrity algorithm

Cause
On Server and Client encryption define value is different.
SQLNET.log file

At Server SQLNET file:
sqlnet.encryption_server = required
sqlnet.encryption_types_server = (AES256)

At Client SQLNET file:
SQLNET.ENCRYPTION_CLIENT=required
SQLNET.ENCRYPTION_TYPES_CLIENT=(RC4_256)

Solution
Two ways to Fixed the issue,
1. Include the encryption of Client into Server list.
2. Change the Client encryption setting as Server defined value.

Case 1:
Added the encryption type RC4_256 in the list of Server SQLNET.ORA file.

At Server SQLNET file:
sqlnet.encryption_server = required
sqlnet.encryption_types_server = (AES256,RC4_256)

Case 2:
It should be same at both end, you can change the client file to use the Server type encryptions:

At Client SQLNET file:
SQLNET.ENCRYPTION_CLIENT=required
SQLNET.ENCRYPTION_TYPES_CLIENT=(AES256)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.