Hello.
I'm trying to connect to IBM DB2 (as400), from Oracle 11g.
I've installed and tested the driver for DB2 (i tried in excel and it works great).
I have set my odbc 64 bits in windows 7 named "db2".
in my HS file I have:
HS_FDS_CONNECT_INFO = DB2
HS_FDS_TRACE_LEVEL = OFF
(file name is: initDB2.ora)
LISTENER.ORA has:
SID_LIST_LISTENER =
(SID_:LIST =
(SID_DESC =
(SID_NAME = PLSEXTPROC)
(ORACLE_HOME = C:\APP\SOPORTEIT\PRODUCT\11.1.0\DB_1)
(PROGRAM = EXTPROC)
)
(SID_DESC =
(SID_NAME = DB2)
(ORACLE_HOME = C:\APP\SOPORTEIT\PRODUCT\11.1.0\DB_1)
(PROGRAM = DG4ODBC)
)
(I'm mentioning only the sid_list_listener section in listener.ora).
TNSNAMES.ORA has:
DB2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = PROTOCOL = TCP) (HOST=10.11.35.170)(PORT=1521))
)
(CONNECT_DATA=
(SID=DB2)
)
(HS = OK)
)
My question is... why even when I've restarted my listener in windows services or in cmd prompt, and when i type lsnrctl status it says:
it has 1 instance and 1 handler and UNKNOWS status.
why cant I tnsping DB2? it keeps saying "no listener" i can ping the host, i can connect to that DB2 using excell as "data sources".
How can I troubleshoot that please?
Thanks a lot in advance.