Configure Database Step For Financial Management Fails In EPM Configurator (Doc ID 1579620.1)

Last updated on AUGUST 01, 2016

Applies to:

Hyperion Financial Management - Version 11.1.2.0.00 to 11.1.2.3.000 [Release 11.1]
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

During configuration of Hyperion Financial Management (HFM) in EPM Configurator step "Configure Database" fails. The following information is recorded in Oracle_EPM_Instance_Home\diagnostics\logs\config\ConfigTool.log:

com.hyperion.hfm.config.hfmregistry.HFMRegistry] Error while configuring HFM Database: {0}[[
com.hyperion.hfm.config.hfmregistry.TNSParseException: Invalid TNSNAMES.ORA file construct
                at com.hyperion.hfm.config.hfmregistry.ParseTNSNamesFile.parseTNSNames(ParseTNSNamesFile.java:198)
                at com.hyperion.hfm.config.hfmregistry.HFMRegistry.configureHFMDataBase(HFMRegistry.java:759)
                at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:150)
                at com.hyperion.config.wizard.impl.RunAllTasks.executeDbConfigTask(RunAllTasks.java:929)
                at com.hyperion.config.wizard.impl.RunAllTasks.execute(RunAllTasks.java:482)
                at com.hyperion.config.wizard.impl.RunnAllTasksState.run(RunnAllTasksState.java:91)
                at java.lang.Thread.run(Thread.java:662)
Caused by: java.io.FileNotFoundException: C:\app\Administrator\product\11.2.0\client_1\network\admin\tnsnames.ora (The system cannot find the file specified)
                at java.io.FileInputStream.open(Native Method)
                at java.io.FileInputStream.(FileInputStream.java:120)
                at java.io.FileInputStream.(FileInputStream.java:79)
                at java.io.FileReader.(FileReader.java:41)

Cause

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