4 About Upgrading a Database
This chapter describes how to upgrade your existing database to Oracle Database 19c on Fujitsu BS2000. It gives you an overview about the steps required for the upgrade of a database and informs about actions, which are specific to the Fujitsu BS2000 platform.
Before you perform an upgrade, you must be familiar about upgrade preparation, space and backup requirements, release differences, handling TIMESTAMP WITH TIME ZONE
data type, and other database upgrade concepts.
It is assumed that you have correctly installed Oracle Database 19c as explained in “Oracle Database Installation and Deinstallation.”This chapter describes upgrading a database from Oracle Database 12c Release 2 (12.2) to Oracle Database 19c. The upgrade is done both in the normal BS2000 environment and in the POSIX shell. Oracle recommends that you be familiar with both these environments.
This chapter includes the following topics:
Related Topics
4.1 Performing Preupgrade Procedures
preupgrade.jar
Pre-Upgrade Information Tool from the
environment of the database that you want to upgrade. Running the Pre-Upgrade
Information Tool provides information about any issues that need to be fixed.
preupgrade.jar
tool in the environment of the
source database, for example, in the Oracle Database 12c Release 2 (12.2) environment.
The database must be up and running.
ORACLE_BASE
is defined, then the generated scripts and log files are created in the $ORACLE_BASE/cfgtoollogs
directory. If ORACLE_BASE
is not defined, then the generated scripts and log files are created in the $ORACLE_HOME/cfgtoollogs
directory.
4.2 Performing Upgrade Procedures
Use the upgrade utility, dbupgrade
to upgrade Oracle Database. As shell scripts and Perl scripts are supported only in the POSIX environment, you must change to the POSIX shell for performing some of the procedure.
The shell script dbupgrade
is a wrapper for the parallel upgrade
utility catctl.pl
, which is based on Perl.
All the steps in this phase must be performed in the new Oracle Database 19c environment. For some steps you have to change to the POSIX shell.
4.3 Performing Postupgrade Procedures
You must complete the following tasks after upgrading to Oracle Database 19c:
Gathering Statistics
Oracle recommends to gather dictionary statistics after upgrading the database. Execute the following SQL statement:
SQL> execute dbms_stats.gather_dictionary_stats;
After an upgrade Oracle strongly recommends that you regather fixed object statistics after you have run representative workloads. Execute the following SQL statement:
SQL> execute dbms_stats.gather_fixed_objects_stats;
Migrating to Unified Auditing
Oracle Database 19c supports Unified Auditing. After upgrading to Oracle Database 19c, the Unified Auditing option is not enabled.
See Also:
-
“About Unified Auditing” for more information about enabling Unified Auditing
-
Oracle Database Upgrade Guide for more information about migrating to Unified Auditing