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.

Symptoms

Navigation to Top Activity link of 11.2 Cluster database from 11.1.0.1 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(ConnectionFactory.java:263)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorTarget.getConnection(DbMetricCollectorTarget.java:404)
at oracle.sysman.emo.perf.metric.rt.DbMetricCollectorThread.getConnection(DbMetricCollectorThread.java:159)
at oracle.sysman.emo.perf.metric.rt.DbAshRollupMetric._getData(DbAshRollupMetric.java:184)
at oracle.sysman.emo.perf.metric.rt.DbAshRollupMetric.getData(DbAshRollupMetric.java:138)
at oracle.sysman.emo.perf.metric.eng.MetricCached.collectCachedData(MetricCached.java:417)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread._collectCachedData(MetricCollectorThread.java:610)
at oracle.sysman.emo.perf.metric.eng.MetricCollectorThread.run(MetricCollectorThread.java:329)
at java.lang.Thread.run(Thread.java:619)


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

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.