My Oracle Support Banner

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 APRIL 30, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.