Currently upgrading 11.2 to 19.3 database using dbua silent.
Run preupgrade.jar and no issues detected.
Run preupgrade_fixups.sql
Run dbua -silent error resulted with [FATAL] [DBT-20061]
Per Doc ID 2246770.1, ignore the error which may be hazardous.
Actually, I have already figured our the root cause; however, the method I used may not always be available for all environments.
Will post solution in a week.
HINT: probable cause is in the output which did not occur for first run.
$ env|grep HOME
OLD_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
NEW_HOME=/u01/app/oracle/product/19.3.0.0/dbhome_1
HOME=/home/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0.4/dbhome_1
$ $OLD_HOME/jdk/bin/java -jar $NEW_HOME/rdbms/admin/preupgrade.jar TERMINAL TEXT FILE
==================
PREUPGRADE SUMMARY
==================
/u01/app/oracle/cfgtoollogs/hawk_stby/preupgrade/preupgrade.log
/u01/app/oracle/cfgtoollogs/hawk_stby/preupgrade/preupgrade_fixups.sql
/u01/app/oracle/cfgtoollogs/hawk_stby/preupgrade/postupgrade_fixups.sql
Execute fixup scripts as indicated below:
Before upgrade:
Log into the database and execute the preupgrade fixups
@/u01/app/oracle/cfgtoollogs/hawk_stby/preupgrade/preupgrade_fixups.sql
After the upgrade:
Log into the database and execute the postupgrade fixups
@/u01/app/oracle/cfgtoollogs/hawk_stby/preupgrade/postupgrade_fixups.sql
Preupgrade complete: 2020-07-31T18:50:38
oracle@ol7-112-dg2:hawk:/home/oracle
$
*******************************************************
$ sqlplus / as sysdba @/u01/app/oracle/cfgtoollogs/hawk_stby/preupgrade/preupgrade_fixups.sql
SQL*Plus: Release 11.2.0.4.0 Production on Fri Jul 31 18:52:21 2020
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 7
Generated on: 2020-07-31 18:50:36
For Source Database: HAWK
Source Database Version: 11.2.0.4.0
For Upgrade to Version: 19.0.0.0.0
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. min_recovery_area_size NO Manual fixup required.
2. parameter_min_val NO Manual fixup recommended.
3. em_present NO Manual fixup recommended.
4. amd_exists NO Manual fixup recommended.
5. apex_manual_upgrade NO Manual fixup recommended.
6. tablespaces_info NO Informational only.
Further action is optional.
7. exf_rul_exists NO Informational only.
Further action is optional.
8. rman_recovery_version NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade. To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
OL7-112-DG2:(SYS@hawk_stby:LOGICAL STANDBY>
*******************************************************
$ $NEW_HOME/bin/dbua -silent \
> -sid $ORACLE_SID \
> -oracleHome $ORACLE_HOME \
> -recompile_invalid_objects TRUE \
> -upgradeTimezone TRUE \
> -emConfiguration NONE \
> -upgrade_parallelism 2
Logs directory: /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-07-31_06-53-41PM
Performing Pre-Upgrade Checks...
============================
PRE- and POST- FIXUP ACTIONS
=============================
/u01/app/oracle/cfgtoollogs/dbua/upgrade2020-07-31_06-53-41PM/hawk/upgrade.xml
/u01/app/oracle/cfgtoollogs/dbua/upgrade2020-07-31_06-53-41PM/hawk/preupgrade_fixups.sql
/u01/app/oracle/cfgtoollogs/dbua/upgrade2020-07-31_06-53-41PM/hawk/postupgrade_fixups.sql
[FATAL] [DBT-20061] One or more of the pre-upgrade checks on the database have resulted into error conditions that must be addressed before proceeding.
ACTION: Refer to the pre-upgrade results location for details: /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-07-31_06-53-41PM/hawk
*******************************************************
$ ls -l /u01/app/oracle/cfgtoollogs/dbua/upgrade2020-07-31_06-53-41PM/hawk
total 692
-rw-r-----. 1 oracle oinstall 1 Jul 31 18:53 checksBuffer.tmp
-rw-r-----. 1 oracle oinstall 41134 Jul 31 18:53 components.properties
-rw-r-----. 1 oracle oinstall 15085 Jul 31 18:53 dbms_registry_extended.sql
drwxr-x---. 3 oracle oinstall 21 Jul 31 18:53 oracle
-rw-r-----. 1 oracle oinstall 14051 Jul 31 18:53 parameters.properties
-rw-r-----. 1 oracle oinstall 8584 Jul 31 18:53 postupgrade_fixups.sql
-rw-r-----. 1 oracle oinstall 7884 Jul 31 18:53 preupgrade_driver.sql
-rw-r-----. 1 oracle oinstall 13082 Jul 31 18:53 preupgrade_fixups.sql
-rw-r-----. 1 oracle oinstall 101702 Jul 31 18:53 preupgrade_messages.properties
-rw-r-----. 1 oracle oinstall 461660 Jul 31 18:53 preupgrade_package.sql
-rw-r-----. 1 oracle oinstall 5215 Jul 31 18:53 sqls.log
drwxr-x---. 3 oracle oinstall 24 Jul 31 18:53 upgrade
-rw-r-----. 1 oracle oinstall 15082 Jul 31 18:53 upgrade.xml
*******************************************************
DBUA Silent : Director Service Registration Error DBT-20060 DBT-08010 (Doc ID 2246770.1)
Case 2 :
SEVERE: [FATAL] [DBT-20061] One or more of the pre-upgrade checks on the database have resulted into error conditions that must be addressed before proceeding.
./dbua -silent -sid <SID> -oracleHome $ORACLE_HOME -J-Doracle.install.dbua.validate.all=false
Thinking Out Loud 