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.
- Execute the following command to take a backup of the
spfilein TARGET DB.
SQL> create pfile='<backup_path_for_pfile>' from spfile;Example:
SQL> create pfile='/path/to/backup.ora' from spfile;
- Update any
init paramsfrom SOURCE DB to TARGET DB, if required.
SQL> alter system set <parameter>=<value> SCOPE = BOTH;
- Bounce TARGET DB.
SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP;