When applying SP8 cum1 patch SO12221 it fails at the refresh_aedb portion.
The "refresh_aedb.log" ends with:
SQL> BEGIN
2 DBMS_OUTPUT.PUT_LINE('Fixing ujo_afm table to fix wrong data in ujo_afm.source column.');
3 END;
4 /
Fixing ujo_afm table to fix wrong data in ujo_afm.source column.
PL/SQL procedure successfully completed.
SQL> EXIT;
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Return code = 0
CA Workload Automation AE database was not refreshed.
RefreshAEDB.pl fails due to fact that there are machine names starting with ORA-
This caused the RefreshAEDB.pl script to fail during the patch run.
Release : 11.3.6
Component : CA Workload Automation AE (AutoSys)
You can use following workaround:
Adapt the $AUTOSYS/dbobj/ORA/RefreshAEDB.pl script as follows:
Modify
if ($outLine =~ m/ORA-/) {
$SUCCESS="N";
}
to
if ($outLine =~ m/ORA-\d\d\d\d\d: /) {
$SUCCESS="N";
}
After this, the patch succeeded and the update is complete.