Database Administration (MOSC)

MOSC Banner

TNS-12599 or TNS-12534 after setting advanced security in sqlnet.ora

Frequently seeing TNS-12599 or TNS-12534 after enabling encryption in sqlnet.ora in DB 19.8 version.

=========================

Fatal NI connect error 12534, connecting to:

 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

and

TNS-12599: TNS:cryptographic checksum mismatch

=========================

Below was added to sqlnet.ora

#SQLNET.ENCRYPTION_CLIENT = REQUIRED

#SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED

#SQLNET.ENCRYPTION_TYPES_CLIENT= (AES256, AES192, AES128)

#SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT= (SHA256, SHA384, SHA512, SHA1)

#SQLNET.ENCRYPTION_SERVER = REQUIRED

#SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED

#SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= (SHA512, SHA384, SHA256, SHA1)

#SQLNET.ENCRYPTION_TYPES_SERVER= (AES256, AES192, AES128)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center