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 laterInformation 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.
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.
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 |