I have SAP on oracle 18.104.22.168 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:
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
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`
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
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 22.214.171.124 DG4ODBC stand loane in a seprate ORACLE_HOME from the exsting install.
To do this - Patch 10404530: 126.96.36.199.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 -
- 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.
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.