()

Steps to Upgrade Grid Infra – Standalone (GI) and Oracle Database from 12.2 to 19.14

In recent two blogs, we discuss Applying the latest JAN-22 RU 33583921 on Grid Infra – Standalone and Database Home (OH) 12.2 Click here to read more. & Steps to Apply Database and Grid Infrastructure RU Patch Before Grid Infrastructure Configuration Click here to read more

Above both steps are necessary to proceed with GI and DB upgrade to 19.14 as before we start an upgrade process, Oracle strongly recommends that we Patch both GI & DB earlier release and new release Oracle Database and GI software. So in the above blogs, we already applied latest Patch JAN-22 RU 33583921 on GI and DB 12.2 Version and already installed alongwith configured GI and DB home 19.3 and applied the latest Patch JAN-22 RU 33509923 on GI and DB 19.3 Version


Below are the high-level steps we will follow.

Step 1. Validate 12.2 GI
Step 2. Run precheck
Step 3. Upgrade GI from 12.2 to 19.14
Step 4. Validate GI upgrade to 19.14

Step 5. Download autoupgrade
Step 6. Create autoupgrade configuration file
Step 7. Upgrade database from 12.2 to 19.14 using autoupgrade
Step 8. Validate DB upgrade to 19.14

 

Below are setup details and the same will be used in this demonstration.

Grid Home 12.2/u01/app/12.2/grid
Oracle DB Home 12.2 /u01/app/oracle/product/12.2/db_1
Grid Home 19.14/u01/app/19.0/grid
Oracle DB Home 19.14/u01/app/oracle/product/19.0/db_1
Non-CDB DB NameNONCDB
CDB DB NameORCL
Autoupgrade Location /u01/19c_dbupgrade


Step 1. Validate 12.2 GI: Crosscheck all services are online in the grid cluster. Use the below commands to check cluster version and services status.

[grid@test-machine03 bin]$
[grid@test-machine03 bin]$ pwd
/u01/app/12.2/grid/bin
[grid@test-machine03 bin]$ ./crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [12.2.0.1.0]
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$ ./crsctl query has softwareversion
Oracle High Availability Services version on the local node is [12.2.0.1.0]
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$ ./crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$
[grid@test-machine03 bin]$ ./crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       test-machine03           STABLE
ora.FRA.dg
               ONLINE  ONLINE       test-machine03           STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       test-machine03           STABLE
ora.asm
               ONLINE  ONLINE       test-machine03           Started,STABLE
ora.ons
               OFFLINE OFFLINE      test-machine03           STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       test-machine03           STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       test-machine03           STABLE
ora.noncdb.db
      1        ONLINE  ONLINE       test-machine03           Open,HOME=/u01/app/o
                                                             racle/product/12.2/d
                                                             b_1,STABLE
ora.orcl.db
      1        ONLINE  ONLINE       test-machine03           Open,HOME=/u01/app/o
                                                             racle/product/12.2/d
                                                             b_1,STABLE
--------------------------------------------------------------------------------


[grid@test-machine03 bin]$


Step 2. Run precheck: Run runcluvfy.sh command with option -pre hacfg make sure all checks are PASSED. We are going to ignore the Swap Size check.

[grid@test-machine03 ~]$
[grid@test-machine03 ~]$ cd /u01/app/19.0/grid/
[grid@test-machine03 grid]$
[grid@test-machine03 grid]$ pwd
/u01/app/19.0/grid
[grid@test-machine03 grid]$
[grid@test-machine03 grid]$ ./runcluvfy.sh stage -pre hacfg
Verifying Physical Memory ...PASSED
Verifying Available Physical Memory ...PASSED
Verifying Swap Size ...FAILED (PRVF-7573)
Verifying Free Space: test-machine03:/usr,test-machine03:/var,test-machine03:/etc,test-machine03:/sbin,test-machine03:/tmp ...PASSED
Verifying User Existence: grid ...
  Verifying Users With Same UID: 1100 ...PASSED
