Hyperion Financial Management (HFM) - Oracle Service Name in HFM DSN 11.1.2.4 Fails with ORA-12505 (Doc ID 2074112.1)

Last updated on JANUARY 20, 2017

Applies to:

Hyperion Financial Management - Version 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.2.4.000 version

When you use Oracle Service Name in the in HFM Consolidation Administration DSN entry the Connection Testing is failing with the below error message:

Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor

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