Hello Friend's,
In this mode we will see the Pratical steps for Autoupgrade Fixup option .
ii) Fixup :
Fixup mode goes a steps ahead of Analyze mode , This mode will have all steps of analyze mode addition to that
this mode will also fixup the errors found in prechecks
e.g same as running preupgrade fixup file in normal upgrade
running fixup will also generate a status log file .
e.g command : $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/config_upgrd.txt -mode fixups
[oracle@Linux-Mach oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/config_upgrd.txt -mode fixups
AutoUpgrade tool launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 databases will be processed
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 101| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/19 15:59|15:59:12|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 101| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/19 15:59|15:59:12|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
| 101| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/19 15:59|15:59:50|Remaining 185/212|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
| 101| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/19 15:59|16:00:05|Remaining 113/212|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------+
| 101| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/19 15:59|16:00:11|Remaining 91/212|
+----+-------+---------+---------+-------+--------------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------+
| 101| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/19 15:59|16:00:23|Remaining 23/212|
+----+-------+---------+---------+-------+--------------+--------+----------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+---------------+
| 101| Aupg|PREFIXUPS|EXECUTING|RUNNING|21/02/19 15:59|16:00:41|Remaining 10/10|
+----+-------+---------+---------+-------+--------------+--------+---------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/oracle/config_upgrd.txt]
General logs location [/oracle/auto-upgrade/cfgtoollogs/upgrade/auto]
Mode [FIXUPS]
DB upg fatal errors ORA-00600,ORA-07445
DB Post upgrade abort time [60] minutes
DB upg abort time [1440] minutes
DB restore abort time [120] minutes
DB GRP abort time [3] minutes
------------------------ Jobs ------------------------
Total databases in configuration file [1]
Total Non-CDB being processed [0]
Total CDB being processed [1]
Jobs finished successfully [0]
Jobs finished/aborted [0]
Jobs in progress [1]
Jobs stage summary
Job ID: 101
DB name: Aupg
SETUP <1 ----------------="" ------------="" 1="" cpu="" in="" jvm="" mb="" memory="" min="" prechecks="" prefixups="" processes="" progress="" resources="" threads="" upg="" use="" used="">
upg> tasks
+---+------------------+-------------+
| ID| NAME| Job#|
+---+------------------+-------------+
| 1| main| WAITING|
| 56| event_loop|TIMED_WAITING|
| 57| console| RUNNABLE|
| 58| queue_reader| WAITING|
| 59| cmd-0| WAITING|
| 60| job_manager-0| WAITING|
| 61| bqueue-101| WAITING|
|317| exec_loop| WAITING|
|424|actionworker-101-0| WAITING|
|425|actionworker-101-1|TIMED_WAITING|
|427| aupg-puifxl0-0| WAITING|
|429| quickSQL| RUNNABLE|
+---+------------------+-------------+
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 101| Aupg|PREFIXUPS|EXECUTING|RUNNING|21/02/19 15:59|16:13:04|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 101| Aupg|PREFIXUPS|EXECUTING|RUNNING|21/02/19 15:59|16:13:04|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> Job 101 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs pending [0]
Please check the summary report at:
/oracle/auto-upgrade/cfgtoollogs/upgrade/auto/status/status.html
/oracle/auto-upgrade/cfgtoollogs/upgrade/auto/status/status.log
Output of STATUS logfile :
[oracle@Linux-Mach oracle]$ cat /oracle/auto-upgrade/cfgtoollogs/upgrade/auto/status/status.log
==========================================
Autoupgrade Summary Report
==========================================
[Date] Fri Feb 19 16:14:17 IST 2021
[Number of Jobs] 1
==========================================
[Job ID] 101
==========================================
[DB Name] Aupg
[Version Before Upgrade] 12.2.0.1.0
[Version After Upgrade] 19.3.0.0.0
------------------------------------------
[Stage Name] PRECHECKS
[Status] SUCCESS
[Start Time] 2021-02-19 15:59:12
[Duration] 0:01:19
[Log Directory] /oracle/auto-upgrade/Aupg/Aupg/101/prechecks
[Detail] /oracle/auto-upgrade/Aupg/Aupg/101/prechecks/aupg_preupgrade.log
Precheck passed and no manual intervention needed
------------------------------------------
[Stage Name] PREFIXUPS
[Status] SUCCESS
[Start Time] 2021-02-19 16:00:32
[Duration] 0:13:44
[Log Directory] /oracle/auto-upgrade/Aupg/Aupg/101/prefixups
------------------------------------------
Output of Status.html
ConversionConversion EmoticonEmoticon