5 Upgrading and Preparing Your Databases

This chapter contains the following sections:

5.1 Task 1: Review the Oracle Fusion Middleware Metadata Repository Database Requirements

The following sections contain information about supported database versions for Oracle Fusion Middleware Oracle Spatial GeoRaster component schemas:

5.1.1 Summary of the Database Requirements for Oracle Fusion Middleware 11g Release 1 (11.1.1)

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 Section 5.1.2, "Obtaining the Latest Oracle Application Server Database Requirements".

At the time this guide was published, Oracle Fusion Middleware 11g supported the following minimum Oracle database versions. As a result, before you upgrade your Oracle Application Server 10g environment to Oracle Fusion Middleware 11g, you must first upgrade your Oracle database to one of these versions:

  • Oracle Database 10g Release 2 (10.2.0.4) or later

  • Oracle Database 11g Release 1 (11.1.0.7) or later

  • Oracle Database 11g Release 2 (11.2.0.1.0) or later

Note that in addition to the Oracle database versions listed here, the Oracle WebCenter Content also supports the Microsoft SQL Server and IBM DB2 databases. For more information, see the Oracle Fusion Middleware Upgrade Guide for Oracle WebCenter Content.

5.1.2 Obtaining the Latest Oracle Application Server Database Requirements

The Oracle Fusion Middleware 11g 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 database versions supported for Oracle Fusion Middleware 11g, as well as other important system requirements, see the Oracle Fusion Middleware System Requirements and Specifications on the Oracle Technology Network (OTN).

5.2 Task 2: Determine Your Current Database Version

Before you review the procedures in this chapter, you must first be sure you have identified the version of the database that currently hosts your schemas.

To determine the version of your Oracle database, query the PRODUCT_COMPONENT_VERSION view, as follows:

prompt> sqlplus "sys/password as sysdba"
SQL> SELECT version FROM v$instance;

In this example, replace password with the password for the SYS database user.

To determine the version of your third-party database, refer to your third-party database documentation.

5.3 Task 3: Upgrade the Database to a Version Supported by Oracle Fusion Middleware 11g

If you determine that the database version you are currently using is not supported by Oracle Fusion Middleware, then you must upgrade your database to a supported version.

If you are using a supported third-party database, such as IBM DB2, then refer to your third-party database documentation for information on upgrading your database.

The following sections summarize how to upgrade your Oracle database to a version supported by Oracle Fusion Middleware 11g:

5.3.1 Installing the Oracle Text Database Option (Required for Oracle Portal)

When you upgrade your Oracle database to a supported version for Oracle Fusion Middleware 11g, note that if you are using Oracle Portal, then you must be sure that the Oracle Text database option is installed and configured as part of the database upgrade process.

Specifically:

  • If you are upgrading to Oracle Database 10g Release 2 (10.2.0.4), then you must install the Oracle Text option from the Oracle Database Companion CD-ROM after you install 10g Release 2 (10.2.0.1) and before you apply the Oracle Database 10g Release 2 (10.2.0.4) patch set.

    For more information, refer to the Oracle Database 10g installation documentation.

  • If you are upgrading to Oracle Database 11g (11.1.0.7), then you must install Oracle Text from the Oracle Database Example CD-ROM after you install Oracle Database 11g (11.1.0.1) and before you apply the Oracle Database 11g (11.1.0.7) patch set.

    For more information, refer to the Oracle Database 11g installation documentation.

5.3.2 Determining Whether Your Database is a Seed Database or OracleAS RepCA Database

