4 Replies Latest reply on Mar 11, 2013 8:52 AM by Mkirtley-Oracle

    Cannot connect Oracle 11gR2 to DB2 Database

    710441
      Hi guys,

      I gotta some issue connecting from Oracle to DB2. The point in, the connection works from Oracle 10G, but does not from 11G. Check it out:

      ********************************
      Oracle 10g:

      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL> conn test/test
      Connected.
      SQL>

      SQL> create database link db2
      2 connect to user10
      3 identified by user1000
      4 using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=167.82.63.98)(PORT=1528))(HS=))';

      Database link created.

      SQL> select count(*) FROM DES.LIST_DEV@DB2;

      COUNT(*)
      231


      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      Oracle 11g:

      Connected to:
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
      Data Mining and Real Application Testing options

      SQL> conn test/test
      Connected.
      SQL>

      SQL> create database link db2
      2 connect to user10
      3 identified by user1000
      4 using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=167.82.63.98)(PORT=1528))(HS=))';

      Database link created.

      SQL> select count(*) FROM DES.LIST_DEV@DB2;
      select count(*) FROM DES.LIST_DEV@DB2
      *
      ERROR at line 1:
      ORA-01017: invalid username/password; logon denied
      ORA-02063: preceding line from DB2
      SQL>

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++



      When connected through Oracle 10 (DBLINK working), DB2 access log shows this information:

      GT8C G4AUTH: (USER10 / ) TCB=(00AC5E88) JOB=(ORAGT8C )
      ICH70001I USER10 LAST ACCESS AT 11:01:14 ON FRIDAY, JULY 29, 2011
      DB2AUTH: AIDLPRIM=(E2C1C4E2C5E24040), AIDLSQL=(4040404040404040)
      DB2AUTH: USERID=(USER10 ), SUBSYS=(GT8C ), STC NAME=(ORAGT8C )
      DB2AUTH: SSAT=(7F5B1840), TCB=(00AC5E88)
      DB2AUTH: SECONDARY ID = (RJ00S )



      Through Oracle 11 (DBLINK not working), these are the logs:

      GT8C G4AUTH: ( / ) TCB=(00AC5628) JOB=(ORAGT8C )
      ICH408I USER( ) GROUP( ) NAME(??? ) 820
      LOGON/JOB INITIATION - USER AT TERMINAL NOT RACF-DEFINED
      IRR012I VERIFICATION FAILED. USER PROFILE NOT FOUND.
      GT8C G4AUTH: VERIFY FAILED R15=(00000004)
      GT8C G4AUTH: ( 00AC5628 / ORAGT8C
      TXM11802I TCP/IP socket #0001(4) closed between 167.82.63.98:1528 and
      10.23.21.166:37691

      Note: The user parameters (user10) is not filled. That's why I got the error 'invalid username/password permission denied'.
        • 1. Re: Cannot connect Oracle 11gR2 to DB2 Database
          Mkirtley-Oracle
          Hi,
          What are you using to make the connection between Oracle from 10.2 and 11g ? What is the version of DB2 being accessed and on which platform is DB2 running ?

          Regards,
          Mike
          • 2. Re: Cannot connect Oracle 11gR2 to DB2 Database
            Mkirtley-Oracle
            Hi,
            I see you have opened a SR with Oracle Support for this problem so it will be best to only work on the SR and not duplicate questions here.

            Regards,
            Mike
            • 3. Re: Cannot connect Oracle 11gR2 to DB2 Database
              995993
              hi

              i know this post was very old but i want your help please
              iam having one db2 database know i want to connect this database with my oracle application,
              i dont have any idea how to do this ,
              so can you please provide me the step by step process how to connect,
              anything you want to ask please contact my maill id
              mohammedrahil2012@gmail.com
              thanking you

              regards
              rahil
              • 4. Re: Cannot connect Oracle 11gR2 to DB2 Database
                Mkirtley-Oracle
                Hi Rahil,
                It is always best to open a new SR instead of adding to an existing one for questions sucha s this, as updates to old threads can be overlooked.

                There are 2 methods you can use to conenct to a DB2 database -

                - Database Gateway for DRDA (DG4DRDA)
                - Database Gateway for ODBC(DG4ODBC)

                There is further information in the following notes available on My Oracle Support -

                Master Note for Oracle Gateway Products (Doc ID 1083703.1)
                Options for Connecting to Foreign Data Stores and Non-Oracle Databases (Doc ID 233876.1)
                Functional Differences Between DG4ODBC and Specific Database Gateways (Doc ID 252364.1)
                Gateway and Generic Connectivity Licensing Considerations (Doc ID 232482.1)

                If you do not have access to My Oracle Support then you will need to contact someone in your organisation to get access, or access the notes for you, as we cannot paste them into OTN.
                You can also check the gateway documentation here -

                http://www.oracle.com/pls/db112/homepage

                Click on 'Information Integration' and then 'Heterogeneous Connectivity'

                Regards,
                Mike