Hello Friend's,
In this post we will discuss about Autoupgrade from 19c to 21c.
So lets get started
1. Check the version of Autoupgrade.
2. Create parameter file for Autoupgrade.
3. Start with the First Analyze Mode.
4. Start with the fixup Part.
5. Errors Got during Deploy.
--Solution for Error--6. Start of deploy Actual upgrade operation.
###################Start of steps##########1. Check the version of Autoupgrade
[oracle@dm21db01 oracle]$ . oraenv
ORACLE_SID = [oracle] ? AUPG
The Oracle base has been set to /oracle/app/orawork
[oracle@dm21db01 oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -version
build.hash 680914c
build.version 21.2.210721
build.date 2021/07/21 11:14:54
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production
2. Create parameter file for Autoupgrade
# Global logging directory pertains to all jobs
#
global.autoupg_log_dir=/oracle/autoupgrade # Top level logging directory (Required)
#
# Db 1
#
upg1.source_home/oracle/app/orawork/product/19.3.0.0/db_1
upg1.target_home=/oracle/app/orawork/product/21.3.0.0/db_1
upg1.sid=AUPG
upg1.start_time=now #we can also specify a perticular time e.g 12/02/2021 18:00:00
upg1.pdbs=UPGPDB
upg1.log_dir=/oracle/autoupgrade/Aupg
upg1.upgrade_node=dm21db01.database.com
upg1.run_utlrp=yes
upg1.timezone_upg=yes
upg1.target_version=21
3. Start with the First Analyze Mode
[oracle@dm21db01 oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/Config_upgrd.txt -mode analyze
AutoUpgrade 21.2.210721 launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
1 databases will be analyzed
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+-------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+-------+
| 100| AUPG|PRECHECKS|PREPARING|FINISHED|21/12/04 18:35|18:35:09| |
+----+-------+---------+---------+--------+--------------+--------+-------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 100| AUPG|PRECHECKS|PREPARING|RUNNING|21/12/04 18:35|18:35:16|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> status
---------------- Config -------------------
User configuration file [/oracle/Config_upgrd.txt]
General logs location [/oracle/autoupgrade/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 ----------------="" ------------="" 2="" cpu="" in="" jvm="" mb="" memory="" min="" prechecks="" processes="" progress="" resources="" threads="" upg="" use="" used=""> 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/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
4. Start with the fixup Part
$ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/Config_upgrd.txt -mode fixups
[oracle@dm21db01 oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/Config_upgrd.txt -mode fixups
AutoUpgrade 21.2.210721 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|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 102| AUPG|PRECHECKS|PREPARING|RUNNING|21/12/04 19:48|19:48:36|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 102| AUPG|PRECHECKS|PREPARING|RUNNING|21/12/04 19:48|19:48:36|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg> Job 102 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs pending [0]
Please check the summary report at:
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
5. Errors Got during Deploy.
$ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/Config_upgrd.txt -mode deploy
2021-12-06 18:29:56.443 INFO Deleting parameter *.local_listener='LISTENER_AUPG' in /oracle/autoupgrade/Aupg/AUPG/temp/during_upgrade_pfile_aupg.ora
2021-12-06 18:29:56.450 INFO Adding parameter cluster_database='FALSE' to /oracle/autoupgrade/Aupg/AUPG/temp/during_upgrade_pfile_aupg.ora
2021-12-06 18:30:01.027 ERROR Upgrade requires 13,314,093,056 bytes free on +FRA; available space is 9,432,989,696 bytes
2021-12-06 18:30:02.203 WARNING 1 fixups ran with errors, review the logs for further input, summary report available at /oracle/autoupgrade/Aupg/AUPG/103/prefixups/failed_prefixups.log
2021-12-06 18:30:02.206 INFO Creating summary of the fixups which ran with errors in /oracle/autoupgrade/Aupg/AUPG/103/prefixups/failed_prefixups.log
ADD DISK TO EXISTING ASM DISKGROUP
6. Start of deploy Actual upgrade operation.
[oracle@dm21db01 ~]$
[oracle@dm21db01 ~]$ cd /oracle
[oracle@dm21db01 oracle]$ $ORACLE_HOME/jdk/bin/java -jar autoupgrade.jar -config /oracle/Config_upgrd.txt -mode deploy
Previous execution found loading latest data
Total jobs recovered: 1
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
Type 'help' to list console commands
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+-------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+-------+
| 103| AUPG|PRECHECKS|PREPARING|FINISHED|21/12/06 18:25|19:45:25| |
+----+-------+---------+---------+--------+--------------+--------+-------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 103| AUPG|PRECHECKS|PREPARING|RUNNING|21/12/06 18:25|19:45:32|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 1
upg>
upg>
upg> lsj
+----+-------+-----+---------+-------+--------------+--------+----------------------------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+-----+---------+-------+--------------+--------+----------------------------------------+
| 103| AUPG|DRAIN|EXECUTING|RUNNING|21/12/06 18:25|19:52:49|Checking if this system needs to have RA|
+----+-------+-----+---------+-------+--------------+--------+----------------------------------------+
Total jobs 1
upg>
upg> lsj
+----+-------+-----+---------+-------+--------------+--------+----------------------+
|Job#|DB_NAME|STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+-----+---------+-------+--------------+--------+----------------------+
| 103| AUPG|DRAIN|EXECUTING|RUNNING|21/12/06 18:25|19:53:56|Shutting down database|
+----+-------+-----+---------+-------+--------------+--------+----------------------+
Total jobs 1
upg>
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED|MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|19:54:55|Running|
+----+-------+---------+---------+-------+--------------+--------+-------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-------------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|19:55:12|0%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+-------------------+
Total jobs 1
upg>
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|19:58:13|10%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|20:04:13|22%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg>
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|20:13:14|72%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg>
upg> status
---------------- Config -------------------
User configuration file [/oracle/Config_upgrd.txt]
General logs location [/oracle/autoupgrade/cfgtoollogs/upgrade/auto]
Mode [DEPLOY]
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: 103
DB name: AUPG
SETUP <1 ----------------="" ------------="" 21="" 2="" 3="" cpu="" dbupgrade="" drain="" grp="" in="" jvm="" mb="" memory="" min="" prechecks="" prefixups="" preupgrade="" processes="" progress="" resources="" threads="" upg="" use="" used=""> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|20:19:15|97%Upgraded CDB$ROOT|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+-----------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|20:21:46|0%Upgraded UPGPDB|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 1
upg>
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+--------------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
| 103| AUPG|DBUPGRADE|EXECUTING|RUNNING|21/12/06 18:25|20:42:50|52%Upgraded PDB$SEED|
+----+-------+---------+---------+-------+--------------+--------+--------------------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+---------------+
| 103| AUPG|POSTFIXUPS|EXECUTING|RUNNING|21/12/06 18:25|20:55:16|Remaining 11/12|
+----+-------+----------+---------+-------+--------------+--------+---------------+
Total jobs 1
upg> lsj
+----+-------+----------+---------+-------+--------------+--------+---------------+
|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+---------------+
| 103| AUPG|POSTFIXUPS|EXECUTING|RUNNING|21/12/06 18:25|20:55:16|Remaining 11/12|
+----+-------+----------+---------+-------+--------------+--------+---------------+
Total jobs 1
upg> Job 103 completed
------------------- Final Summary --------------------
Number of databases [ 1 ]
Jobs finished [1]
Jobs failed [0]
Jobs pending [0]
---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from AUPG: drop restore point AUTOUPGRADE_9212_AUPG193000
Please check the summary report at:
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
Please check the summary report at:
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/oracle/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
Hope This will help you all .
Regards
Sultan Khan
ConversionConversion EmoticonEmoticon