As you begin the upgrade process, it is important to know how your OracleAS Metadata Repository was installed into your database. Specifically, consider the following to determine the type of OracleAS Metadata Repository database you are upgrading. Each type of OracleAS Metadata Repository database is upgraded differently:

  • If you used the Oracle Application Server installation procedure to create a new database for the OracleAS Metadata Repository, refer to the information in this section for information about upgrading the seed database to one supported by Oracle Fusion Middleware 11g.

    This type of database is referred to as a seed database, because the database was created automatically by the Oracle Application Server installation procedure specifically for hosting the OracleAS Metadata Repository.

    If you created the seed database with 10g Release 2 (10.1.2), then the database is initially Oracle Database 10g (10.1.0.4). If you then apply the 10g Release 2 (10.1.2.3) patch set, then the database is upgraded to Oracle Database 10g (10.1.0.5).

    If you created the Metadata Repository using Oracle Identity Management 10g (10.1.4), then the database version will be Oracle Database 10g (10.1.0.5).

  • If you used OracleAS Metadata Repository Creation Utility to install the OracleAS Metadata Repository in an existing database, you must upgrade the database using the standard database upgrade instructions. For more information, see Section 5.3.3, "Upgrading to Oracle Database 10g Release 2 (10.2.0.4)" or Section 5.3.4, "Upgrading to Oracle Database 11g".

    This type of OracleAS Metadata Repository database is referred to as an OracleAS RepCA database, because you used OracleAS RepCA (the Metadata Repository Creation Assistant) to install the repository in an existing database that you installed and configured yourself.

5.3.3 Upgrading to Oracle Database 10g Release 2 (10.2.0.4)

For information about upgrading your Oracle Application Server to Oracle Database Oracle Database 10g Release 2 (10.2.0.4), refere to the following sections:

5.3.3.1 Documentation Resources When Upgrading to Oracle Database 10g Release 2 (10.2.0.4)

For complete instructions for upgrading to the latest version of Oracle Database 10g Release 2 (10.2), refer to the following:

5.3.3.2 Typical Upgrade Path to Oracle Database 10g Release 2 (10.2.0.4)

For the purposes of this guide, Figure 5-1 provides a summary of the steps you will likely have to take to upgrade to Oracle Database 10g Release 2 (10.2.0.4).

This example is designed to serve as an example only. Refer to the database documentation for specific instructions.

Figure 5-1 Typical Upgrade Path to Oracle Database 10g Release 2 (10.2.0.4)

Description of Figure 5-1 follows
Description of "Figure 5-1 Typical Upgrade Path to Oracle Database 10g Release 2 (10.2.0.4)"

5.3.4 Upgrading to Oracle Database 11g

The following sections provide information about upgrading your Oracle Application Server 10g database to Oracle Database 11g:

5.3.4.1 Documentation Resources When Upgrading to Oracle Database 11g

To upgrade your 10g Release 2 (10.1.2) or 10g (10.1.4) database to Oracle Database 11g, refer to the

5.3.4.2 Typical Upgrade Path to the Latest Oracle Database 11g (11.1)

Figure 5-1 provides a summary of the steps you will likely have to take to upgrade to Oracle Database 11g Release 1 (11.1.0.7).

Note that this illustration is a summary of the steps that are likely required to upgrade to Oracle Database 11g. This is provided as an example only. For more specific information, refer to the resources listed in Section 5.3.4.1, "Documentation Resources When Upgrading to Oracle Database 11g".

Figure 5-2 Typical Upgrade Path to Oracle Database 11g Release 1 (11.1.0.7)

Description of Figure 5-2 follows
Description of "Figure 5-2 Typical Upgrade Path to Oracle Database 11g Release 1 (11.1.0.7)"

5.3.5 Upgrading an Oracle Application Server 10g Seed Database

Refer to the following sections for information specific to upgrading the seed database to a version supported by Oracle Fusion Middleware 11g.

Note:

The instructions in this section apply only to seed databases and not to OracleAS RepCA databases. For more information, see Section 5.3.2, "Determining Whether Your Database is a Seed Database or OracleAS RepCA Database".

5.3.5.1 About Upgrading a 10g Seed Database to Oracle Database 10g Release 2 (10.2.0.4)

When you upgrade your Oracle Application Server 10g seed database to Oracle Database 10g Release 2 (10.2.0.4), refer to the following documentation resources for more information:

