Sqlplus 19c Client giving ORA-12696:Double Encryption Error.
1) Oracle 19c sqlplus client (customer remote location) connects to Oracle
DB via a SQL Proxy server.
2) 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
