Hyperion Planning Datasource Test Connection Fails With Error "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor".
Last updated on OCTOBER 04, 2016
Applies to:Hyperion Planning - Version 188.8.131.52.00 to 184.108.40.206.101 [Release 11.1]
Hyperion Planning - Version 220.127.116.11.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.
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