Upgrading the DB (DbLoad) from an old version (< 11.2) with a recent DB version (i.e Oracle 19c) does not work properly

Article Id: 195455

Status: Published

Updated On: 20-07-2020 07:00

Products:

CA Automic Workload Automation - Automation Engine , CA Automic One Automation , CA Automic Operations Manager , CA Automic Oracle

Issue/Introduction:

When upgrading the DB to a recent version (e.g Oracle 19c) using an old AE release (lower than 11.2) the error below may appear :

20200720/111750.526 - U00038071 The version of the database system could not be clearly assigned. Version: '19.0.0.0.0' in UPGRADE file not found.
Application return code = 1

Cause:

On the oldest releases of the AE/DbLoad scripts, every DB versions were set in the configuration files (UC_UPD.TXT, UC_UPD_STEP.TXT, ...).
From AE 11.2, all Oracle versions could be found using the "*" character (e.g Oracle* instead of Oracle 11.2/Oracle 12.1/Oracle 12.2, ...)

Environment:

Release : 12.3

Component : AUTOMATION ENGINE

Resolution:

Get the "defined path *" lines from the TXT files in the db/11.2 folder and past it in the 10.0/11.0/11.2 files.