tnsping error

Hi,

Windows server 2008 Standard

Oracle DB 11.2.0.3, Oracle Gateway 11.2.0.3

Oracle 11.2.0.3 DB is installed in ORACLE_HOME - C:\Oracle11.2.0.3\product\11.2.0\dbhome_1

Oracle 11.2.0.3 Gateway installed in ORACLE_HOME - C:\Oracle11.2.0.3_Gtw

For setting up DG4ODBC,

1. configured system DSN

2. Oracle Gateway Listener;

# listener.ora Network Configuration File: C:\Oracle11.2.0.3_Gtw\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER_GTW =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = xxxxx)(PORT = 1521))

    )

  )

ADR_BASE_LISTENER = C:\Oracle11.2.0.3_Gtw

SID_LIST_LISTENER_GTW =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = dg4odbc)

      (ORACLE_HOME = C:\Oracle11.2.0.3_Gtw)

      (PROGRAM = dg4odbc)

    )

  )

Listener reloaded;

3. Oracle tnsnames.ora in Oracle DB Home.