Top Activity Page Fails With Error "Java.Sql.Sqlexception: Unknown Host Specified" In Grid Control 11.1

(Doc ID 1183783.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager Base Platform - Version: 11.1.0.1 and later   [Release: 11.1 and later ]
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms