Analytics Software

Hi All,

I was configuring EPM 11.1.2.1 on Windows 2003 32 bit instance with Oracle 11.2.0.1+ as DB

Products covered were :
1. Foundation Services
2. FDM
3. Reperting and Analysis
4. Financial Reporting
5. Web Analysis
6. HFM
7. Disclosure Management


I have created separate SID's and grouped them as

Foundation Services + Workspace = hypss
FDM + DM + Calc Mger = hypepm
RA + FR + DM = hyprna
HFM = hyphfm

I also configured them in above order only. However when I was configuring HFM I was given warning as - *"EPMCFG-10398: For successful completion of this task, the Oracle Database tnsnames.ora file must exist"*

Subsequently my following HFM configurations were failed

1. Configure Database
2. Register Application Servers/Clusters

My tnsnames.ora file is as follows

*
# tnsnames.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

HYPSS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = payous12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hypss)
)
)

HYPHFM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = payous12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hyphfm)
)
)

HYPRNA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = payous12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hyprna)
)
)

HYPEPM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = payous12)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hypepm)
)
)

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
*
I changed the entry localhost to payous12 (my machin name) in tnsnames.ora. That was the only change I carried out in that file

Further I have not yet installed ethernet drivers on my machine and there is no IP address as well

All other configurations were successful. Can anyone guide for successful configuration of HFM

Thanks
Payous