The Oracle Fusion Middleware 11gsoftware requirements included in this guide were accurate at the time this manual was published.

For links to the most up-to-date information about software requirements, including the database versions required for Oracle Fusion Middleware 11g, refer to "System Requirements and Prerequisites" in the Oracle Fusion Middleware Installation Planning Guide.

6.2 Task 2: Determine Your Current Database Version

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.

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

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

When you upgrade your 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.

In particular, refer to the section, "Determine the Upgrade Path to the New Oracle Database 10g Release" in the Oracle Database 10g Release 2 (10.2.0.4) Oracle Database Upgrade Guide for specific information about upgrading from any supported Oracle Database version.

For the purposes of this guide, Figure 6-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).

Note:

Patch 5126270 is required before you begin the upgrade process; otherwise, the Database Upgrade Assistant may fail during the database upgrade. To obtain this patch, log in to My Oracle Support (formerly MetaLink), click Patches and Updates, and search for patch 5126270:

6.3.3.1 Documentation Resources When Upgrading to Oracle Database 11g

To upgrade your 10g Release 2 (10.1.2) or 10g (10.1.4) seed database to Oracle Database 11g, use the following resources:

The Oracle Database installation guide for your platform and the Oracle Database Upgrade Guide, which are available in the Oracle Database 11g documentation library on the Oracle Technology Network (OTN):

In particular, refer to the section, "Determine the Upgrade Path" in the Oracle Database 11g (11.1) Oracle Database Upgrade Guide for specific information about upgrading from any supported Oracle Database version.

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 likely an Oracle Database 10g (10.1.0.4) database. If you created the database with 10g (10.1.4), then the database is likely an Oracle Database 10g (10.1.0.5) database.

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

The Oracle Database installation guide for your platform and the Oracle Database Upgrade Guide, which are available in the Oracle Database 10g documentation library on the Oracle Technology Network (OTN):

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):

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.

Refer to the Oracle Fusion Middleware Release Notes for specific information about required patches that address specific interoperability and compatibility issues that surface during upgrade. The release notes for each release are available on the Oracle Technology Network (OTN):