Database Response metric failed with error "Failed to connect: java.sql.SQLRecoverableException: IO Error: Unknown Authentication\, Encryption or Data Integrity algorithm,UNKNOWN,UNKNOWN,UNKNOWN" (Doc ID 2677441.1)

Last updated on JUNE 14, 2023

Applies to:

Symptoms

Enabled 'Advance Security features' for database in sqlnet.ora as below.

DB and agent side sqlnet.ora:
SQLNET.ENCRYPTION_SERVER = REQUIRED
SQLNET.ENCRYPTION_TYPES_SERVER = (AES256,RC4_256)
SQLNET.CRYPTO_CHECKSUM_SERVER = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER = (SHA256,SHA1)

OMS Side Settings:

oracle.sysman.core.conn.enableEncryption=true
oracle.net.encryption_client=REQUESTED
oracle.sysman.core.conn.encryption_types_client=AES256
oracle.net.crypto_checksum_client=REQUESTED
oracle.sysman.core.conn.crypto_checksum_types_client=SHA256

GetMetric command results as below error :

<AGENT_HOME>/bin/emctl getmetric agent <DATABASE_NAME>,oracle_database,Response
Oracle Enterprise Manager Cloud Control 13c Release 2
Copyright (c) 1996, 2016 Oracle Corporation. All rights reserved.
Status,State,oraerr,Archiver,DatabaseStatus,ActiveState
0,UNKNOWN,Failed to connect: java.sql.SQLRecoverableException: IO Error: Unknown Authentication\, Encryption or Data Integrity algorithm,UNKNOWN,UNKNOWN,UNKNOWN

Following errors are reported in AGENT_INST_HOME/sysman/log/gcagent.log

2020-06-02 09:44:09,614 [198370:43552255] DEBUG - Protocol for SQL Connection: TCP
2020-06-02 09:44:09,614 [198370:43552255] DEBUG - SqlConnection: connectWithTCPS: oracle.sysman.emSDK.agent.config.ConfigProperty@7afd6ec7
2020-06-02 09:44:09,614 [198370:43552255] DEBUG - SqlConnection: connectionTrustStoreLocation: null
2020-06-02 09:44:09,614 [198370:43552255] DEBUG - SqlConnection: connectionTrustStoreType: null
2020-06-02 09:44:09,614 [198370:43552255] DEBUG - SqlConnection: connectionKeyStoreLocation: null
2020-06-02 09:44:09,614 [198370:43552255] DEBUG - SqlConnection: connectionKeyStoreType: null
2020-06-02 09:44:10,416 [198371:FEE068F6:FetchletExecutor(Sql)oracle_database.VPGAFIN] DEBUG - Protocol for SQL Connection: TCP
2020-06-02 09:44:10,416 [198371:FEE068F6] DEBUG - SqlConnection: connectWithTCPS: oracle.sysman.emSDK.agent.config.ConfigProperty@7afd6ec7
2020-06-02 09:44:10,416 [198371:FEE068F6] DEBUG - SqlConnection: connectionTrustStoreLocation: null
2020-06-02 09:44:10,416 [198371:FEE068F6] DEBUG - SqlConnection: connectionTrustStoreType: null
2020-06-02 09:44:10,416 [198371:FEE068F6] DEBUG - SqlConnection: connectionKeyStoreLocation: null
2020-06-02 09:44:10,416 [198371:FEE068F6] DEBUG - SqlConnection: connectionKeyStoreType: null
2020-06-02 09:44:10,420 [198370:ECA8DBF3:GC.OnDemand.67] DEBUG - End task Real-Time Metric Request;oracle_database.<DB_NAME>;Response
2020-06-02 09:44:10,420 [198367:E7884DA0] DEBUG - Response metric indicates that oracle_database.<DB_NAME> is up
2020-06-02 09:44:10,420 [198367:E7884DA0] DEBUG - Error during dynamic property decideIncludeDB calculation for oracle_database.<DB_NAME>$24
oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: Unknown Authentication, Encryption or Data Integrity algorithm

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.