Error When Creating Import Profile in EPMA: "ORA-12505: TNS:listener does not currently know of SID given in connect descriptor" (Doc ID 1297127.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Planning - Version 11.1.2.0.00 and later
Information in this document applies to any platform.
8.3.15

Symptoms

When attempting to define an Import Profile, in Enterprise Performance Management Architect (EPMA), to load metadata from Interface Tables, the following error occurs when trying to save the profile:

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
Error Code: com.hyperion.awb.web.commin.DimensionServiceException

Also, when trying to edit the Interface Table Datasource in the EPM Configurator, the following error is reported:

EPMCFG-10713: Cannot connect to the database. Check the connection information and try again

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