1. Administering Oracle Database Classic Cloud Service
  2. Upgrading Single Instance Database to Oracle Database 19c in the Cloud
  3. Upgrade Validation

Upgrade Validation

This topic details how to validate if TARGET DB is upgraded to Oracle Database 19c successfully.

Execute the following commands from TARGET DB:
  1. Check the database status using dbaascli.
    [root@targetdbhost oracle]# dbaascli database status --dbname <dbname>
    Sample Result:
    DBAAS CLI version 19.1.1.1.0
Executing command database status
Database Status:
Database is open
Database name: ORCL
  
  
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
  2. Perform validations to make sure database is upgraded successfully.

    Note:

    Execute the following commands using db tooling on the virtual machine (VM) only. Do not run this step via the PSM user interface.
    1. Command 1:
      [root@targetdbhost oracle]# grep ORCL /etc/oratab
      Sample Result:
      ORCL:/u01/app/oracle/product/19.0.0.0/dbhome_1:Y
    2. Command 2:
      [root@targetdbhost oracle]# grep 19 /var/opt/oracle/creg/ORCL.ini
      Sample Result:
      db_home=/u01/app/oracle/product/19.0.0.0/dbhome_1
full_version=19.8.0.0.0
ibkp_rman_tag=JAAS20201205T194812
netsec_server_encryption_methods=AES256,AES192,AES128
ohome_name=OraDB19Home1
oracle_home=/u01/app/oracle/product/19.0.0.0/dbhome_1
tns_admin=/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin/ORCL
version=19000
    3. Command 3:
      [root@targetdbhost oracle]# grep 18 creg/ORCL.ini
      Sample Result:
      bkup_oss_url=https://example.com/v1/Storage-spavanaccount1/dbcs-targetdbhost
cloud_domain=500128980.us18.internal
createTime=18-JUL-18
db_img=/scratch/db/db18000_eebits.tar.gz
dbdns=targetdbhost
domain=500128980.us18.internal
hostname=targetdbhost.compute-500128980.us18.internal
ibkp_oss_url=https://example.com/v1/Storage-spavanaccount1/dbcs-new-18c-2-clone-2
ibkp_src_domain=500128980.us18.internal
ibkp_src_version=1800
opc_oss_url=https://example.com/v1/Storage-spavanaccount1
orig_oracle_home=/u01/app/oracle/product/18.0.0/dbhome_1
ossStorageUri=http://provision.us18.internal:8920
oss_base=dbcs-targetdbhost
oss_url=https://example.com/v1/Storage-spavanaccount1/dbcs-targetdbhost
pdb_service_name=PDB1_srv.500128980.us18.internal
prev_domain=500128980.us18.internal
prev_service_name=ORCL.500128980.us18.internal
service_name=ORCL.500128980.us18.internal
upgrade_restore_point=BEFORE#UPGRADE#5418641687461321453#
    4. Command 4:
      [root@targetdbhost oracle]# su oracle
[oracle@targetdbhost oracle]$ grep 19 ~/.bashrc
      Sample Result:
      ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1; export ORACLE_HOME
OH=/u01/app/oracle/product/19.0.0.0/dbhome_1; export OH
PATH=/sbin:/bin:/usr/sbin:/usr/bin:/u01/app/oracle/product/19.0.0.0/dbhome_1/bin:/u01/app/oracle/product/19.0.0.0/dbhome_1/OPatch; export PATH
LD_LIBRARY_PATH=/u01/app/oracle/product/19.0.0.0/dbhome_1/lib; export LD_LIBRARY_PATH
TNS_ADMIN=/u01/app/oracle/product/19.0.0.0/dbhome_1/network/admin; export TNS_ADMIN
    5. Command 5:
      [oracle@targetdbhost oracle]$ grep 18 ~/.bashrc
      Sample Result:
      ORACLE_HOSTNAME=targetdbhost.compute-500128980.us18.internal; export ORACLE_HOSTNAME
    6. Command 6:
      [oracle@targetdbhost oracle]$ grep 18 ~/.bashrc
      Sample Result:
      ORACLE_HOSTNAME=targetdbhost.compute-500128980.us18.internal; export ORACLE_HOSTNAME
    7. Command 7:
      [oracle@targetdbhost oracle]$ sqlplus / as sysdba
      Sample Result:
      SQL*Plus: Release 19.0.0.0.0 - Production on Sun Dec 6 00:35:06 2020
Version 19.8.0.0.0
Copyright (c) 1982, 2020, Oracle.  All rights reserved.
Connected to:
Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
    8. Command 8:
      SQL> set heading off;
SQL> select name,dbid,open_mode from v$database;
      Sample Result:
      ORCL      1586161130 READ WRITE  
  
NOTE - "show pdbs" command will NOT return anything for upgrade from 11g to 19c
    9. Command 9:
      SQL> show pdbs;
      Sample Result:
      2 PDB$SEED           READ ONLY  NO
     3 PDB1               READ WRITE NO
    10. Command 10:
      SQL> select * from v$encryption_wallet
  2  ;
      Sample Result:
      FILE
/u01/app/oracle/admin/ORCL/tde_wallet/
OPEN                   AUTOLOGIN        SINGLE    NONE     NO
     1
FILE
OPEN                   AUTOLOGIN        SINGLE    UNITED   NO
     2
FILE
OPEN                   AUTOLOGIN        SINGLE    UNITED   NO
     3
    11. Command 11:
      SQL> select tablespace_name,encrypted from dba_tablespaces;
      Sample Result:
      SYSTEM                 NO
SYSAUX                 NO
UNDOTBS1               NO
TEMP                   NO
USERS                  YES
    12. Command 12:
      SQL> alter session set container=<pdb_name>;
      Sample Result:
      Session altered.
    13. Command 13:
      SQL>  select tablespace_name,encrypted from dba_tablespaces;
      Example Result:
      SYSTEM                 NO
SYSAUX                 NO
UNDOTBS1               NO
TEMP                   NO
USERS                  YES
    14. Command 14:
      SQL> exit
      Sample Result:
      Disconnected from Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
    15. Command 15:
      [oracle@targetdbhost oracle]$ exit
[root@targetdbhost oracle]# dbaascli dbhome info
      Sample Result:
      DBAAS CLI version 19.1.1.1.0
Executing command dbhome info
Enter a homename or just press enter if you want details of all homes
1.HOME_NAME=OraDB19Home1
  HOME_LOC=/u01/app/oracle/product/19.0.0.0/dbhome_1
  PATCH_LEVEL=19800_dbru200714
  DBs installed= ORCL
  OH Backup = NOT Configured
2.HOME_NAME=OraDB18Home1
  HOME_LOC=/u01/app/oracle/product/18.0.0/dbhome_1
  PATCH_LEVEL=181100_dbru200714
  DBs installed=
  OH Backup = NOT Configured