My Oracle Support Banner

Hyperion Shared Services External User Directory Configuration Returns Error: "ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" (Doc ID 1629671.1)

Last updated on JULY 22, 2022

Applies to:

Hyperion BI+ - Version and later
Information in this document applies to any platform.


Product: Foundation/Shared Services
Issue:    Unable to configure database authentication in Shared Services using Oracle RAC with the following error encountered


When configuring Hyperion Shared Services external user directory for database authentication the following message is displayed:

EPMCSS-05255: Failed to create/edit user directory configuration.Verify user directory status and configuration.


In the "SharedServices_Security.log" the followiing error message is seen:

[2014-02-19T14:23:01.922+08:00] [FoundationServices0] [TRACE] [EPMCSS-30827] [oracle.EPMCSS.CSS] [tid: 11] [userId: ] [ecid: <ecid>] [APP: SHAREDSERVICES#] [URI: /interop/framework/security/NextToDBAdvancedInfoAction] [SRC_CLASS: com.hyperion.css.spi.impl.db.util.DatabaseDescriptor] [SRC_METHOD: isConnectable] Exception while checking whether the database is reachable.[[
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

  at oracle.jdbc.driver.T4CConnection.logon(
  at oracle.jdbc.driver.PhysicalConnection.(
  at oracle.jdbc.driver.T4CConnection.(
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(
  at oracle.jdbc.driver.OracleDriver.connect(
  at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(
  at oracle.jdbc.pool.OracleDataSource.getConnection(


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.