This chapter contains the following sections:
Task 1: Review the Oracle Fusion Middleware Metadata Repository Database Requirements
Task 3: Upgrade the Database to a Version Supported by Oracle Fusion Middleware 11g
Task 5: Relocate the Database Datafiles, Control Files, and Log Files
The following sections contain information about supported database versions for Oracle Fusion Middleware Oracle Spatial GeoRaster component schemas:
Summary of the Database Requirements for Oracle Fusion Middleware 11g Release 1 (11.1.1)
Obtaining the Latest Oracle Application Server Database Requirements
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.
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).
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.
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:
Installing the Oracle Text Database Option (Required for Oracle Portal)
Determining Whether Your Database is a Seed Database or OracleAS RepCA Database
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.
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.
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:
Documentation Resources When Upgrading to Oracle Database 10g Release 2 (10.2.0.4)
Typical Upgrade Path 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:
Oracle Database Upgrade Guide in the Oracle Database 10g Release 2 (10.2) documentation library on the Oracle Technology Network (OTN):
http://www.oracle.com/pls/db102/homepage
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.
Section 5.3.5.1, "About Upgrading a 10g Seed Database 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)
The following sections provide information about upgrading your Oracle Application Server 10g database to Oracle Database 11g:
Documentation Resources When Upgrading to Oracle Database 11g
Typical Upgrade Path to the Latest Oracle Database 11g (11.1)
To upgrade your 10g Release 2 (10.1.2) or 10g (10.1.4) database to Oracle Database 11g, refer to the
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):
http://www.oracle.com/technology/documentation
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.
If your database is a seed database, then refer to Section 5.3.5.2, "About Upgrading a 10g Seed Database to Oracle Database 11g"
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)
Refer to the following sections for information specific to upgrading the seed database to a version supported by Oracle Fusion Middleware 11g.
About Upgrading a 10g Seed Database to Oracle Database 10g Release 2 (10.2.0.4)
Modifying the ias.properties File After Upgrading a Seed Database
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".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:
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):
http://www.oracle.com/technology/documentation/
Section 5.3.3, "Upgrading to Oracle Database 10g Release 2 (10.2.0.4)".
Note.376689.1 - Upgrading the Application Server 10g (10.1.2|10.1.4) Seeded Database from 10.1 to 10.2, which is available on My Oracle Support.
Refer to the following information before upgrading your Oracle Application Server 10g seed database to Oracle Database 11g:
Before you upgrade your Oracle Application Server 10g Release 2 (10.1.2) seed database to Oracle Database 11g:
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
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.
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.
After you upgrade a seed database to a supported version, perform the following steps:
Locate the following file in the Oracle Application Server Oracle home:
ORACLE_HOME/config/ias.properties
Open the ias.properties file in a text editor and locate the following entry:
InstallType = Infrastructure
Change the value of the InstallType
property to Infrastructure_ID
:
InstallType = Infrastructure_ID
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:
Connect to the OracleAS Metadata Repository database.
For example:
ORACLE_HOME/bin/sqlplus "connect / as sysdba"
When prompted, enter the SYS password.
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.
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/
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.