Bind package GTW$_BIND_PKG failure in Transparent Gateway
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Bind package GTW$_BIND_PKG failure in Transparent Gateway

  1. #1
    Join Date
    Sep 2005
    Location
    Hyderabad
    Posts
    12

    Bind package GTW$_BIND_PKG failure in Transparent Gateway

    Hi,

    I'm having Oracle 9i Rel.2 on Windows-2000.
    Oracle 9i Transparent Gateway for IBM DRDA rel 2 on Windows -2003.
    IBM DB2 8.1 on Windows -2003.

    I have confgured the Initialization file for TG4DRDA and created a database link in Integrating server. while binding the gateway package i'm getting the following error.

    SQL> execute gtw$_bind_pkg@drda;
    BEGIN gtw$_bind_pkg@drda; END;

    *
    ERROR at line 1:
    ORA-04052: error occurred when looking up remote object
    Administrator.GTW$_BIND_PKG@DRDA.US.ORACLE.COM
    ORA-00604: error occurred at recursive SQL level 1
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    TG4DRDA v9.2.0.1.0 grc=0, drc=-30020 (839C,0000), errp=GDJMRCKD
    errmc=124c
    ORA-02063: preceding 3 lines from DRDA

    I Struck up with these error past 15 days onwards.
    Can anybody help me out to overcome this issue.

    Thanks & Regards,
    Murali.

  2. #2
    Join Date
    Nov 2001
    Posts
    335
    I have very simular problem on AIX with 10G version of DRDA .
    Can you list you listener.ora entry. Check that user administrator exists in DB2 and all required grants
    One, who thinks that the other one who thinks that know and does not know, does not know either!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width