Trying to Install and configure EPM 11.1.2.2 with Oracle Database in Distributed Environment.
HFM configure database failed.
Instead of default port 1521, we are using a non default port(1525). Shared Service, FDM and FR were successfully configured to 1525.
For HFM Configuration it fails and throws the error
When i do a tnsping to oracle database it goes to 1521 instead of 1525
[2016-07-02T16:55:31.918+08:00] [EPMCFG] [WARNING] [EPMCFG-02084] [oracle.EPMCFG] [tid: 21] [ecid: 0000LMeoTfe5Ucw70Ffd6F1NTs4t000005,0] [SRC_CLASS: com.hyperion.hfm.config.hfmregistry.HFMRegistry] Error while configuring HFM Database: {0}[[
java.lang.RuntimeException: Oracle DB registry entry is not available
at com.hyperion.hfm.config.hfmregistry.HFMRegistry.configureHFMDataBase(HFMRegistry.java:754)
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)
]]
[2016-07-02T16:55:31.918+08:00] [EPMCFG] [ERROR] [EPMCFG-05020] [oracle.EPMCFG] [tid: 21] [ecid: 0000LMeoTfe5Ucw70Ffd6F1NTs4t000005,0] [SRC_CLASS: com.hyperion.hfm.config.HfmDbConfigurator] Error: Error while configuring HFM DatabaseOracle DB registry entry is not available
[2016-07-02T16:55:31.918+08:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 21] [ecid: 0000LMeoTfe5Ucw70Ffd6F1NTs4t000005,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RunAllTasks] Error: [[
com.hyperion.cis.config.ProcessingException
at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:168)
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)
[2016-07-02T17:21:45.032+08:00] [EPMCFG] [ERROR] [EPMCFG-05020] [oracle.EPMCFG] [tid: 20] [ecid: 0000LMeuTip5Ucw70Ffd6F1NTsTp000004,0] [SRC_CLASS: com.hyperion.hfm.config.HfmDbConfigurator] Error: Error while configuring HFM DatabaseOracle DB registry entry is not available
[2016-07-02T17:21:45.032+08:00] [EPMCFG] [ERROR] [EPMCFG-01020] [oracle.EPMCFG] [tid: 20] [ecid: 0000LMeuTip5Ucw70Ffd6F1NTsTp000004,0] [SRC_CLASS: com.hyperion.config.wizard.impl.RunAllTasks] Error: [[
com.hyperion.cis.config.ProcessingException
at com.hyperion.hfm.config.HfmDbConfigurator.configure(HfmDbConfigurator.java:168)
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)
Tried Solutions
1. Changes in Path Environment Variable D:\app\product\11.2.0\dbhome_1\bin changed to D:\app\product\11.2.0\dbhome_1\BIN (I cant rename BIN folder from upper case to lower case so changed in path )
2.Registry key*
Change the HKEY_CLASSES_ROOT\CLSID\{3F63C36E-51A3-11D2-BB7D-00C04FA30080}\InprocServer32 value data to use uppercase “BIN” folder in the
path; e.g., D:\Oracle\app\product\11.2.0\client_1\BIN\OraOLEDB11.dll.
3. Dropped HFM User and created HFM User (granted DBA privileges also)
How do i go ahead to configure to non default port(1525) ?
Should UDL testing done through database server or prod server to database server?
Any help would be highly appreciable