Verifying User Existence: grid ...PASSED
Verifying Group Existence: dba ...PASSED
Verifying Group Membership: dba ...PASSED
Verifying Run Level ...PASSED
Verifying Architecture ...PASSED
Verifying OS Kernel Version ...PASSED
Verifying OS Kernel Parameter: semmsl ...PASSED
Verifying OS Kernel Parameter: semmns ...PASSED
Verifying OS Kernel Parameter: semopm ...PASSED
Verifying OS Kernel Parameter: semmni ...PASSED
Verifying OS Kernel Parameter: shmmax ...PASSED
Verifying OS Kernel Parameter: shmmni ...PASSED
Verifying OS Kernel Parameter: shmall ...PASSED
Verifying OS Kernel Parameter: file-max ...PASSED
Verifying OS Kernel Parameter: ip_local_port_range ...PASSED
Verifying OS Kernel Parameter: rmem_default ...PASSED
Verifying OS Kernel Parameter: rmem_max ...PASSED
Verifying OS Kernel Parameter: wmem_default ...PASSED
Verifying OS Kernel Parameter: wmem_max ...PASSED
Verifying OS Kernel Parameter: aio-max-nr ...PASSED
Verifying OS Kernel Parameter: panic_on_oops ...PASSED
Verifying Package: kmod-20-21 (x86_64) ...PASSED
Verifying Package: kmod-libs-20-21 (x86_64) ...PASSED
Verifying Package: binutils-2.23.52.0.1 ...PASSED
Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED
Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED
Verifying Package: sysstat-10.1.5 ...PASSED
Verifying Package: ksh ...PASSED
Verifying Package: make-3.82 ...PASSED
Verifying Package: glibc-2.17 (x86_64) ...PASSED
Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED
Verifying Package: libaio-0.3.109 (x86_64) ...PASSED
Verifying Package: nfs-utils-1.2.3-15 ...PASSED
Verifying Package: smartmontools-6.2-4 ...PASSED
Verifying Package: net-tools-2.0-0.17 ...PASSED
Verifying Package: policycoreutils-2.5-17 ...PASSED
Verifying Package: policycoreutils-python-2.5-17 ...PASSED
Verifying Users With Same UID: 0 ...PASSED
Verifying Current Group ID ...PASSED
Verifying Root user consistency ...PASSED

Pre-check for Oracle Restart configuration was unsuccessful.


Failures were encountered during execution of CVU verification request "stage -pre hacfg".

Verifying Swap Size ...FAILED
test-machine03: PRVF-7573 : Sufficient swap size is not available on node
                "test-machine03" [Required = 7.7348GB (8110532.0KB) ; Found =
                2GB (2097148.0KB)]


CVU operation performed:      stage -pre hacfg
Date:                         Feb 15, 2022 12:09:32 PM
CVU home:                     /u01/app/19.0/grid/
User:                         grid
[grid@test-machine03 grid]$
[grid@test-machine03 grid]$


Step 3. Upgrade GI from 12.2 to 19.14: Once the above prechecks are done. Stop all databases using the below single command. Enable GUI in server and invoke GI Installer using gridSetup.sh command and follow below screenshots are shown.

[root@test-machine03 bin]# 
[root@test-machine03 bin]# su - oracle
Last login: Mon Feb 14 17:27:35 +03 2022
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ . oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /u01/app/oracle
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ srvctl stop home -oraclehome $ORACLE_HOME -statefile ~/srv1_dbstate1.dmp
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ ps -ef|grep pmon
grid       2978      1  0 14:44 ?        00:00:00 asm_pmon_+ASM
oracle     4329   4176  0 14:53 pts/0    00:00:00 grep --color=auto pmon
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$

[root@test-machine03 ~]# 
[root@test-machine03 ~]# su - grid
Last login: Tue Feb 15 14:40:12 +03 2022
[grid@test-machine03 ~]$ 
[grid@test-machine03 ~]$ export DISPLAY=localhost:10.0
[grid@test-machine03 ~]$ 
[grid@test-machine03 ~]$ cd /u01/app/19.0/grid/
[grid@test-machine03 grid]$ 
[grid@test-machine03 grid]$ xclock
Warning: Missing charsets in String to FontSet conversion
[grid@test-machine03 grid]$ 
[grid@test-machine03 grid]$ pwd
/u01/app/19.0/grid
[grid@test-machine03 grid]$ 
[grid@test-machine03 grid]$ 
[grid@test-machine03 grid]$ ./gridSetup.sh 
Launching Oracle Grid Infrastructure Setup Wizard...

The response file for this session can be found at:
 /u01/app/19.0/grid/install/response/grid_2022-02-15_03-16-24PM.rsp

You can find the log of this install session at:
 /u01/app/oraInventory/logs/UpdateNodeList2022-02-15_03-16-24PM.log
[grid@test-machine03 grid]$ 
Click Ignore All and proceed
Run rootupgrade.sh from root user as below. After successful execution of rootupgrade.sh Click OK.
[root@test-machine03 bin]#
[root@test-machine03 bin]# /u01/app/19.0/grid/rootupgrade.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/19.0/grid

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/app/19.0/grid/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/19.0/crsdata/test-machine03/crsconfig/roothas_2022-02-15_03-23-41PM.log
2022/02/15 15:23:44 CLSRSC-595: Executing upgrade step 1 of 12: 'UpgPrechecks'.
2022/02/15 15:23:48 CLSRSC-595: Executing upgrade step 2 of 12: 'GetOldConfig'.
2022/02/15 15:23:50 CLSRSC-595: Executing upgrade step 3 of 12: 'GenSiteGUIDs'.
2022/02/15 15:23:50 CLSRSC-595: Executing upgrade step 4 of 12: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2022/02/15 15:23:51 CLSRSC-595: Executing upgrade step 5 of 12: 'PreUpgrade'.

ASM has been upgraded and started successfully.

