Skip Headers
Oracle® Fusion Middleware Upgrade Guide for Oracle Forms and Reports
11g Release 2 (11.1.2)

Part Number E23975-01
Go to Documentation Home
Home
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

5 Upgrading from Oracle Forms and Reports 11g Release 1

Use this chapter to upgrade from Oracle Forms and Reports 11g Release 1 to Oracle Forms and Reports 11g Release 2.

For example, you can use this chapter to upgrade from Oracle Forms and Reports 11g Release 1 (11.1.1.5.0) to Oracle Forms and Reports 11g Release 2 (11.1.2).

5.1 Overview of Upgrading from Oracle Forms and Reports 11g Release 1 (11.1.1)

The following sections provide information you should know before performing the upgrade procedure:

5.1.1 Identifying the Source Oracle Instance and the Destination Oracle Instance When Upgrading from 11g Release 2 (11.1.2)

To upgrade from Oracle Forms and Reports 11g Release 1 (11.1.1) to Oracle Forms and Reports 11g Release 2 (11.1.2) involves running a script that will copy configuration information from your source 11g Release 1 (11.1.1) Oracle instance to your destination 11g Release 2 (11.1.2) Oracle instance:

5.1.2 Understanding the Tasks Performed by the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade Scripts

Before you run the script, you must enter some required information about the source and destination Oracle instances in a properties file. You can then run the script, perform any manual steps, and then verify the upgrade.

When you run the upgrade scripts, the scripts automatically do the following:

  • Uses the values you entered in the upgrade properties file to determine the location of the source and destination configuration files.

    For more information, see Section 5.2, "Locating and Editing the Oracle Forms and Reports Upgrade Properties File".

  • Backs up the destination Oracle Instance and the destination domain home, using the current date_time stamp as suffix.

    The scripts create the instance backup in the parent directory of destination Oracle instance directory. The scripts create the domain backup directory in the parent directory of Domain home directory.

  • Copies configuration files from the source location to the destination location.

  • Replaces references to the source paths in the configuration files with the destination paths.

  • Invokes any MBean operations or System calls required by each component.

  • Restarts the destination Oracle WebLogic Server domain servers and the Oracle instance.

5.2 Locating and Editing the Oracle Forms and Reports Upgrade Properties File

To locate and edit the Oracle Forms and Reports upgrade properties file:

  1. Change directory to the following directory in the Oracle Forms and Reports 11g Release 2 (11.1.2) Oracle home:

    (UNIX) ORACLE_HOME/upgrade/scripts/
    (Windows) ORACLE_HOME\upgrade\scripts\
    
  2. Use a text editor to open the following file:

    upgrade.properties
    
  3. Provide a value for each element in the properties file. Refer to Table 5-1 for a description of each element.

    Notes:

    • Elements with a prefix of "d_" identify the properties of the destination 11g Release 2 (11.1.2) software. Elements with a prefix of "s_" identify the properties of the source 11g Release 1 (11.1.1) software.

    • On the Windows platform, you must use a slash (/) as the delimiter if a directory path is required as a property value. For example:

      C:/Oracle/Middleware/Oracle_FRHome/
      
    • All the elements in the properties file are required.

  4. Save the file with the values you have entered.

Table 5-1 Description of the Elements in the upgrade.properties File

Element Description

d_fmw-home

The complete path to the Middleware home where the newly installed Oracle Forms and Reports 11g Release 2 (11.1.2) Oracle home has been installed.

d_admin-server-host

The name of the host computer of the Administration Server for the Oracle WebLogic Server domain where the new Oracle Forms and Reports 11g Release 2 (11.1.2) software has been configured.

Note that this value can be found in the following domain configuration file:

DOMAIN_HOME/config/config.xml

This value is typically defined in the HOSTNAME variable on UNIX systems or by the COMPUTERNAME variable on Windows systems.

d_hostname

The name of the host where Oracle Forms and Reports 11g Release 2 (11.1.2) was installed and configured.

