3 Replies Latest reply: Jun 3, 2014 2:21 AM by Mkirtley-Oracle RSS

    Database Gateway for DRDA 11g Release 2

    959602

      Hello,

       

      Is this the correct place to ask about Database Gateway configuration issues? If not please let me know where I can ask these questions.

       

      DB2 database, V10 on z/OS 1.13

      Database Gateway for DRDA, 11.2.0.4 on Red Hat Linux 6

      Oracle 11.2.0.3 database on Red Hat Linux 6

       

      The Gateway software and the database are not running on the same machine.

       

      I have looked at the following docs :

       

      Oracle® Database Gateway for DRDA User's Guide 11g Release 2 (11.2) E12014-03

      Master Note for Oracle Gateway Products (Doc ID 1083703.1)

      Installation Overview For Oracle Database Gateway Products (Doc ID 1351618.1)

      Oracle Database (RDBMS) on Unix AIX,HP-UX,Linux,Mac OS X,Solaris,Tru64 Unix Operating Systems Installation and Configuration Requirements Quick Reference (8.0.5 to 11.2) (Doc ID 169706.1)

      Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64) (Doc ID 1441282.1

      Things to Know About Linux (Doc ID 265262.1)

       

      The gateway 'listener' is up and running, no errors.

      The 11.2.0.3 database (lets call it TESTSID) on Red Hat Linux 6 is configured to use DB2 information that works for another Oracle database (lets call it WORKSID) that has the gateway running on the same machine as the database, so if I understand correctly, there should not be any need to do anything in DB2 or on the mainframe - please correct me if I'm wrong.

      I have created a tnsnames entry for the Gateway listener on the database machine. I cannot do a tnsping. TNS-12541: TNS:no listener

      I have created the same account, with the same roels and privs in the TESTSID database as the database that works (WORKSID). I have also created the same Public database link and the same Public synonyms in TESTSID as those that exist in WORKSID.

       

      Question 1) How do I test the connection between the Gateway and DB2, without using TESTSID?

      Question 2) How do I test the connection between TESTSID and the Gateway, without using DB2?

       

      I have opened an SR with Oracle support, but I wanted to reach a larger audience on OTN.

       

      rgs,

       

      Matt

        • 1. Re: Database Gateway for DRDA 11g Release 2
          Top.Gun

          There should be a Gateway forum that can answer this question.

          • 2. Re: Database Gateway for DRDA 11g Release 2
            Kgronau-Oracle

            The answers to your questions:

            Question 1) How do I test the connection between the Gateway and DB2, without using TESTSID? => you can only test the connection between the Oracle gateway and a DB2 with an Oracle database.

             

            Question 2) How do I test the connection between TESTSID and the Gateway, without using DB2? => use tnsping

             

            In general there are depending on the error message several ways to test the connection. The first point you have to check all the time is the listener. The listener status will show you on which IP address/hostname and port it is listening on. This information is required for the tnsnames.ora entry. When the address information in the tnsnames.ora is now correct and the listener is up and running, a tnsping should come back with a successful message.

            There is no way to test with tnsping the SID an Oracle listener is serving, so here the only way to check if the SID information in your tnsnames.ora matches your listener is to test the connection.

             

            You're seeing a No listener error (ORA-12541) so that means the address information in your tnsnames.ora doesn't match your listener.ora. If you're sure the info is correct, then check that you do not have a firewall between both machines that blocks the connection.

            - Klaus

            • 3. Re: Database Gateway for DRDA 11g Release 2
              Mkirtley-Oracle

              Hi Matt,

                  Can you post the following  -

              - tnsnames.ora you are using to connect to the gateway listener

              - the listener.ora of the gateway listener ?

              - the create database link statement from the TESTSID RDBMS

              - what is the erro you get from tnsping ?

              - what is the erro you get when trying a select using the database link ?

               

              To try and answer your questions -

              Question 1) How do I test the connection between the Gateway and DB2, without using TESTSID?

              - there isn't really a way to do this.  The gateway executable tries to make the connection to DB2 once it is called from a database link. You can check the following -

              - that the gateway machine can ping the machine where DB2 is running

              - the port define in HS_FDS_CONNECT_INFORMATION is correct

              - the DB2 database name in the connect information is correct

               

              Question 2) How do I test the connection between TESTSID and the Gateway, without using DB2?

              Make sure of the following -

              - you can ping the machine where the listener is running

              - you can tnsnping the gateway listener

              - the gateway listener is running and the gateway services are available, run -

              lsnrctl status <gateway_listener_name>

              lsnrctl services <gateway_listener_name>

               

              As you have an SR with Support I would expect them to be able to resolve your problem as it looks like some sort of configuration error.

               

              Regards,
              Mike