DBO_Usability collection failed with IO Error warning message
説明
An Oracle agent fires a DBO - Collection Status alarm with a message similar to the following
Oracle - Collection Status. DBO_Usability Failed with the exception: Failed to establish a Oracle JDBC connection protocol to Host [HOSTNAME-INSTANCE], user account [USERNAME] . Reason : [IO Error: Inbound closed before receiving peer's close_notify: possible truncation attack?- Profile:OracleProfile{host='HOSTNAME', service='INSTANCE', username='USERNAME', asSysDBA=false, ports='1856', useSSL=true, properties={oracle.jdbc.ReadTimeout=900000}} Query: "{call dbms_application_info.set_action(?)}"- Profile:OracleProfile{host='HOSTNAME', service='INSTANCE', username='USERNAME', asSysDBA=false, ports='1856', useSSL=true, properties={oracle.jdbc.ReadTimeout=900000}}]. . [Oracle Error Code = 17002. SQL state : 08006]
原因
CAUSE 1
Sqlnet.ora does not point to the server-side wallet.
CAUSE 2
The MD5 signing algorithm is used for the certificate. Certificates using the MD5 signing algorithm are not supported anymore.
CAUSE 3
Incorrect password
対策
RESOLUTION 1
Check the database sqlnet.ora to make sure it points to the server-side wallet.
RESOLUTION 2
The issue would be by recreating a new certificate and using the SHA512 or SHA256 algorithm to sign the certificate (as per Oracle Metalink Oracle Doc ID 2586530.1)
Oracle Metalink Doc ID 2454519.1 explains how to check and replace certificates.
