Hyperion Planning Datasource Test Connection Fails With Error "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor". (Doc ID 1445002.1)

Last updated on OCTOBER 04, 2016

Applies to:

Hyperion Planning - Version 11.1.1.3.00 to 11.1.2.1.101 [Release 11.1]
Hyperion Planning - Version 11.1.2.1.000 and later
Information in this document applies to any platform.
Oracle Database Setup which has two database servers setup as RAC ,
On SCAN LISTENER technology .

*5.26.15**

Symptoms

When attempting to update the data-source for the existing planning application for RAC database the following error occurs:

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

Changes

Database server setup was changed to Oracle 11g R2 RAC which has multiple servers setup and configured to use ON SCAN LISTENER technology. The earlier Database server was simple single server setup and all existing data-sources were configured using  this database server.

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