2022/02/15 15:24:26 CLSRSC-595: Executing upgrade step 6 of 12: 'UpgradeAFD'.
2022/02/15 15:24:26 CLSRSC-595: Executing upgrade step 7 of 12: 'UpgradeOLR'.
clscfg: EXISTING configuration version 0 detected.
Creating OCR keys for user 'grid', privgrp 'oinstall'..
Operation successful.
2022/02/15 15:24:30 CLSRSC-595: Executing upgrade step 8 of 12: 'UpgradeOCR'.
LOCAL ONLY MODE
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4664: Node test-machine03 successfully pinned.
2022/02/15 15:24:33 CLSRSC-595: Executing upgrade step 9 of 12: 'CreateOHASD'.
2022/02/15 15:24:34 CLSRSC-595: Executing upgrade step 10 of 12: 'ConfigOHASD'.
2022/02/15 15:24:34 CLSRSC-329: Replacing Clusterware entries in file 'oracle-ohasd.service'
2022/02/15 15:24:57 CLSRSC-595: Executing upgrade step 11 of 12: 'UpgradeSIHA'.

test-machine03     2022/02/15 15:26:18     /u01/app/19.0/crsdata/test-machine03/olr/backup_20220215_152618.olr     3342960164

test-machine03     2022/02/09 17:58:39     /u01/app/12.2/grid/cdata/test-machine03/backup_20220209_175839.olr     0
2022/02/15 15:26:18 CLSRSC-595: Executing upgrade step 12 of 12: 'InstallACFS'.
2022/02/15 15:27:11 CLSRSC-327: Successfully configured Oracle Restart for a standalone server
[root@test-machine03 bin]#


Step 4. Validate GI upgrade to 19.14: After GI upgrade is finished crosscheck all services are online in the grid cluster. Execute the below commands to check cluster version and services status.

[root@test-machine03 bin]#
[root@test-machine03 bin]# ps -ef|grep tns
root         23      2  0 14:38 ?        00:00:00 [netns]
grid      23679      1  0 15:28 ?        00:00:00 /u01/app/19.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
root      24188   2573  0 15:29 pts/0    00:00:00 grep --color=auto tns
[root@test-machine03 bin]#
[root@test-machine03 bin]#

[root@test-machine03 bin]#
[root@test-machine03 app]#
[root@test-machine03 app]# cd 19.0/grid/bin/
[root@test-machine03 bin]#
[root@test-machine03 bin]# pwd
/u01/app/19.0/grid/bin
[root@test-machine03 bin]#
[root@test-machine03 bin]#
[root@test-machine03 bin]# ./crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       test-machine03           STABLE
ora.FRA.dg
               ONLINE  ONLINE       test-machine03           STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       test-machine03           STABLE
ora.asm
               ONLINE  ONLINE       test-machine03           Started,STABLE
ora.ons
               OFFLINE OFFLINE      test-machine03           STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       test-machine03           STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       test-machine03           STABLE
ora.noncdb.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
ora.orcl.db
      1        OFFLINE OFFLINE                               Instance Shutdown,ST
                                                             ABLE
--------------------------------------------------------------------------------
[root@test-machine03 bin]#

[root@test-machine03 bin]# ./crsctl query has releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[root@test-machine03 bin]#
[root@test-machine03 bin]# ./crsctl query has softwareversion
Oracle High Availability Services version on the local node is [19.0.0.0.0]
[root@test-machine03 bin]#
[root@test-machine03 bin]#

[root@test-machine03 bin]#
[root@test-machine03 bin]# su - grid
Last login: Tue Feb 15 15:27:11 +03 2022 on pts/0
[grid@test-machine03 ~]$
[grid@test-machine03 ~]$  export ORACLE_HOME=/u01/app/19.0/grid
[grid@test-machine03 ~]$ export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
[grid@test-machine03 ~]$ opatch lspatches
33575402;DBWLM RELEASE UPDATE 19.0.0.0.0 (33575402)
33534448;ACFS RELEASE UPDATE 19.14.0.0.0 (33534448)
33529556;OCW RELEASE UPDATE 19.14.0.0.0 (33529556)
33515361;Database Release Update : 19.14.0.0.220118 (33515361)
33239955;TOMCAT RELEASE UPDATE 19.0.0.0.0 (33239955)

OPatch succeeded.
[grid@test-machine03 ~]$

[root@test-machine03 bin]#
[root@test-machine03 bin]# su - oracle
Last login: Tue Feb 15 15:38:19 +03 2022 on pts/0
[oracle@test-machine03 ~]$ . oreanv
-bash: oreanv: No such file or directory
[oracle@test-machine03 ~]$ . oraenv
ORACLE_SID = [oracle] ? orcl
The Oracle base has been set to /u01/app/oracle
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ srvctl  start home -oraclehome $ORACLE_HOME -statefile ~/srv1_dbstate1.dmp
[oracle@test-machine03 ~]$

[root@test-machine03 bin]#
[root@test-machine03 bin]#  ./crsctl stat res -t
--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       test-machine03           STABLE
ora.FRA.dg
               ONLINE  ONLINE       test-machine03           STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       test-machine03           STABLE
