Sqlplus client error : ORA-12696:Double Encryption Error.
Date: Thu, 4 Mar 2021 15:03:26 -0500
Message-ID: <CAF5SaXvC7SA__b8cjbL5BX5eCZFGPRxzBnZh11S6conuR6sNVg_at_mail.gmail.com>
Sqlplus 19c Client giving ORA-12696:Double Encryption Error.
- Oracle 19c sqlplus client (customer remote location) connects to Oracle DB via a SQL Proxy server.
- Target Database (19c) is configured for both ANO and TCPS
Sqlplus client connects to Proxy server (over TLS) which does port forwarding to Oracle Target Database and is giving error.
Error: ORA-12696: Double Encryption Turned On, login disallowed.
==
Any insight will be highly appreciated.
Thank you for your time gurus.
Sqlnet.ora setting on Target DB server
SQLNET.ORA
## Server
SQLNET.ENCRYPTION_SERVER = required SQLNET.ENCRYPTION_TYPES_SERVER = (AES256) SQLNET.CRYPTO_CHECKSUM_SERVER = required SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER=(SHA256)
## Client
SQLNET.ENCRYPTION_CLIENT = required SQLNET.ENCRYPTION_TYPES_CLIENT = (AES256) SQLNET.CRYPTO_CHECKSUM_CLIENT = required SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = (SHA256)
SQLNET.IGNORE_ANO_ENCRYPTION_FOR_TCPS=TRUE
SQLNET.AUTHENTICATION_SERVICES= (TCPS,BEQ)
SSL_VERSION = 1.2
SSL_CLIENT_AUTHENTICATION = TRUE
SQLNET.WALLET_OVERRIDE = TRUE
WALLET_LOCATION =
(SOURCE =
(METHOD = FILE)
(METHOD_DATA =
(DIRECTORY =/u01/app/oracle/admin/xxxdb/owm/wallet)
)
)
SSL_SERVER_CERT_DN=YES
SSL_CIPHER_SUITES = (SSL_RSA_WITH_AES_256_GCM_SHA384)
-- Bala Rao -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 04 2021 - 21:03:26 CET