search cancel

Unable to load 12.3 UC_UPD.TXT

book

Article ID: 201357

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

Automic Admin in the process of upgrading one of our environments from 12.2 to 12.3 and the step where you load the upd.txt file via db load utility is failing with:

20201013/123541.720 - U00038091 Change application directory to '/webapps/automic/Utility/bin/'.
20201013/123541.721 - U00029120 UCUDB: Function LoadLibrary failed. Library 'ucuoci.so' error 'libclntsh.so.12.1: cannot open shared object file: No such file or directory'.
20201013/123541.721 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).
20201013/123541.721 - U00003531 UCUDB: Error while checking data source (e.g. code conversion or driver problem, see log file).

This is their current, which has ORACLE_HOME/lib in it:

env | grep LD_LIBRARY_PATH

LD_LIBRARY_PATH=/qapps/oracle/app/product/11.2.0/client_1/lib:/usr/lib:usr/local/lib:/qapps/oracle/app/product/11.2.0/client_1/network/lib:/qapps/oracle/app/product/11.2.0/client_1/plsql/lib:/qapps/oracle/app/product/11.2.0/client_1/precomp/lib:/qapps/oracle/app/product/11.2.0/client_1/rdbms/lib:/qapps/oracle/app/product/11.2.0/client_1/sqlplus/lib:/webapps/automic/AE/bin:/webapps/automic/Utility/bin:/qapps/oracle/app/product/11.2.0/client_1/lib:/usr/lib:/lib

 

 

 

Environment

Release : 12.3.x

Component : AUTOMATION ENGINE

Resolution

  • From your LD_LIBRARY_PATH it looks like you are using Oracle 11g (11.2) DB or an 11.2 client:
  • This database version is only supported up to Automic 12.2:
    • https://docs.automic.com/tools/compatibility_matrix?compatibility-mode=platform&db_version_id=142805555217
  • In Automic 12.3 the minimum version of Oracle that we support is Oracle 12.c or higher:
    • https://docs.automic.com/tools/compatibility_matrix?compatibility-mode=platform&db_version_id=1417949207217
      • If your Automic version is 12.2.2 or higher you can upgrade to Oracle 18c before upgrading to Automic 12.
      • If your Automic version is 12.2.3 or higher you can upgrade Oracle 19c or higher.