This discussion is archived
3 Replies Latest reply: Oct 19, 2012 6:52 AM by mkirtley-Oracle RSS

dg4odbc doesn't work ater patches installation

969516 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points