Error When Creating Import Profile in EPMA: "ORA-12505: TNS:listener does not currently know of SID given in connect descriptor"
Last updated on JULY 28, 2016
Applies to:Hyperion Planning - Version 220.127.116.11.00 and later
Information in this document applies to any platform.
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
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