Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FDM cannot connect to oracle database

934706Jul 6 2012 — edited Feb 25 2013

HI,

I'm trying to connect to Oracle database using FDQM - just for the sake of testing.
I using the weblogon option. and using Shared Services Admin id to create application. The application gets created in the sharedfolder area but it gives me an error for connection to database

"Error: Unable to connect to database. Please check database information and verify database is accessible."

I have created a user in oracle say XYZ and granted the following permissions to it.
RESOURCE,CONNECT,CREATE SESSION,CREATE VIEW, CREATE DATABASE LINK.

I have installed 32 bit oracle client.

I can connect to the database using sqlplus XYZ/password@hostname:1251/SERVICE_NAME on command line.

What could I be missing ?

Please assit.

Thanks in advance!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 25 2013

Added on Jul 6 2012

#business-intelligence-applications, #financial-data-management, #performance-management-applications

3 comments

1,938 views