My Oracle Support Banner

EM 13c: Agent Fails to Connect to Database with TCPS, Response Metric Fails with Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection,UNKNOWN,UNKNOWN,UNKNOWN (Doc ID 2863392.1)

Last updated on SEPTEMBER 28, 2023

Applies to:

Enterprise Manager Base Platform - Version 13.4.0.0.0 and later
Information in this document applies to any platform.

Symptoms

From EM 13c console, discovered a database target configured with TCPS and implemented all the steps as per the following document:

Doc ID 2407497.1 - Configure Secured Communication (TCPS) Access to Target Database from EM

Test Connection to the target database works fine from OMS but target database status shows as DOWN in Console.

$AGENT_INST_HOME/sysman/log/gcagent.log reports following errors:

2022-04-14 08:32:54,570 [1208:2F3E29CE] DEBUG - Execution error:
oracle.sysman.emSDK.agent.fetchlet.exception.FetchletException: Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.sysman.gcagent.addon.fetchlet.sqlfetchlet.SqlFetchlet.getMetric(SqlFetchlet.java:989)
at oracle.sysman.gcagent.target.interaction.execution.FetchletFactory.getMetric(FetchletFactory.java:437)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.executeQueryDescriptor(ExecuteTask.java:1222)
at oracle.sysman.gcagent.target.interaction.execution.ExecuteTask.runTask(ExecuteTask.java:3097)

Caused by: oracle.net.ns.NetException: Unable to initialize ssl context.

Caused by: oracle.net.ns.NetException: Unable to initialize the key store.

Caused by: oracle.security.crypto.asn1.ASN1FormatException: oracle.security.crypto.core.CipherException: Invalid padding string (or incorrect password)
at oracle.security.crypto.cert.PKCS12Safe.input(PKCS12Safe.java:222)
at oracle.security.crypto.cert.PKCS12Safe.(PKCS12Safe.java:129)
at oracle.security.crypto.cert.PKCS12.input(PKCS12.java:179)
at oracle.security.crypto.cert.PKCS12.(PKCS12.java:122)
at oracle.security.pki.OracleKeyStoreSpi.load(Unknown Source)
at oracle.security.pki.OracleKeyStoreSpi.engineLoad(Unknown Source)
at java.security.KeyStore.load(KeyStore.java:1445)

$emctl getmetric agent <DBName>,oracle_database,Response

Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
Status,State,oraerr,Archiver,DatabaseStatus,ActiveState
0,UNKNOWN,Failed to connect: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection,UNKNOWN,UNKNOWN,UNKNOWN

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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