Hi Experts,
I have installed EPMA on my system [ windows server 2008 64 bit ] and all services are running but getting data process error when trying to open HFM APP,
In xfm.odl.HFMAPP-1 logs I see 'TNS-12518: TNS:listener could not hand off client connection
any suggestion ?
[2017-09-02T03:48:47.344414+08:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XFMDataSource.cpp] [Line: 462] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.000.4847] [[XDS: XFMDataSource process starting...]]
[2017-09-02T03:50:20.205725+08:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CHsvDataSourceImpl.cpp] [Line: 442] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.000.4847] [[Hsv: Initializing HsvDSSQL]]
[2017-09-02T03:50:21.801816+08:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CHsvDataSourceImpl.cpp] [Line: 486] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.000.4847] [[Hsv: Initializing XfmDSSQL]]
[2017-09-02T03:50:38.574776+08:00] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 189] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.000.4847] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 08001; NATIVE ERROR = -1; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12518: TNS:listener could not hand off client connection]]
[2017-09-02T03:50:38.744785+08:00] [XFM] [ERROR:1] [EPMHFM-07407] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 532] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402C4] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.000.4847] [[]]
[2017-09-02T03:50:38.757786+08:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 617] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.000.4847] An error occurred in creating an ODBC connection. [[]]
[2017-09-02T03:50:38.823790+08:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CSQLConnectionPool.cpp] [Line: 142] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.000.4847] An error occurred in creating an ODBC connection. [[]]
----------------------------------------------listener.ora -----------
# listener.ora Network Configuration File: C:\app\ankit\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID\_DESC =
(SID\_NAME = CLRExtProc)
(ORACLE\_HOME = C:\\app\\ankit\\product\\11.2.0\\dbhome\_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC\_DLLS=ONLY:C:\\app\\ankit\\product\\11.2.0\\dbhome\_1\\bin\\oraclr11.dll")
)
(SID\_DESC =
(GLOBAL\_DBNAME = Oracle8)
(SID\_NAME = ORCL)
)
(SID\_DESC =
(SID\_NAME = CLRExtProc)
(ORACLE\_HOME = C:\\app\\ankit\\product\\11.2.0\\dbhome\_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC\_DLLS=ONLY:C:\\app\\ankit\\product\\11.2.0\\dbhome\_1\\bin\\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hysetup)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
ADR_BASE_LISTENER = C:\app\ankit
DIRECT_HANDOFF_TTC_LISTENER=OFF
----------------------------tnsnames.ora--------------------------------------------------------------------------------------------------------------------------
# tnsnames.ora Network Configuration File: C:\app\ankit\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT\_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = HYSETUP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.200.133)(PORT = 1521))
)
(CONNECT\_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
HFMTNS =
(DESCRIPTION =
(ADDRESS\_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = HYSETUP)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.200.133)(PORT = 1521))
)
(CONNECT\_DATA =
(SID = orcl)
(SERVER = DEDICATED)
)
)