In some scenarios, this host name is different from the host where the Administration Server is installed. For example, this can be the case if the domain has been extended to multiple hosts.

d_domain-home

The complete path to the domain home directory for the Oracle WebLogic Server domain where Oracle Forms and Reports 11g Release 2 (11.1.2) has been configured.

d_weblogic.username

The user name of the Oracle WebLogic Server Administration user. In most cases, this is the weblogic user.

d_weblogic.port

The Administration Server port for the Oracle WebLogic Server domain where Oracle Forms and Reports 11g Release 2 (11.1.2) has been configured. By default, this port is 7001.

d_oracle-home

The complete path to the Oracle Forms and Reports 11g Release 2 (11.1.2) Oracle home.

d_oracle-instance

The complete path to the Oracle Forms and Reports 11g Release 2 (11.1.2) Oracle instance directory.

s_fmw-home

The complete path to the Middleware home where the Oracle Forms and Reports 11g Release 1 (11.1.1) Oracle home is installed.

s_domain-home

The complete path to the Domain home for the Oracle WebLogic Server domain where Oracle Forms and Reports 11g Release 1 (11.1.1) was configured.

s_oracle-home

The complete path to the Oracle Forms and Reports 11g Release 1 (11.1.1) Oracle home.

s_oracle-instance

The complete path to the Oracle Forms and Reports 11g Release 1 (11.1.1) Oracle instance.

retain_source-ports

Specify true or false. Default setting is true.

If set to true, then the upgrade scripts configure the destination software to use the same ports as those used in the source Oracle home.

If set to false, then the upgrade scripts do not change any port values in the destination instance. As a result, they will use the values set during the Oracle Forms and Reports 11g Release 2 (11.1.2) installation and configuration.

Note: If your 11g Release 1 (11.1.1) instance contains Oracle Portal or Oracle Business Intelligence, then you must set this value to false if you want to continue using Oracle Portal and Oracle Business Intelligence after the upgrade. For more information, see Section 1.7, "About Using Oracle Portal and Oracle Business Intelligence Discoverer with Oracle Forms and Reports 11g Release 2 (11.1.2)".

This property is similar to the Use Source Oracle home ports in destination option in the Upgrade Assistant when you are upgrading from Oracle Forms and Reports 10g. For more information, see description of the Specify Upgrade Options screen in Table 4-1.


5.3 Performing the Oracle Forms and Reports 11g Release 1 (11.1.1) Upgrade

After you have entered the required values in the properties file, you can use the Oracle Forms and Reports 11g Release 2 (11.1.2) upgrade scripts to upgrade your 11g Release 1 (11.1.1) configuration settings to Oracle Forms and Reports 11g Release 2 (11.1.2):

  1. Stop the source Oracle instance and the Oracle WebLogic Server domain where the Oracle Forms and Reports 11g Release 1 (11.1.1) products have been configured:

    • To stop the Oracle instance, use the appropriate OPMN commands for your platform.

    • To stop the Oracle WebLogic Server domain, stop the managed servers and the Administration server, using the standard start and stop procedures for your domain.

    For more information, see "Starting and Stopping Oracle Fusion Middleware" in the Oracle Fusion Middleware Administrator's Guide.

  2. Make sure that the destination Oracle instance and the destination Oracle WebLogic Server domain are up and running.

    To verify that the instance and the domain are running, log in to the Oracle Enterprise Manager Fusion Middleware Control for the domain and verify that the managed servers and Oracle Forms and Reports components are running.

  3. Set the following environment variables:

    • PATH: Make sure that the Java Development Kit (JDK) and Apache Ant binaries are included in the PATH variable.

      Depending on the operating system and platform, the JDK installed with Oracle Forms and Reports is usually in one of the following locations:

      UNIX:

      DEST_MW_HOME/jdk160_24/bin
      DEST_ORACLE_HOME/jdk/bin
      

      Windows:

      DEST_MW_HOME\jdk160_24\bin
      DEST_ORACLE_HOME\jdk\bin
      

      The Apache Ant binaries are usually in the following location:

      (UNIX) DEST_MW_HOME/modules/org.apache.ant_1.7.1/bin
      (Windows) DEST_MW_HOME\modules\org.apache.ant_1.7.1\bin
      
    • JAVA_HOME: Depending on the operating system and platform, the JDK installed with Oracle Forms and Reports is usually in one of the following locations:

      UNIX:

      DEST_MW_HOME/jdk160_24/bin
      DEST_ORACLE_HOME/jdk/bin
      

      Windows:

      DEST_MW_HOME\jdk160_24\bin
      DEST_ORACLE_HOME\jdk\bin
      
    • CLASSPATH: Make sure the following is in the CLASSPATH variable:

      DEST_MW_HOME/wlserver_10.3/server/lib/weblogic.jar
      
  4. Change directory to the following directory in the Oracle Forms and Reports 11g Release 2 (11.1.2) Oracle home:

    (UNIX) DEST_ORACLE_HOME/upgrade/scripts/
    (Windows) DEST_ORACLE_HOME\upgrade\scripts\
    
  5. Enter the following command, which will run each of the required upgrade scripts:

    ant
    
  6. If any errors are generated during the upgrade, see Section 5.4, "Troubleshooting the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade".

