Oracle 11G on Linux - DB2 Gateway problem
Posted on 2011-10-31
I'm trying to setup a gateway between Oracle 11G on Linux and DB2 on Mainframe.
I have setup an Oracle 11G version 220.127.116.11 under oracle user and Oracle DRDA Gatway on another user account (oragate)
Doing TNSPING on both the database SID and the gateway SID seems ok as they respond.
The problem I'm facing is that when I (logged in as SYSTEM user) create a database LINK on a fixed DB2 user I get ORA-28513 and ORA-02063 when testing the link.
I have setup a DB2 Connect and I am able to connect to the DB2 easily using the db2 connect command line. Also the initSID.ora file is correctly pointing to the DB2 host and configured properly.