My Oracle Support Banner

Top Activity Page Fails With Error "Java.Sql.Sqlexception: Unknown Host Specified" In Grid Control 11.1 (Doc ID 1183783.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 12cBETA2 to 12cBETA2 [Release 12.1]
Information in this document applies to any platform.


Navigation to Top Activity link of 11.2 Cluster database from Grid control errors out with error :
(Targets -> Databases -> Click on Cluster database -> Performance -> Top activity)

java.sql.SQLException: Unknown host specified

From emoms.trc

2010-07-23 23:54:21,496 [MetricCollector:SITEMAP_THREAD150:15] ERROR perf.sitemap logp.251 - java.sql.SQLException: Unknown host specified
The Connect Descriptor was <XYZ>
java.sql.SQLException: Unknown host specified
The Connect Descriptor was <XYZ>
at oracle.sysman.util.jdbc.ConnectionFactory.createConnection(
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget.getConnection(
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.getConnection(
at oracle.sysman.emo.perf.metric.rt.DbAshRollupMetric._getData(
at oracle.sysman.emo.perf.metric.rt.DbAshRollupMetric.getData(
at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData(
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(

Another surfacing error for this issue is that the Grid Control OMS will fail to conenct to the RAC database with:

ORA-12514, TNS:listener does not currently know of service requested in connect descriptor


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

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