5.4 Troubleshooting the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade

The following sections provide information you can use if you have problems with the upgrade from Oracle Forms and Reports 11g Release 1 (11.1.1):

5.4.1 Locating the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade Log Files

Each time you run the Oracle Forms and Reports upgrade scripts, the scripts generate a log file that you can use to troubleshoot the upgrade. The log file is written to the following directory in the destination Oracle home:

(UNIX) DEST_ORACLE_HOME/upgrade/logs/
(Windows) DEST_ORACLE_HOME\upgrade\logs\

The name of the log file uses the following format to help you identify which log file to review:

upgrade_date-time.log

For example:

upgrade_08-22-2011-12_10_30_PM.log

5.4.2 Locating the Automatic Backup of the Destination Oracle Instance

Each time you run the upgrade scripts, the scripts make a complete backup copy of the destination Oracle instance directory.

The directory is created in the same directory where the original Oracle instance resides. The name of the directory uses the following format to help you identify the backup directory:

instance_name.preUpgrade_date-time

For example:

forms_reports_1112_instance1.preUpgrade_08-22-2011-12_10_30_PM

If you need to restore your Oracle Instance after a failed upgrade attempt, you can obtain the backed up files from this location.

5.4.3 Re-Running the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade Scripts

If you have problems upgrading your environment, you can review the log files and then re-run the upgrade scripts. To re-run the upgrade scripts:

  1. Verify that the values in the properties file are set correctly, as described in Section 5.2, "Locating and Editing the Oracle Forms and Reports Upgrade Properties File".

  2. Run the scripts again, as described in Section 5.3, "Performing the Oracle Forms and Reports 11g Release 1 (11.1.1) Upgrade".

5.5 Performing any Post-Upgrade Manual Steps

Refer to Chapter 6, "Post-Upgrade Tasks After Upgrading to Oracle Forms and Reports 11g Release 2 (11.1.2)" for a description of the post-upgrade tasks you might need to perform for each of the Oracle Forms and Reports components.

5.6 Verifying a Successful Upgrade

To verify a successful upgrade:

  1. Use your browser to navigate to the Fusion Middleware Control home page:

    http://hostname:port/em
    

    For more information, see "Displaying Fusion Middleware Control" in the Oracle Fusion Middleware Administrator's Guide.

  2. Review the list of managed servers and verify that your configuration settings have been migrated to the new Oracle Forms and Reports 11g Release 2 (11.1.2) installation.

  3. Verify the Forms and Reports URLs, as described in "Checking Browser URLs" in the Oracle Fusion Middleware Installation Guide for Oracle Forms and Reports.