ora.asm
               ONLINE  ONLINE       test-machine03           Started,STABLE
ora.ons
               OFFLINE OFFLINE      test-machine03           STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       test-machine03           STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       test-machine03           STABLE
ora.noncdb.db
      1        ONLINE  ONLINE       test-machine03           Open,HOME=/u01/app/o
                                                             racle/product/12.2/d
                                                             b_1,STABLE
ora.orcl.db
      1        ONLINE  ONLINE       test-machine03           Open,HOME=/u01/app/o
                                                             racle/product/12.2/d
                                                             b_1,STABLE
--------------------------------------------------------------------------------
[root@test-machine03 bin]#


Step 5. Download autoupgrade: Download from MOS AutoUpgrade Tool (Doc ID 2485457.1)

[root@test-machine03 ~]# 
[root@test-machine03 ~]# cd /u01/19c_dbupgrade
[root@test-machine03 19c_dbupgrade]#
[root@test-machine03 19c_dbupgrade]# ls -ltr
total 2932
-rw-r--r--. 1 root root 2999632 Feb 15 18:05 autoupgrade.jar
[root@test-machine03 19c_dbupgrade]# chown oracle:oinstall autoupgrade.jar
[root@test-machine03 19c_dbupgrade]#

[root@test-machine03 19c_dbupgrade]# su - oracle
Last login: Tue Feb 15 16:37:47 +03 2022 on pts/2
[oracle@test-machine03 ~]$
[oracle@test-machine03 ~]$ cd /u01/19c_dbupgrade
[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ ls -l
total 2932
-rw-r--r--. 1 oracle oinstall 2999632 Feb 15 18:05 autoupgrade.jar
[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ java -jar autoupgrade.jar -version
build.hash 081e3f7
build.version 21.3.211115
build.date 2021/11/15 11:57:54
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

[oracle@test-machine03 19c_dbupgrade]$


Step 6. Create autoupgrade configuration file: Create a sample config file using the below command and edit accordingly as per the environment. We will use location: /u01/19c_dbupgrade/autoupgrade as log directory.

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ java -jar autoupgrade.jar -create_sample_file config
Created sample configuration file /u01/19c_dbupgrade/sample_config.cfg
[oracle@test-machine03 19c_dbupgrade]$

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ ls -ltr
total 2940
-rw-r--r--. 1 oracle oinstall 2999632 Feb 15 18:05 autoupgrade.jar
-rw-r--r--. 1 oracle oinstall    5878 Feb 16 11:25 sample_config.cfg
[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ mkdir -p /u01/19c_dbupgrade/autoupgrade
[oracle@test-machine03 19c_dbupgrade]$

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ vi 19c_config.cfg
global.autoupg_log_dir=/u01/19c_dbupgrade/autoupgrade

upg1.log_dir=/u01/19c_dbupgrade/autoupgrade
upg1.sid=noncdb
upg1.source_home=/u01/app/oracle/product/12.2/db_1
upg1.target_home=/u01/app/oracle/product/19.0/db_1
upg1.start_time=NOW
upg1.upgrade_node=localhost
upg1.run_utlrp=yes
upg1.timezone_upg=yes
upg1.target_version=19

upg2.log_dir=/u01/19c_dbupgrade/autoupgrade
upg2.sid=orcl
upg2.source_home=/u01/app/oracle/product/12.2/db_1
upg2.target_home=/u01/app/oracle/product/19.0/db_1
upg2.start_time=NOW
upg2.upgrade_node=localhost
upg2.run_utlrp=yes
upg2.timezone_upg=yes
upg2.target_version=19
:wq!
[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$

[oracle@test-machine03 19c_dbupgrade]$ pwd
/u01/19c_dbupgrade
[oracle@test-machine03 19c_dbupgrade]$ ls -l
total 2944
-rw-r--r--. 1 oracle oinstall     964 Feb 16 11:49 19c_config.cfg
drwxr-xr-x. 2 oracle oinstall       6 Feb 16 11:50 autoupgrade
-rw-r--r--. 1 oracle oinstall 2999632 Feb 15 18:05 autoupgrade.jar
-rw-r--r--. 1 oracle oinstall    5878 Feb 16 11:25 sample_config.cfg
[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$


Step 7. Upgrade database from 12.2 to 19.14 using autoupgrade: Run autoupgrade first in analyze mode. Review the status.html file for any potential error which can fail Upgrade. Run autoupgrade in fixup mode to run prefixup script and once fixup command is finished review status.html file. Once the above two steps are done and no ERROR in status.html procced with deploy mode where actual downtime will start and autoupgrade will perform actual upgrade steps. If you wish to monitor upgrade in the web browser instead of executing lsj command frequently you can start http server using command “python -m SimpleHTTPServer 8080” Use url: “http://<server-ip>:8080/state.html” to monitor upgrade status directly in this URL.

Analyze Mode

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ java -jar autoupgrade.jar  -config 19c_config.cfg -mode analyze
AutoUpgrade is not fully tested on OpenJDK 64-Bit Server VM, Oracle recommends to use Java HotSpot(TM)
AutoUpgrade 21.3.211115 launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
2 databases will be analyzed
Type 'help' to list console commands
upg>
upg> LSJ
Unrecognized cmd: LSJ
upg> lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME| UPDATED|                     MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 102|   orcl|PRECHECKS|PREPARING|RUNNING|22/02/16 14:12|14:12:45|Loading database information|
| 103| noncdb|PRECHECKS|PREPARING|RUNNING|22/02/16 14:12|14:13:38|            Remaining 51/101|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 2

upg> Job 103 completed
Job 102 completed
------------------- Final Summary --------------------
Number of databases            [ 2 ]

Jobs finished                  [2]
Jobs failed                    [0]
Jobs pending                   [0]

Please check the summary report at:
/u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
[oracle@test-machine03 19c_dbupgrade]$

Fixup Mode

[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 19c_dbupgrade]$ java -jar autoupgrade.jar  -config 19c_config.cfg -mode fixups
AutoUpgrade is not fully tested on OpenJDK 64-Bit Server VM, Oracle recommends to use Java HotSpot(TM)
AutoUpgrade 21.3.211115 launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
2 databases will be processed
Type 'help' to list console commands
upg>
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
|Job#|DB_NAME|    STAGE|OPERATION|  STATUS|    START_TIME| UPDATED|                     MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
| 104|   orcl|PRECHECKS|PREPARING| RUNNING|22/02/16 14:24|14:24:26|Loading database information|
| 105| noncdb|    SETUP|PREPARING|FINISHED|22/02/16 14:24|14:24:24|                  Scheduling|
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
Total jobs 2

upg>  status -job 104
Progress
-----------------------------------
Start time:      22/02/16 14:24
Elapsed (min):   0
End time:        N/A
Last update:     2022-02-16T14:24:26.753
Stage:           PRECHECKS
Operation:       PREPARING
Status:          RUNNING
Pending stages:  2
Stage summary:
    SETUP             <1 min
    PRECHECKS         <1 min (IN PROGRESS)

Job Logs Locations
-----------------------------------
Logs Base:    /u01/19c_dbupgrade/autoupgrade/orcl
Job logs:     /u01/19c_dbupgrade/autoupgrade/orcl/104
Stage logs:   /u01/19c_dbupgrade/autoupgrade/orcl/104/prechecks
TimeZone:     /u01/19c_dbupgrade/autoupgrade/orcl/temp

Additional information
-----------------------------------
Details:
Checks

Error Details:
None

upg>
upg>   status -job 105
Progress
-----------------------------------
Start time:      22/02/16 14:24
Elapsed (min):   0
End time:        N/A
Last update:     2022-02-16T14:24:46.931
Stage:           PREFIXUPS
Operation:       EXECUTING
Status:          RUNNING
Pending stages:  1
Stage summary:
    SETUP             <1 min
    PRECHECKS         <1 min
    PREFIXUPS         <1 min (IN PROGRESS)

Job Logs Locations
-----------------------------------
Logs Base:    /u01/19c_dbupgrade/autoupgrade/noncdb
Job logs:     /u01/19c_dbupgrade/autoupgrade/noncdb/105
Stage logs:   /u01/19c_dbupgrade/autoupgrade/noncdb/105/prefixups
TimeZone:     /u01/19c_dbupgrade/autoupgrade/noncdb/temp

Additional information
-----------------------------------
Details:
+--------+---------------------+-------+
|DATABASE|                FIXUP| STATUS|
+--------+---------------------+-------+
|  noncdb|INVALID_OBJECTS_EXIST|STARTED|
+--------+---------------------+-------+

Error Details:
None

upg>  lsj
+----+-------+---------+---------+-------+--------------+--------+-----------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME| UPDATED|          MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
| 104|   orcl|PRECHECKS|PREPARING|RUNNING|22/02/16 14:24|14:24:54|Remaining 176/251|
| 105| noncdb|PREFIXUPS|EXECUTING|RUNNING|22/02/16 14:24|14:24:46|    Remaining 3/3|
+----+-------+---------+---------+-------+--------------+--------+-----------------+
Total jobs 2

upg>
upg>  lsj
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
|Job#|DB_NAME|    STAGE|OPERATION| STATUS|    START_TIME| UPDATED|                     MESSAGE|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
| 104|   orcl|PREFIXUPS|EXECUTING|RUNNING|22/02/16 14:24|14:28:02|               Remaining 5/6|
| 105| noncdb|PREFIXUPS|EXECUTING|RUNNING|22/02/16 14:24|14:27:24|Loading database information|
+----+-------+---------+---------+-------+--------------+--------+----------------------------+
Total jobs 2

upg> Job 105 completed

upg>  lsj
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
|Job#|DB_NAME|    STAGE|OPERATION|  STATUS|    START_TIME| UPDATED|                     MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
| 104|   orcl|PREFIXUPS|EXECUTING| RUNNING|22/02/16 14:24|14:30:04|Loading database information|
| 105| noncdb|PREFIXUPS|  STOPPED|FINISHED|22/02/16 14:24|14:28:50|Loading database information|
+----+-------+---------+---------+--------+--------------+--------+----------------------------+
Total jobs 2

upg> Job 104 completed
------------------- Final Summary --------------------
Number of databases            [ 2 ]

Jobs finished                  [2]
Jobs failed                    [0]
Jobs pending                   [0]

Please check the summary report at:
/u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
[oracle@test-machine03 19c_dbupgrade]$

Deploy Mode

[oracle@test-machine03 19c_dbupgrade]$ 
[oracle@test-machine03 19c_dbupgrade]$ java -jar autoupgrade.jar  -config 19c_config.cfg -mode deploy
AutoUpgrade is not fully tested on OpenJDK 64-Bit Server VM, Oracle recommends to use Java HotSpot(TM)
AutoUpgrade 21.3.211115 launched with default options
Processing config file ...
+--------------------------------+
| Starting AutoUpgrade execution |
+--------------------------------+
2 databases will be processed
Type 'help' to list console commands
upg>
upg> lsj
+----+-------+---------+---------+--------+--------------+--------+----------+
|Job#|DB_NAME|    STAGE|OPERATION|  STATUS|    START_TIME| UPDATED|   MESSAGE|
+----+-------+---------+---------+--------+--------------+--------+----------+
| 106|   orcl|PRECHECKS|PREPARING|FINISHED|22/02/16 14:41|14:41:24|          |
| 107| noncdb|    SETUP|PREPARING|FINISHED|22/02/16 14:42|14:41:20|Scheduling|
+----+-------+---------+---------+--------+--------------+--------+----------+
Total jobs 2

upg>
upg>
upg>  lsj
+----+-------+----------+---------+-------+--------------+--------+------------------+
|Job#|DB_NAME|     STAGE|OPERATION| STATUS|    START_TIME| UPDATED|           MESSAGE|
+----+-------+----------+---------+-------+--------------+--------+------------------+
| 106|   orcl| DBUPGRADE|EXECUTING|RUNNING|22/02/16 14:41|15:45:33|0%Upgraded ORCLPDB|
| 107| noncdb|POSTFIXUPS|EXECUTING|RUNNING|22/02/16 14:42|15:46:17|     Remaining 4/4|
+----+-------+----------+---------+-------+--------------+--------+------------------+
Total jobs 2

upg> Job 107 completed

upg>  lsj
+----+-------+----------+---------+--------+--------------+--------+-----------------+
|Job#|DB_NAME|     STAGE|OPERATION|  STATUS|    START_TIME| UPDATED|          MESSAGE|
+----+-------+----------+---------+--------+--------------+--------+-----------------+
| 106|   orcl|POSTFIXUPS|EXECUTING| RUNNING|22/02/16 14:41|16:47:19|   Remaining 3/12|
| 107| noncdb|SYSUPDATES|  STOPPED|FINISHED|22/02/16 14:42|16:10:13|Completed job 107|
+----+-------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2

upg>
upg> lsj
+----+-------+----------+---------+--------+--------------+--------+-----------------+
|Job#|DB_NAME|     STAGE|OPERATION|  STATUS|    START_TIME| UPDATED|          MESSAGE|
+----+-------+----------+---------+--------+--------------+--------+-----------------+
| 106|   orcl|SYSUPDATES|PREPARING| RUNNING|22/02/16 14:41|16:54:08|                 |
| 107| noncdb|SYSUPDATES|  STOPPED|FINISHED|22/02/16 14:42|16:10:13|Completed job 107|
+----+-------+----------+---------+--------+--------------+--------+-----------------+
Total jobs 2

upg> Job 106 completed
------------------- Final Summary --------------------
Number of databases            [ 2 ]

Jobs finished                  [2]
Jobs failed                    [0]
Jobs pending                   [0]

---- Drop GRP at your convenience once you consider it is no longer needed ----
Drop GRP from noncdb: drop restore point AUTOUPGRADE_9212_NONCDB122010
Drop GRP from orcl: drop restore point AUTOUPGRADE_9212_ORCL122010


Please check the summary report at:
/u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto/status/status.html
/u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto/status/status.log
[oracle@test-machine03 19c_dbupgrade]$

[oracle@test-machine03 fra]$
[oracle@test-machine03 fra]$ cd /u01/19c_dbupgrade/autoupgrade/cfgtoollogs/upgrade/auto
[oracle@test-machine03 19c_dbupgrade]$
[oracle@test-machine03 auto]$ ls -l
total 1372
-rwx------. 1 oracle oinstall    672 Feb 16 14:41 autoupgrade_err.log
-rwx------. 1 oracle oinstall      0 Feb 16 14:41 autoupgrade_err.log.lck
-rwx------. 1 oracle oinstall 927188 Feb 16 14:46 autoupgrade.log
-rwx------. 1 oracle oinstall      0 Feb 16 14:41 autoupgrade.log.lck
-rwx------. 1 oracle oinstall   3752 Feb 16 14:41 autoupgrade_user.log
-rwx------. 1 oracle oinstall      0 Feb 16 14:41 autoupgrade_user.log.lck
drwx------. 2 oracle oinstall   4096 Feb 16 14:41 config_files
drwx------. 2 oracle oinstall     18 Feb 16 14:41 lock
drwx------. 2 oracle oinstall     23 Feb 16 14:41 sql
-rwx------. 1 oracle oinstall  11932 Feb 16 14:46 state.html
drwx------. 2 oracle oinstall   4096 Feb 16 14:44 status
[oracle@test-machine03 auto]$  python -m SimpleHTTPServer 8080
Serving HTTP on 0.0.0.0 port 8080 ...
192.168.114.169 - - [16/Feb/2022 14:47:22] "GET /state.html HTTP/1.1" 200 -
192.168.114.169 - - [16/Feb/2022 14:47:23] code 404, message File not found
192.168.114.169 - - [16/Feb/2022 14:47:23] "GET /favicon.ico HTTP/1.1" 404 -


Step 8. Validate DB upgrade to 19.14: Validate components in the upgraded database and all components should be in valid status.

[oracle@test-machine03 auto]$
[oracle@test-machine03 auto]$ cat /etc/oratab
#
orcl:/u01/app/oracle/product/19.0/db_1:N
noncdb:/u01/app/oracle/product/19.0/db_1:N              # line added by Agent
+ASM:/u01/app/19.0/grid:N               # line added by Agent
[oracle@test-machine03 auto]$

[oracle@test-machine03 auto]$
[oracle@test-machine03 auto]$ cd /u01/app/oracle/product/19.0/db_1/dbs
[oracle@test-machine03 dbs]$ ls -l
total 28
-rw-rw----. 1 oracle asmadmin 1544 Feb 16 16:10 hc_noncdb.dat
-rw-rw----. 1 oracle asmadmin 1544 Feb 16 16:54 hc_orcl.dat
-rw-r--r--. 1 oracle oinstall 3079 May 14  2015 init.ora
-rw-r-----. 1 oracle asmadmin   24 Feb 16 14:48 lkNONCDB
-rw-r-----. 1 oracle asmadmin   24 Feb 16 14:48 lkORCL
-rw-r-----. 1 oracle oinstall 3584 Feb 16 16:10 orapwnoncdb
-rw-r-----. 1 oracle oinstall 3584 Feb 16 16:54 orapworcl
[oracle@test-machine03 dbs]$

[oracle@test-machine03 auto]$ 
[oracle@test-machine03 auto]$ sqlplus sys as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 16 17:08:52 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2021, Oracle.  All rights reserved.

Enter password:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL>
SQL> show con_name

CON_NAME
------------------------------
CDB$ROOT
SQL>
SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ORCLPDB                        READ WRITE NO
SQL>

SET LINESIZE 500
SET PAGESIZE 1000
SET SERVEROUT ON
SET LONG 2000000
COLUMN action_time FORMAT A12
COLUMN action FORMAT A10
COLUMN patch_type FORMAT A10
COLUMN description FORMAT A32
COLUMN status FORMAT A10
COLUMN version FORMAT A10

select CON_ID,
TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,
PATCH_ID,
ACTION,
STATUS,
SOURCE_VERSION,
TARGET_VERSION,
DESCRIPTION
from CDB_REGISTRY_SQLPATCH
order by CON_ID, action_time, patch_id;

    CON_ID ACTION_TIME    PATCH_ID ACTION     STATUS     SOURCE_VERSION  TARGET_VERSION  DESCRIPTION
---------- ------------ ---------- ---------- ---------- --------------- --------------- --------------------------------
         1 2022-02-16     33515361 APPLY      SUCCESS    19.1.0.0.0      19.14.0.0.0     Database Release Update : 19.14.
                                                                                         0.0.220118 (33515361)

         3 2022-02-16     33515361 APPLY      SUCCESS    19.1.0.0.0      19.14.0.0.0     Database Release Update : 19.14.
                                                                                         0.0.220118 (33515361)



set lines 300
set pages 300
COL comp_id for a15
COL status for a10
COL version for a15
COL comp_name for a40
SELECT CON_ID,SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10) version, SUBSTR(comp_name,1,40) comp_name FROM cdb_registry;
    CON_ID COMP_ID         STATUS     VERSION         COMP_NAME
---------- --------------- ---------- --------------- ----------------------------------------
         3 CATALOG         VALID      19.0.0.0.0      Oracle Database Catalog Views
         3 CATPROC         VALID      19.0.0.0.0      Oracle Database Packages and Types
         3 RAC             OPTION OFF 19.0.0.0.0      Oracle Real Application Clusters
         3 XDB             VALID      19.0.0.0.0      Oracle XML Database
         3 OWM             VALID      19.0.0.0.0      Oracle Workspace Manager
         1 CATALOG         VALID      19.0.0.0.0      Oracle Database Catalog Views
         1 CATPROC         VALID      19.0.0.0.0      Oracle Database Packages and Types
         1 JAVAVM          VALID      19.0.0.0.0      JServer JAVA Virtual Machine
         1 XML             VALID      19.0.0.0.0      Oracle XDK
         1 CATJAVA         VALID      19.0.0.0.0      Oracle Database Java Packages
         1 APS             VALID      19.0.0.0.0      OLAP Analytic Workspace
         1 RAC             OPTION OFF 19.0.0.0.0      Oracle Real Application Clusters
         1 XDB             VALID      19.0.0.0.0      Oracle XML Database
         1 OWM             VALID      19.0.0.0.0      Oracle Workspace Manager
         1 CONTEXT         VALID      19.0.0.0.0      Oracle Text
         1 ORDIM           VALID      19.0.0.0.0      Oracle Multimedia
         1 SDO             VALID      19.0.0.0.0      Spatial
         1 XOQ             VALID      19.0.0.0.0      Oracle OLAP API
         1 APEX            VALID      5.0.4.00.1      Oracle Application Express

19 rows selected.

SQL>
SQL> set lines 300
SQL> select name, to_char(scn), time from v$restore_point;

NAME                                                                                                                             TO_CHAR(SCN)                             TIME
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------------------------------------------
AUTOUPGRADE_9212_ORCL122010                                                                                                      2625542                                  16-FEB-22 02.41.21.000000000 PM

SQL> drop restore point AUTOUPGRADE_9212_ORCL122010;

Restore point dropped.

SQL>


############################################ NonCDB DB #########################################


SET LINESIZE 500
SET PAGESIZE 1000
SET SERVEROUT ON
SET LONG 2000000
COLUMN action_time FORMAT A12
COLUMN action FORMAT A10
COLUMN patch_type FORMAT A10
COLUMN description FORMAT A32
COLUMN status FORMAT A10
COLUMN version FORMAT A10

select
TO_CHAR(action_time, 'YYYY-MM-DD') AS action_time,
PATCH_ID,
ACTION,
STATUS,
SOURCE_VERSION,
TARGET_VERSION,
DESCRIPTION
from DBA_REGISTRY_SQLPATCH
order by action_time, patch_id;

ACTION_TIME    PATCH_ID ACTION     STATUS     SOURCE_VERSION  TARGET_VERSION  DESCRIPTION
------------ ---------- ---------- ---------- --------------- --------------- --------------------------------
2022-02-16     33515361 APPLY      SUCCESS    19.1.0.0.0      19.14.0.0.0     Database Release Update : 19.14.
                                                                              0.0.220118 (33515361)


set lines 300
set pages 300
COL comp_id for a15
COL status for a10
COL version for a15
COL comp_name for a40
SELECT SUBSTR(comp_id,1,15) comp_id, status, SUBSTR(version,1,10) version, SUBSTR(comp_name,1,40) comp_name FROM dba_registry;
COMP_ID         STATUS     VERSION         COMP_NAME
--------------- ---------- --------------- ----------------------------------------
CATALOG         VALID      19.0.0.0.0      Oracle Database Catalog Views
CATPROC         VALID      19.0.0.0.0      Oracle Database Packages and Types
JAVAVM          VALID      19.0.0.0.0      JServer JAVA Virtual Machine
XML             VALID      19.0.0.0.0      Oracle XDK
CATJAVA         VALID      19.0.0.0.0      Oracle Database Java Packages
APS             VALID      19.0.0.0.0      OLAP Analytic Workspace
RAC             OPTION OFF 19.0.0.0.0      Oracle Real Application Clusters
XDB             VALID      19.0.0.0.0      Oracle XML Database
OWM             VALID      19.0.0.0.0      Oracle Workspace Manager
CONTEXT         VALID      19.0.0.0.0      Oracle Text
ORDIM           VALID      19.0.0.0.0      Oracle Multimedia
SDO             VALID      19.0.0.0.0      Spatial
XOQ             VALID      19.0.0.0.0      Oracle OLAP API
APEX            VALID      5.0.4.00.1      Oracle Application Express

SQL>
SQL> select name, to_char(scn), time from v$restore_point;

NAME                                                                                                                             TO_CHAR(SCN)                             TIME
-------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------- ---------------------------------------------------------------------------
AUTOUPGRADE_9212_NONCDB122010                                                                                                    1868179                                  16-FEB-22 02.42.42.000000000 PM

SQL>  drop restore point AUTOUPGRADE_9212_NONCDB122010;

Restore point dropped.

SQL>
SQL>


This document is just for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.


Hope so you like this article
!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to understand more about our pursuit.


Related Articles


Loading

How useful was this post?

Click on a star to rate it!

Average rating / 5. Vote count:

No votes so far! Be the first to rate this post.

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?

Jamsher Khan

Hello and welcome to DBsGuru,I’m Jamsher Khan working as Senior Oracle DBA based in KSA-Jeddah, I have working experience in Oracle DBA, SQL Server, MySql, PostgreSQL, Linux, Golden Gate, ODA.Thanks for the visits!Share Learn Grow!