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 MARCH 04, 2018
Applies to:Hyperion Planning - Version 126.96.36.199.00 to 188.8.131.52.101 [Release 11.1]
Hyperion Planning - Version 184.108.40.206.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 .
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!