Use this chapter to upgrade from Oracle Forms and Reports 11g Release 1 to Oracle Forms and Reports 11g Release 2.
This chapter contains the following sections:
Overview of Upgrading from Oracle Forms and Reports 11g Release 1 (11.1.1)
Locating and Editing the Oracle Forms and Reports Upgrade Properties File
Performing the Oracle Forms and Reports 11g Release 1 (11.1.1) Upgrade
Troubleshooting the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade
The following sections provide information you should know before performing the upgrade procedure:
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:
The source Oracle instance is your currently running Oracle Forms and Reports 11g Release 1 (11.1.1) instance.
The destination Oracle instance is the Oracle Forms and Reports 11g Release 2 (11.1.2) Oracle instance that you created in Chapter 3, "Installing Oracle Forms and Reports 11g Release 2 (11.1.2) In Preparation for Upgrade".
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.
To locate and edit the Oracle Forms and Reports upgrade properties file:
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\
Use a text editor to open the following file:
upgrade.properties
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.
Do not use any leading or trailing spaces before or after the values you enter in the properties file; otherwise, Apache Ant build might fail.
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 |
|
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 |
|
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.8, "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. |
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):
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.
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.
Set the following environment variables:
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/jdkrel_version DEST_ORACLE_HOME/jdk
Windows:
DEST_MW_HOME\jdkrel_version DEST_ORACLE_HOME\jdk
ANT_HOME: Depending on the operating system and platform, the ANTinstalled with Oracle Forms and Reports is usually in the following locations:
UNIX:
DEST_MW_HOME/modules/org.apache.ant_1.7.1
Windows:
DEST_MW_HOME\modules\org.apache.ant_1.7.1
PATH: Make sure that the Java Development Kit (JDK) and Apache Ant binaries are included in the PATH variable.
UNIX:
JAVA_HOME/bin ANT_HOME/bin
Windows:
JAVA_HOME\bin ANT_HOME\bin
CLASSPATH: Make sure the following is in the CLASSPATH variable:
UNIX:
DEST_MW_HOME/wlserver_10.3/server/lib/weblogic.jar
Windows:
DEST_MW_HOME\wlserver_10.3\server\lib\weblogic.jar
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\
Enter the following command, which will run each of the required upgrade scripts:
ant
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".
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):
Locating the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade Log Files
Locating the Automatic Backup of the Destination Oracle Instance and Domain
Re-Running the 11g Release 1 (11.1.1) to 11g Release 2 (11.1.2) Upgrade Scripts
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
Each time you run the upgrade scripts, the scripts make a complete backup copy of the destination Oracle instance directory and the Oracle WebLogic Server domain directory.
These directories is created in the same directories where the original Oracle instance and domain directories reside. The name of the directories are saved using the following format to help you identify the backup directory:
instance_name.preUpgrade_date-time domain_name.preUpgrade_date-time
For example:
forms_reports_1112_instance1.preUpgrade_08-22-2012-12_10_30_PM forms_reports_domain1.preUpgrade_08-22-2012-12_10_30_PM
If you need to restore your Oracle Instance or domain after a failed upgrade attempt, you can obtain the backed up files from this location.
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:
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".
Run the scripts again, as described in Section 5.3, "Performing the Oracle Forms and Reports 11g Release 1 (11.1.1) Upgrade".
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.
To verify a successful upgrade:
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.
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.
Verify the Forms and Reports URLs, as described in "Checking Browser URLs" in the Oracle Fusion Middleware Installation Guide for Oracle Forms and Reports.