Error upgrading AWA 11.2.x to 12.2.4
Hello AWA Community and feller Fokus Members,
We have some issues while upgrading on a fresh cloned Automation engine Environment version 11.2.x. (From Production - AE 11.2.1 Oracle Database 11g on SLES 11 SP4)
we had issue loading the tables into the Oracle Database with the DBLoad Utility.
See this Log:
20191108/125735.412 - U00033103 Automation Engine - Utilities Version 12.2.4+build.1569228673716 @ t1uc4 20191108/125737.628 - U00038017 File read: '../db/' 20191108/125745.061 - U00038017 File read: '/opt/uc4/utilities/db/general/12.2/UC_UPD.TXT' 20191108/125745.061 - U00038091 Change application directory to '../db/'. 20191108/125745.061 - U00038091 Change application directory to '../db/'. 20191108/125745.061 - U00038091 Change application directory to '/opt/uc4/utilities/bin'. 20191108/125745.061 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error 'libclntsh.so.12.1: Kann die Shared-Object-Datei nicht öffnen: Datei oder Verzeichnis nicht gefunden'. 20191108/125745.061 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file). 20191108/125745.062 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
After troubleshooting we discovered that the lib is missing libclntsh.so.12.1 so we checked with a command: ldd
on the desired machine, this is the output:
V12.2.4
[uc4@******* /opt/uc4/utilities/bin]$ ldd ucuoci.so
linux-vdso.so.1 => (0x00007ffeb7139000)
libsysapi.so => ./libsysapi.so (0x00007f995a50b000)
libzu00132.so => ./libzu00132.so (0x00007f995a2da000)
libuc001.so => ./libuc001.so (0x00007f995a0d5000)
libclntsh.so.12.1 => not found
libdl.so.2 => /lib64/libdl.so.2 (0x00007f9959ed1000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f9959cb4000)
libstdc++.so.6 => ./libstdc++.so.6 (0x00007f9959ac4000)
libm.so.6 => /lib64/libm.so.6 (0x00007f9959849000)
libgcc_s.so.1 => ./libgcc_s.so.1 (0x00007f995aa04000)
libc.so.6 => /lib64/libc.so.6 (0x00007f99594cd000)
librt.so.1 => /lib64/librt.so.1 (0x00007f99592c4000)
/lib64/ld-linux-x86-64.so.2 (0x00007f995a925000)
V12.2.1
[uc4@***** /opt/uc4/utilities_v12.2.1/bin]$ ldd ucuoci.so
linux-vdso.so.1 => (0x00007fff98dcf000)
libsysapi.so => ./libsysapi.so (0x00007fbabe6e8000)
libzu00132.so => ./libzu00132.so (0x00007fbabe4b7000)
libuc001.so => ./libuc001.so (0x00007fbabe2b2000)
libclntsh.so.11.1 => /opt/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1 (0x00007fbabb8f9000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fbabb6f5000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fbabb4d8000)
libstdc++.so.6 => ./libstdc++.so.6 (0x00007fbabb2e8000)
libm.so.6 => /lib64/libm.so.6 (0x00007fbabb06d000)
libgcc_s.so.1 => ./libgcc_s.so.1 (0x00007fbabebe1000)
libc.so.6 => /lib64/libc.so.6 (0x00007fbabacf1000)
librt.so.1 => /lib64/librt.so.1 (0x00007fbabaae8000)
libnnz11.so => /opt/oracle/product/11.2.0/dbhome_1/lib/libnnz11.so (0x00007fbaba71b000)
libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fbaba503000)
libaio.so.1 => /lib64/libaio.so.1 (0x00007fbaba301000)
/lib64/ld-linux-x86-64.so.2 (0x00007fbabeb02000)
We had with Automic, a case open where the engineer ensured us that the Oracle version 11g is supported by any 12.2.x version.
BTW: in the Community there is some information that this was a bug and had to be fixed with version 12.2.4 https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=2510ede3-0283-454e-a75d-73518a81ca54&CommunityKey=2e1b01c9-f310-4635-829f-aead2f6587c4&tab=digestviewer
Anyone got a hint for us?
------------------------------
Eisa Heinig
Fachkreisreferent
IT System Engineer / Application Operator
uniVersa Lebensversicherung a.G.
Germany, Nuremberg
------------------------------