Sqlplus client error : ORA-12696:Double Encryption Error.

From: Bala <oratips_at_gmail.com>
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.
  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

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 04 2021 - 21:03:26 CET

Original text of this message