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 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
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
Symptoms |
Changes |
Cause |
Solution |
References |