This chapter describes how to upgrade your database to a supported version prior to upgrade.
This chapter contains the following sections:
Note:
When upgrading to 12c (12.1.3), your exiting database must be used for the upgrade. Do not create a new database.It is important that you review the very latest information on database requirements for Oracle Fusion Middleware before proceeding with your database upgrade. For more information, see the Certification Matrix for 12c (12.1.3).
The certification matrix and system requirements documents should be used in conjunction with each other to verify that your environment meets the necessary requirements for installation. The Oracle Fusion Middleware 12c software requirements included in this guide were accurate at the time this manual was published.
For the most up-to-date information about the specific Oracle and third-party database versions supported for Oracle Fusion Middleware 12c (12.1.3), as well as other important system requirements, see Section 2.14.1, "Verifying Certification and System Requirements".
Note:
The information provided in this chapter was accurate at time of publication. Always refer to the Oracle Fusion Middleware 12c Certifications Matrix for the latest information.Before running Upgrade Assistant, you should make sure that your database is up and running and that the schemas you want to upgrade are at versions that are supported for upgrade.
When the schemas are created in your database, RCU creates and maintains a table called schema_version_registry. This table contains schema information such as version number, component name and ID, date of creation and modification, and custom prefix.
If you are using an Oracle database, connect to the database as SYS and run the following from SQL*Plus to get the current version numbers:
SET LINE 120 COLUMN MRC_NAME FORMAT A14 COLUMN COMP_ID FORMAT A20 COLUMN VERSION FORMAT A12 COLUMN STATUS FORMAT A9 COLUMN UPGRADED FORMAT A8 SELECT MRC_NAME, COMP_ID, OWNER, VERSION, STATUS, UPGRADED FROM SCHEMA_VERSION_REGISTRY ORDER BY MRC_NAME, COMP_ID ;
If the number in the ”VERSION” matches the version number mentioned in Table 1-1 of Oracle Fusion Middleware Upgrading with the Upgrade Assistant and the STATUS column is 'VALID', then the schema is supported for upgrade.
CAUTION:
Only the Repository Creation Utility and Upgrade Assistant should modify the contents of the schema version registry table.Users should not issue any INSERT, UPDATE, DELETE, GRANT or ALTER TABLE statements against the schema version registry with interactive SQL statements or scripts.
Checking for Invalid Database Objects
If you are using an Oracle database, you should recompile database objects before running the Upgrade Assistant to check for invalid objects before the upgrade. Connect to the database as SYS and run the following from SQL*Plus:
SELECT owner, object_name FROM all_objects WHERE status='INVALID';
Take note of any invalid objects and run the following query for more information. The existence of invalid database objects may prevent the upgrade from completing successfully.
/rdbms/admin/utlrp.sql
To recompile just the objects that belong to a single Oracle Fusion Middleware schema, you can use the Oracle Database stored procedure dbms_utility.compile_schema as shown in the example below:
SQL> execute
dbms_utility.compile_schema('1213_IAU');
PL/SQL procedure successfully completed
Note:
These procedures should be used again after running the Upgrade Assistant for verification.The path that you must take to upgrade to a new Oracle Database release depends on the release number of your current database. It might not be possible to directly upgrade from your current release of Oracle Database to the latest release. Depending on your current release, you might be required to upgrade through one or more intermediate releases to upgrade to the new Oracle Database.
For example, if the current database is running release 9i, then follow these steps:
Upgrade release 9.0.1.4 to release 10.2.0.4 using the instructions in Oracle Database Upgrade Guide Release 2 (10.2).
Upgrade release 10.2.0.4 to the new Oracle Database 11g release using the instructions in Oracle Database Upgrade Guide.
Table 4-1 contains the required upgrade path for each release of Oracle Database. Use the upgrade path and the specified documentation to upgrade your database. The information provided below was accurate at time of publication. Always refer to the Oracle Fusion Middleware 12c Certifications Matrix for the latest information.
Table 4-1 Supported Upgrade Paths for Upgrading Oracle Database
| Current Release | Upgrade Path |
|---|---|
|
9.0.1.3 (or earlier) |
Direct upgrade is not supported. Upgrade to an intermediate Oracle Database release before you can upgrade to the new Oracle Database 11g release, as follows:
When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release's documentation. Then, upgrade the intermediate release database to the new Oracle Database 11g release using the instructions in "Upgrading to the New Release of Oracle Database" in Oracle Database Upgrade Guide. |
|
9.2.0.8 10.1.0.5 10.2.0.2 11.1.0.6 12.1.0.1 |
Direct upgrade to Oracle Database 11g release is supported from 9.2.0.8 or higher, 10.1.0.5 or higher, 10.2.0.2 or higher, and 11.1.0.6 or higher. For release 9.2.0.3, you must first upgrade to an intermediate Oracle Database release, as follows: 9.2.0.3 (or earlier) -> 9.2.0.8 -> 11.1.0.7 9.2.0.3 (or earlier) -> 9.2.0.8 -> 11.2 To upgrade to a new Oracle Database release, follow the instructions in "Upgrading to the New Release of Oracle Database" in Oracle Database Upgrade Guide. |
Potential interoperability and upgrade issues can be avoided by making sure you have applied the latest patch sets, and that you have reviewed the list of recommended patches that are designed to help you avoid any problems during upgrade.
For more information, see the Upgrade chapter of the Release Notes for your platform. For example, if you are using a Linux operating system, refer to "Patches Required to Address Specific Upgrade and Compatibility Requirements" in the Oracle Fusion Middleware Release Notes for Linux x86.
For additional information about database patching requirements, see "Review System Requirements and Specifications" in the Oracle Fusion Middleware Planning an Installation of Oracle Fusion Middleware.