Hello Friend's,
In this mode we will see the Pratical steps for Autoupgrade Analyze option .
i) Analyze :
As the name suggest this mode analyze the database running preupgrade.jar
but what it dose more that just running preupgrade.jar this mode also analyze (checks) the setup aswell
it will generate 2 file with information about the database
i) sid.html
ii) sid_preupgrade.log
once this mode is complete sucessfully , This will confirm there will the no suprise error in further process of upgrade :)
e.g command : $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/config_upgrd.txt -mode analyze
Execute autoupgrade in ANALYZE mode
The Autoupgrade Console enables us to monitor as well as manage and control the jobs started by the autoupgrade utility.
For example we use the ‘lsj’ command while in the console prompt which will list the running upgrade jobs along with the progress and status.
[oracle@Linux-Mach oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/config_upgrd.txt -mode analyze
AutoUpgrade tool launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 databases will be analyzed
Type 'help' to list console commands
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 100| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/12 19:18|19:18:31|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 100| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/12 19:18|19:18:31|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
| 100| Aupg|PRECHECKS|PREPARING|RUNNING|21/02/12 19:18|19:18:47|Remaining 197/212|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 1
upg>
upg> status
---------------- Config -------------------
User configuration file [/oracle/config_upgrd.txt]
General logs location [/oracle/auto-upgrade/cfgtoollogs/upgrade/auto]
Mode [ANALYZE]
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: 100
DB name: Aupg
SETUP <1 ----------------="" ------------="" cpu="" in="" jvm="" mb="" memory="" min="" prechecks="" processes="" progress="" resources="" threads="" upg="" use="" used=""> tasks
+---+------------------+-------------+
| ID| NAME| Job#|
+---+------------------+-------------+
| 1| main| WAITING|
| 54| event_loop|TIMED_WAITING|
| 55| console| RUNNABLE|
| 56| queue_reader| WAITING|
| 57| cmd-0| WAITING|
| 58| job_manager-0| WAITING|
| 59| bqueue-100| WAITING|
|202|actionworker-100-0| WAITING|
|203|actionworker-100-1|TIMED_WAITING|
|205| aupg-puic-0| WAITING|
|206| aupg-puic-1| WAITING|
|274| quickSQL| RUNNABLE|
|275| quickSQL| RUNNABLE|
+---+------------------+-------------+
upg>
upg> Job 100 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
[oracle@Linux-Mach oracle]$
Output of STATUS logfile :
[oracle@Linux-Mach oracle]$ cat /oracle/auto-upgrade/cfgtoollogs/upgrade/auto/status/status.log
==========================================
Autoupgrade Summary Report
==========================================
[Date] Fri Feb 12 19:19:12 IST 2021
[Number of Jobs] 1
==========================================
[Job ID] 100
==========================================
[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-12 19:18:31
[Duration] 0:00:40
[Log Directory] /oracle/auto-upgrade/Aupg/Aupg/100/prechecks
[Detail] /oracle/auto-upgrade/Aupg/Aupg/100/prechecks/aupg_preupgrade.log
Precheck passed and no manual intervention needed
------------------------------------------
Output of Status.html
ConversionConversion EmoticonEmoticon