Unable to connect to database. Please check database information and verify database is accessible - in Hyperion FDM 11.1.2.3

Unable to connect to database. Please check database information and verify database is accessible - in Hyperion FDM 11.1.2.3

To resolve the above isssue, we need to follow some steps when we use Oracle as RDBMS.

1. Create user with the following Roles and Privileges

Roles: DBA, Resource, Connect

Privileges: CREATE ANY SYNONYM,CREATE CLUSTER,CREATE INDEXTYPE,CREATE PROCEDURE,CREATE SEQUENCE,CREATE SESSION,CREATE TABLE,CREATE TRIGGER,CREATE TYPE,CREATE VIEW,DROP ANY SYNONYM

2. Copy the tnsnames.ora file info from 

C:\app\hypadmin\product\11.2.0\dbhome_1\NETWORK\ADMIN (tnsnames.ora)
to
C:\Oracle\Middleware\user_projects\config\dbclient (tnsnames.ora)

C:\Oracle\Middleware\user_projects\config\dbclient:

 C:\app\hypadmin\product\11.2.0\dbhome_1\NETWORK\ADMIN:

Now try to Create a FDM application again

3. Upto 11.1.2.2 version, we need to install Oracle Client 32 bit first, then 64 bit Client(full clients) for Oracle Database(RDBMS).But for 11.1.2.3 version no need to install clients separately, hyperion will install clients automatically.

Thanks,

Mady