3 Replies Latest reply: Oct 19, 2012 8:52 AM by Mkirtley-Oracle RSS

    dg4odbc doesn't work ater patches installation

    969516
      Hi.
      I have SAP on oracle 11.2.0.3 and AIX6.1(6100-07-04-1216).
      Yesterday i installed latest bundle patch.
      And heterogenous connection doesn't work.
      ---
      When i do select via dblink, i get:
      in alert.log:
      Fri Oct 19 12:31:39 2012
      HS: Unable to establish RPC connection to HS Agent...
      HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=erabwv)(PORT=1527)))(CONNECT_DATA=(SID=LOTOS))), NCR error = 65535 Unable to retrieve text of NETWORK/NCR message 65535

      -----
      When i try to execute dg4odbc from command line, i get
      dg4odbc
      exec(): 0509-036 Cannot load program dg4odbc because of the following errors:
      rtld: 0712-001 Symbol lstcpn was referenced
      from module dg4odbc(), but a runtime definition
      of the symbol was not found.
      rtld: 0712-002 fatal error: exiting.

      ldd `which dg4odbc`
      /oracle/BWP/112_64/bin/dg4odbc needs:
      /oracle/BWD/112_64/lib/libagtsh.a(shr.o)
      /usr/lib/libpthreads.a(shr_xpg5_64.o)
      /oracle/BWD/112_64/lib/libclntsh.so
      /usr/lib/libc.a(shr_64.o)
      /oracle/BWD/112_64/lib/libnnz11.so
      /usr/lib/libdl.a(shr_64.o)
      /usr/lib/libc.a(aio_64.o)
      /usr/lib/libodm.a(shr_64.o)
      /usr/lib/libperfstat.a(shr_64.o)
      /unix
      /usr/lib/libcrypt.a(shr_64.o)
      /usr/lib/libcfg.a(shr_64.o)
      /usr/lib/liblvm.a(shr_64.o)
      /usr/lib/libcorcfg.a(shr_64.o)
      /usr/lib/libsrc.a(shr_64.o)

      I found that files /oracle/BWD/112_64/lib/libagtsh.a and /oracle/BWD/112_64/lib/libclntsh.so where chagned.

      -----
      I tried to reinstall it, but in failed:
      INFO: Start output from spawned process:

      INFO: - Linking dg4odbc agent

      INFO: rm -f /oracle/BWD/11203/rdbms/lib/dg4odbc

      INFO: ld -b64 -o /oracle/BWD/11203/rdbms/lib/dg4odbc -L/oracle/BWD/11203/rdbms/lib/ -L/oracle/BWD/11203/lib/ /oracle/BWD/11203/hs/lib/dg4odbc.o /oracle/BWD/112
      03/rdbms/lib/homts.o -lhgosh11 -lhggcon11 -lhgosh11 -lagtsh -lpthreads -lclntsh -brtl -lld -lm `cat /oracle/BWD/11203/lib/sysliblist` -lm

      INFO: ld: 0711-224 WARNING: Duplicate symbol: p_xargc

      INFO: ld: 0711-224 WARNING: Duplicate symbol: p_xargv
      ld: 0711-224 WARNING: Duplicate symbol: .bcopy
      ld: 0711-224 WARNING: Duplicate symbol: p_xrcfg
      ld: 0711-224 WARNING: Duplicate symbol: p_xrc
      ld: 0711-345 Use the -bloadmap or -bnoquiet option to obtain more information.

      INFO: ld: 0711-317 ERROR: Undefined symbol: .lstcpn

      INFO: make: 1254-004 The error code from the last command is 8.
      -----

      Edited by: user12260373 on Oct 19, 2012 4:15 AM

      Edited by: user12260373 on Oct 19, 2012 4:37 AM

      Edited by: user12260373 on Oct 19, 2012 4:38 AM
        • 1. Re: dg4odbc doesn't work ater patches installation
          Mkirtley-Oracle
          Hi,
          When you say you applied the latest bundle patch was that an Oracle patchset or a SAP patchset ? If it was Oracle then what was the actual name of the patch ?
          Is Dg4ODBC installed in the same ORACLE_HOME as your RDBMS ?

          One solution until we can find a cause is to install 11.2.0.3 DG4ODBC stand loane in a seprate ORACLE_HOME from the exsting install.
          To do this -

          Patch 10404530: 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER

          - logon to My Oracle Support
          - go to Patches & Updates section
          - search for patch number 10404530 and your platform HP-UX Itanium, Linux x86-64 , Oracle Solaris on SPARC (64-bit), IBM AIX on Power Systems (64-bit)
          - you may need to press the '+' button to see the platform list
          - click on the patch number
          - from the download screen you only need to download the following for the gateways -

          p10404530_112030_platform_5of7.zip

          - this is the Gateway media pack and has everything needed for a standalone gateway install.
          - unzip the file and run the installer and choose the gateway you want.

          I'll follow up on the error you are reporting.

          Regards,
          Mike
          • 2. Re: dg4odbc doesn't work ater patches installation
            969516
            Hi. SAP bundle is a SAP patchset. They relese it monthly.
            dg4odbc installed in the same ORACLE_HOME.
            I switched dblink to unpatched system and now it works.

            List of patches i installed yesterday:
            Patch 10110625 : applied on Thu Oct 18 14:24:53 GMT+04:00 2012
            Patch 10214323 : applied on Thu Oct 18 14:24:37 GMT+04:00 2012
            Patch 12791981 : applied on Thu Oct 18 14:24:13 GMT+04:00 2012
            Patch 12865902 : applied on Thu Oct 18 14:23:51 GMT+04:00 2012
            Patch 13011409 : applied on Thu Oct 18 14:23:26 GMT+04:00 2012
            Patch 13038684 : applied on Thu Oct 18 14:23:07 GMT+04:00 2012
            Patch 13080778 : applied on Thu Oct 18 14:22:45 GMT+04:00 2012
            Patch 13092226 : applied on Thu Oct 18 14:22:24 GMT+04:00 2012
            Patch 13250244 : applied on Thu Oct 18 14:22:02 GMT+04:00 2012
            Patch 13430938 : applied on Thu Oct 18 14:21:38 GMT+04:00 2012
            Patch 13524698 : applied on Thu Oct 18 14:21:15 GMT+04:00 2012
            Patch 13632809 : applied on Thu Oct 18 14:20:53 GMT+04:00 2012
            Patch 13716797 : applied on Thu Oct 18 14:20:31 GMT+04:00 2012
            Patch 13718279 : applied on Thu Oct 18 14:20:10 GMT+04:00 2012
            Patch 13735145 : applied on Thu Oct 18 14:19:49 GMT+04:00 2012
            Patch 13911821 : applied on Thu Oct 18 14:19:28 GMT+04:00 2012
            Patch 13936424 : applied on Thu Oct 18 14:19:07 GMT+04:00 2012
            Patch 14264364 : applied on Thu Oct 18 14:18:45 GMT+04:00 2012
            Patch 14301592 : applied on Thu Oct 18 14:18:17 GMT+04:00 2012
            Patch 14333475 : applied on Thu Oct 18 14:17:56 GMT+04:00 2012
            Patch 14487253 : applied on Thu Oct 18 14:17:24 GMT+04:00 2012
            Patch 14488478 : applied on Thu Oct 18 14:16:42 GMT+04:00 2012
            Patch 14524234 : applied on Thu Oct 18 14:16:24 GMT+04:00 2012
            Patch 14535066 : applied on Thu Oct 18 14:16:04 GMT+04:00 2012
            Patch 14562471 : applied on Thu Oct 18 14:15:27 GMT+04:00 2012
            Patch 9458152 : applied on Thu Oct 18 14:14:54 GMT+04:00 2012

            Stand alone gateway is good idea. I will use separete machine for that.
            • 3. Re: dg4odbc doesn't work ater patches installation
              Mkirtley-Oracle
              Hi,
              I think you need to rais e this as a bug with either SAP if they supplied the patches or with Oracle but you would need to open an SR for that in My Oracle Support.

              Regards,
              Mike