Why... Why... Why?
This blog is dedicated to documenting error resolution and other tidbits that I discover while working as a Consultant in the Oracle EPM (Hyperion) field. As much of my job revolves around issue resolution, I see an opportunity to supplement the typical troubleshooting avenues such as the Oracle Knowledgebase and Oracle Forums with more pinpointed information about specific errors as they are encountered. Beware, the information found in this blog is for informational purposes only and comes without any warranty or guarantee of accuracy.

EPMVirt: Create your own Oracle Hyperion Virtual Environment:

Saturday, December 31, 2011

Configuring EPMA - the Service Name or SID must match with SERVICE_NAME

Problem Description
I am getting bellow error while configuring Financial Management on epma

EPMCFG-10390: For successful completion of this task, the Service Name or SID must match with SERVICE_NAME in tnsnames.ora file.

I have made sure tnsnames.ora (from C:\app\Administrator\product\11.2.0\client_1\network\admin) has the same sid as i have given on configurator screen.

I discovered that in my case the configurator was having trouble creating the .udl file for HFM. So I went in and manually created the .udl file and then the configuration tool, while still showing that warning, did complete successfully.

In user_projects\epmsystem1\products\FinancialManagement\Server Working Folder

Create a new file, ORACLE_hfm.udl

Enter the credentials to the Oracle ODE connection, click allow save password, and click test to ensure it works.

After this the config tool should be able to complete the remaining configuration tasks.

No comments:

Post a Comment