Hi flocks,
I hosted asp.net application and wcf service(for data access from oracle 11g which is at remote.)
while my wcf service trying to connect oracle database I am getting
Description: ORA-12170: TNS:Connect timeout occurredException Details: Oracle Data Provider for .NET
Source File: at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
at CLS.FS.DataAccess.ProductGroupDAO.GetBusinessUnits()
exception.
I tried to connect though SqlPlus but the same error(ORA-12170: TNS:Connect timeout occurred).
I tried to ping the using host name i am getting in my hosting server(win2008R2)
approximate round trip times in milli-seconds: mininum=0,maximum=0,average=0
but i am getting some values in my local mechine(windows 7) which is working fine for getting data from oracle11g database.
Please need help to fix this issu..
Thanks in advance..