ORA-12505 When Logging In a Cluster (RAC) Database From Grid Control (Doc ID 1312904.1)

Last updated on FEBRUARY 15, 2014

Applies to:

Enterprise Manager Base Platform - Version 11.1.0.1 to 11.1.0.1 [Release 11.1]
Information in this document applies to any platform.
Checked for relevance on 15-Feb-2014

Symptoms

11.1.0.1 Grid Control monitoring a 11.2 Cluster database. When logging in to the database from Grid Control (for Performance or other Administration pages), this fails with:

Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

OMS logs are showing:

2011-04-08 14:01:57,127 [EMUI_14_01_56_/console/database/instance/sitemap] ERROR perf.sitemapPerfChart logp.251 - java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connect Descriptor was (description=(address=(host=scanhost.foo.com)(protocol=tcp)(port=1521))(connect_data=(service_name=orcl)(instance_name=orcl1)(UR=A)))
java.sql.SQLException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connect Descriptor was (description=(address=(host=scanhost.foo.com)(protocol=tcp)(port=1521))(connect_data=(service_name=orcl)(instance_name=orcl1)(UR=A)))
at oracle.sysman.util.jdbc.ConnectionFactory.createConnection(ConnectionFactory.java:263)

 

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