My Oracle Support Banner

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 JUNE 09, 2024

Applies to:

Hyperion Planning - Version to [Release 11.1]
Hyperion Planning - Version 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 .



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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.