Upgrade Process
Learn about the sequence of tasks to upgrade an Oracle Database Classic Cloud Service (DBCS) Single Instance database on Oracle Cloud at Customer (OCC) 20.4 to Oracle Database 19c.
The following terms are used in the following tasks:
- SOURCE DB: The single instance database that needs to be upgraded to Oracle Database 19c. Valid SOURCE DB versions are DBCS 11g, 12.1, 12.2, or 18c only.
- TARGET DB: The upgraded single instance database.
Note:
If you encounter any issues while executing the below tasks, refer to the Problems with Single Instance Upgrades to Oracle Cloud Database 19c on OCC 20.4.Task 1: Take Full Backup of SOURCE DB
Execute the following steps on SOURCE DB:
Note:
Execute these steps using db tooling on the VM only. Do not run this step via the PSM user interface.Task 2: Provision SHELL DB Instance
Note:
- You can not provision the shell database from the PSM user interface. You have to use the PSM REST API only.
- The source database will be restored on this new database service. So, choose the shape and usable storage such that SOURCE DB can be fit in the shell database without any issues.
Task 3: Get the spfile handle, controlfile handle, tde wallet that contains the autologin wallet, and the dbid from SOURCE DB VM
Execute the following steps on SOURCE DB:
Task 4: Get Oracle Application Express (APEX) images directory from SOURCE DB
For SOURCE DB versions 12.1, 12.2, or 18c
Execute the following steps for SOURCE DB versions 12.1, 12.2, or 18c.
- Identify the PDB that has Oracle APEX
installed.
Command:
select name from V$PDBS p inner join CDB_REGISTRY c on p.con_id = c.con_id WHERE COMP_ID = 'APEX' ORDER BY c.CON_ID ASC; NAME
Sample Result:SQL> select name from V$PDBS p inner join CDB_REGISTRY c on p.con_id = c.con_id WHERE COMP_ID = 'APEX' ORDER BY c.CON_ID ASC; NAME ------------------------------ PDB1
- Change the session to the PDB where Oracle APEX is
installed.
Command:
alter session set container=pdb1;
Sample Result:SQL> alter session set container=pdb1; Session altered.
For SOURCE DB versions 11g, 12.1, 12.2, or 18c
Execute the following steps for all the SOURCE DB versions (11g, 12.1, 12.2, or 18c).
- Identify the version of Oracle APEX installed in SOURCE
DB.
Command:
SELECT VERSION FROM DBA_REGISTRY WHERE COMP_ID = 'APEX';
Sample Result:SQL> SELECT VERSION FROM DBA_REGISTRY WHERE COMP_ID = 'APEX'; VERSION ------------------------------ 18.1.0.00.45
- Create a tarball of the Oracle APEX
libraries.
Command:
tar -czvf apex.tar.gz <apex_version_seen_above>/
Sample Result:cd /u01/app/oracle/product/apex/ tar -czvf apex.tar.gz <apex_version_seen_above>/ Eg: tar -czvf apex.tar.gz 18.1.0.00.45/
- Copy the Oracle APEX tarball to the SHELL DB provisioned in the Task 2
above.
Command:
scp -i <private_key> apex.tar.gz oracle@<ip_address_of_target_db>:~/