EM 12c: Cluster Database Home Page in Enterprise Manager 12c Cloud Control Fails to Display Real-time Data, Showing ORA-12514 Error and this Message: Exception while loading RAC Database Home Page (Doc ID 2099609.1)

Last updated on DECEMBER 21, 2016

Applies to:

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

Symptoms

The cluster database home page in the 12c Cloud console UI does not display real-time data and the following message is reported:

 'Regions that display real-time data will not be displayed. Exception while loading RAC Database Home Page: Listener refused the connection with the following error: ORA-12514,
 TNS:listener does not currently know of service requested in connect descriptor The Connect Descriptor was (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = uatdb-scan)(PORT = 1521))
(CONNECT_DATA = (SERVICE_NAME = INT)))'

 The cluster database has been discovered using the Listener port - 1523 and is not configured to use SCAN listener. But the above error implies that the OMS is attempting to use the SCAN listener port - 1521.

 

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