The specific information about upgrading your existing Oracle database to Oracle Database 12c Release 1 on Fujitsu BS2000/OSD systems is discussed in this chapter.
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 12c Release 1 as explained in “Oracle Database Installation and Deinstallation.”.This chapter describes upgrading a database from Oracle Database 11g Release 2 (11.2) to Oracle Database 12c Release 1 (12.1). 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
preupgrd.sql
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 needs to be fixed.preupgrd.sql
tool in the environment of the source database. For example in the Oracle Database 11g Release 2 environment. The database must be up and running. For running preupgrd.sql
, you must start SQL*Plus in the POSIX shell.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.This topic describes the new upgrade method using the catctl.pl
Perl script. As Perl is only supported on the POSIX environment, you must change to the POSIX shell for some of the following steps.
Note:
Earlier releases of Oracle Database used thecatupgrd.sql
upgrade utility to process the upgrade. Oracle strongly recommends that starting with Oracle Database 12c release, you use the catctl.pl
parallel upgrade utility. This replaces the catupgrd.sql
utility and provides both parallel processing mode and serial mode.You must complete the following tasks after upgrading to Oracle Database 12c Release 1:
Rebuilding Database Application Programs
All database application programs with Embedded SQL must be precompiled using the new precompilers of Oracle Database 12c Release 1. Then they must be recompiled and relinked using the new Oracle Database libraries.
All database application programs with Oracle Call Interface (OCI) must be recompiled and relinked using the new Oracle Database libraries.
All openUTM database applications must be rebuilt. Refer to the chapters on openUTM in this guide for more information.
Updating ORAENV Files
The ORAUID
environment variable must refer to the correct Oracle Database installation user ID and the ORACLE_HOME
environment variable must refer to the corresponding Oracle home directory in the POSIX file system. Check your ORAENV
files, and if necessary, update the value of the ORAUID
, ORACLE_BASE
, and ORACLE_HOME
environment variables. Also check other environment variables for any adjustments.
Migrating to Unified Auditing
Oracle Database 12c Release 1 supports Unified Auditing. After upgrading to Oracle Database 12c, 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