5.3.5.2 About Upgrading a 10g Seed Database to Oracle Database 11g

Refer to the following information before upgrading your Oracle Application Server 10g seed database to Oracle Database 11g:

5.3.5.2.1 Oracle Database 11g Considerations for Oracle Application Server 10g Release 2 (10.1.2) Users

Before you upgrade your Oracle Application Server 10g Release 2 (10.1.2) seed database to Oracle Database 11g:

  1. If you are using Oracle Portal, then upgrade to Oracle Portal 10g (10.1.4).

    For more information, see the information available on the Oracle Portal Upgrade page on the Oracle Technology Network (OTN):

    http://www.oracle.com/technology/products/ias/portal/upgrade.html

  2. Apply the Oracle Application Server 10g Release 2 (10.1.2.3) patch set to your Oracle Application Server environment.

    This patch set is especially important if you are using Oracle Portal or Oracle Internet Directory as part of your 10g Release 2 (10.1.2) environmement.

    You can download the patch set (patch set number 5983622) from My Oracle Support.

5.3.5.2.2 Oracle Database 11g Considerations for Oracle Application Server 10g (10.1.4) Identity Management instance Users

Before you upgrade your 10g (10.1.4) seed database to Oracle Database 11g, be sure to apply the Oracle Application Server 10g (10.1.4.3) patch set.

You can download the patch set (patch set number 7215628) from My Oracle Support.

5.3.5.3 Modifying the ias.properties File After Upgrading a Seed Database

After you upgrade a seed database to a supported version, perform the following steps:

  1. Locate the following file in the Oracle Application Server Oracle home:

    ORACLE_HOME/config/ias.properties

  2. Open the ias.properties file in a text editor and locate the following entry:

    InstallType = Infrastructure

  3. Change the value of the InstallType property to Infrastructure_ID:

    InstallType = Infrastructure_ID

5.4 Task 4: Check for Invalid Objects in the Upgraded Database

Before you upgrade the schemas in your database, it is good practice to check to make sure that none of the database objects required by Oracle Fusion Middleware are invalid:

  1. Connect to the OracleAS Metadata Repository database.

    For example:

    ORACLE_HOME/bin/sqlplus "connect / as sysdba"

  2. When prompted, enter the SYS password.

  3. Issue the following SQL command:

    SELECT owner, object_type, object_name
         FROM all_objects
         WHERE status='INVALID';

    The query should not return any database objects that have an Oracle Application Server component schema (such as PORTAL, WIRELESS, and so on) in the 'owner' column.

If you find any invalid objects, run the utlrp.sql script from the SQL*Plus command line to recompile the invalid objects:

@?/rdbms/admin/utlrp.sql

For more information about invalid objects, see "About Dependencies Among Schema Objects" in the Oracle Database Administrator's Guide.

5.5 Task 5: Relocate the Database Datafiles, Control Files, and Log Files

By default, after you upgrade your database, the datafiles, control files, and log files associated with the database remain in their original location. For example, if you previously used Oracle Application Server 10g installer to upgrade a Metadata Repository seed database, the datafiles for the Metadata Repository database remain in the source Oracle home.

As a result, Oracle recommends that if you have not done so already, you relocate these files as a safeguard against inadvertently deleting them (for example, by deleting or decommissioning the entire source Oracle home directory tree). In addition, there may be performance benefits to moving the database files outside of the source Oracle home.

For more information, refer to "Renaming and Relocating Datafiles" in the Oracle Database Administrator's Guide. The documentation library for your version of the Oracle Database can be found on the Oracle Technology Network (OTN):

http://www.oracle.com/technology/documentation/

5.6 Task 6: Determine Whether Any Additional Database Patches Are Required for Upgrade to Oracle Fusion Middleware 11g

Potential interoperability and upgrade issues can be avoided by making sure you have applied the latest Oracle Application Server 10g 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 Installation Planning Guide.