My Oracle Support Banner

EM 13c: Failed To Connect To The PDB In Single Instances (Doc ID 2633276.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

1- In OEM 13c, the message is found.
Information "Failed to connect to the target database. Regions that pull real-time data from the database will not be displayed."

2. In the target database shared listener log, the following error is always generated when a connection is attempted to the PDB or when the metrics for the PDB runs in OEM.

27-JAN-2020 10:16:44 * (CONNECT_DATA=(CID=(PROGRAM=OMS)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=<SERVICE-NAME>)(SERVER=DEDICATED)) * (ADDRESS=(PROTOCOL=tcp)(HOST=<HOSTNAME>)(PORT=<Port>)) * establish * <SERVICE-NAME> * 12520
TNS-12520: TNS:listener could not find available handler for requested type of server

3. In the $../<gc_inst>/sysman/log/emoms.log has below errors.

2020-01-27 10:27:03,036 [MetricCollector:HOMETAB_THREAD600:60] ERROR rt.DbMetricCollectorTarget logp.251 - Caught Exception in DbMetricCollectorTarget.getMonitorringConnection() <SID_HOST>_CDBROOT oracle_pdb
java.sql.SQLException: Connection Cache with this Cache Name does not exist

2020-01-27 10:26:44,512 [MetricCollector:HOMETAB_THREAD600:60] ERROR rt.DbMetricCollectorTarget logp.251 - Caught Exception in DbMetricCollectorTarget.getMonitorringConnection() <TARGET_PDB> oracle_pdb
java.sql.SQLException: Connection Cache with this Cache Name does not exist

4. In the  $../<gc_inst>/sysman/log/emoms.trc  has below errors

2020-01-24 01:37:32,008 [RJob Step 660303] ERROR intg.AlertThresholdTargetUpdateNew logp.251 - AlertThresholdTargetUpdate: Exception occurred:
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12520, TNS:listener could not find available handler for requested type of server

The Connect Descriptor was (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = <HOST_NAME>)(PORT = 3002))(CONNECT_DATA = (SERVICE_NAME = <Service Name>)(SERVER = DEDICATED))) 

Changes

 

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
Changes
Cause
Solution


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