Post Upgrade Tasks

This topic lists the tasks to be performed after upgrading a single instance database on Oracle Cloud at Customer (OCC) 20.4 to Oracle Database Cloud Classic Service (DBCS) 19c successfully.

Note:

These tasks are optional. Execute them as needed.

1. Execute the following command to take a backup of the spfile in TARGET DB.

   SQL> create pfile='<backup_path_for_pfile>' from spfile;

   Example:

   SQL> create pfile='/path/to/backup.ora' from spfile;

2. Update any init params from SOURCE DB to TARGET DB, if required.

   SQL> alter system set <parameter>=<value> SCOPE = BOTH;

3. Bounce TARGET DB.

   SQL> SHUTDOWN IMMEDIATE;
   SQL> STARTUP;