3 Performing the Oracle GoldenGate Studio Upgrade

This chapter contains the procedure to upgrade Oracle Business Intelligence from Release 12.2.1.0.0 to Release 12.2.1.1.0. The upgrade is performed in-place, that is, the upgrade operations are performed on the existing 12.2.1 domain.

High-level upgrade steps:

3.1 Installing Oracle GoldenGate Studio Release 12.2.1.1

To install Oracle GoldenGate Studio:
  1. Sign in to the target system where you want to install the 12.2.1.1 product distribution.
  2. Download all the installation files of Oracle GoldenGate Studio from Oracle Technology Network or Oracle Software Delivery Cloud on your target system. The name of the distribution file is fmw_12.2.1.1.0_oggstudio_generic.jar.
  3. Start the installation program by entering the following command:
    On UNIX operating system:
    $JDK_HOME/bin/java [-d64] -jar <distribution_file_name>.jar

    Note:

    Use the "-d64" flag only if you are using the HP-UX Itanium system.
    On Windows operating system:
    %JDK_HOME%\bin\java -jar <distribution_file_name>.jar
  4. On UNIX operating system, the Installation Inventory Setup screen appears if this is the first time you are installing an Oracle product on this host.
    Specify the location where you want to create your central inventory. Make sure that the operating system group name selected on this screen has write permissions to the central inventory location and click Next.

    Note:

    Installation Inventory Setup screen does not appear on Windows operating system.
  5. On the Welcome screen, review the information to make sure that you have met all the prerequisites and click Next.
  6. On the Auto Updates screen, select Skip Auto Updates and click Next.

    • Skip Auto Updates: If you do not want your system to check for software updates at this time.

    • Select patches from directory: To navigate to a local directory if you downloaded patch files.

    • Search My Oracle Support for Updates: To automatically download software updates if you have a My Oracle Support account. You must enter Oracle Support credentials then click Search. To configure a proxy server for the installer to access My Oracle Support, click Proxy Settings. Click Test Connection to test the connection.

  7. On the Installation Location screen, specify the location for the Oracle home directory and click Next.

    Note:

    Ensure that the Oracle Home directory, where you are installing Oracle GoldenGate Studio, is empty.

    For more information about Oracle Fusion Middleware directory structure, see Selecting Directories for Installation and Configuration in Planning an Installation of Oracle Fusion Middleware.
  8. On the Installation Type screen, select Complete Install.
  9. The Prerequisite Checks screen analyzes the host computer to ensure that the specific operating system prerequisites have been met.
    If any prerequisite check fails, then an error message appears at the bottom of the screen. Fix the error and click Rerun to try again.
    To ignore the error or the warning message and continue with the installation, click Skip, however this approach is not recommended.
  10. On the Installation Summary screen, verify the installation options you selected.
    To save these options to a response file, click Save Response File and enter the location and the name of the response file. You can use response files for silent installation. Click Install.
  11. On the Installation Progress screen, click Next when the progress bar displays 100%.
  12. The Installation Complete screen displays the Installation Location and the Feature Sets that are installed. Review this information on this screen and click Finish to close the installer.

3.2 Upgrading the Schemas with the Upgrade Assistant

Run the Upgrade Assistant to upgrade all the schemas in the 12.2.1.0.0 domain to 12.2.1.1.0.

To upgrade the 12.2.1.0.0 repository schemas:
  1. Run the Upgrade Assistant from the 12.2.1.1 Oracle home by entering the following command:
    On UNIX operating system:
    $Oracle_Home/oracle_common/upgrade/bin/ua
    On Windows operating system:
    %Oracle_Home%\oracle_common\upgrade\bin\ua.bat
  2. The Welcome screen provides an overview of the Upgrade Assistant and some information about important pre-upgrade tasks. Click Next.
    For more information about using the Upgrade Assistant, click Help on the Upgrade Assistant screen.
  3. On the Selected Schemas screen, select Individually Selected Schemas. This option allows you to select only those schemas that you want to include in the upgrade. Click Next.
  4. On the Available Components screen, select Oracle GoldenGate Studio and click Next.
  5. On the Prerequisites screen, acknowledge that the prerequisites have been met by checking all the check boxes. Click Next.

    Note:

    The Upgrade Assistant does not verify whether the prerequisites have been met.
  6. On the OGGSTUDIO Schema screen, specify the connection credentials in which you will be creating or dropping schemas.
    Specify the service name and the database administrator account: DBA username and password for the database containing the OGGSTUDIO schema and click Connect.

    Note:

    Do not use SYSDBA as the database user name.

  7. Specify the schema user name and the password for the selected schema.
    When you see the message “Connection to database successfully completed”, click Next.
  8. On the Studio Options screen, select Upgrade topology and security metadata and Use AES-128 encryption algorithm. Click Next.

    Note:

    If you do not select Use AES-128 encryption algorithm, AES-256 will be used as the encryption algorithm will be used for the upgrade.

  9. On the OGG Studio Supervisor screen, specify the supervisor credentials for the OGG repository you want to upgrade and click Next.
  10. The Examine screen displays the status of the Upgrade Assistant as it examines each component, verifying that the component is ready for upgrade. If the status is “ready for upgrade.”, click Upgrade.
    If the repository version is same as that of the current repository, the status will be ‘upgrade not required’.
  11. On the Upgrade Summary screen, review the summary of the options you have selected by expanding the tree.
    Review the Source Version and the Target Version to make sure that both the versions are correct before proceeding with the upgrade.
    The response file collects and stores all the information that you have entered through the Upgrade Assistant's graphical user interface , and enables you to perform a silent upgrade at a later time. The silent upgrade performs exactly the same function that the Upgrade Assistant wizard performs, but you do not have to manually enter the data again. If you want to save these options to a response file, click Save and provide the location and name of the response file.
    Click Upgrade to start the upgrade process.
  12. The Upgrade Progress screen shows the status of the upgrade process and the projected Target Version of the component after a successful upgrade. Click Next.

    Caution:

    Allow the Upgrade Assistant enough time to perform the upgrade. Do not cancel the upgrade operation unless absolutely necessary. Doing so may result in an unstable environment.
    If any components are not upgraded successfully, refer to the Upgrade Assistant log files for more information.
  13. If the upgrade is successful, you see the Upgrade Success screen. Click Close to complete the upgrade and close the wizard.
    The Post-Upgrade Actions window describes the manual tasks you must perform to make the component functional in the new installation. This is an optional window that only appears if a component has post-upgrade steps.
  14. If the upgrade has failed, you see the Upgrade Failure screen. This indicates that the upgrade of one or more components has failed. The components cannot be upgraded this time.
    Click View Log to view and troubleshoot the errors.
    Fix the issues in the pre-upgrade environment before starting the Upgrade Assistant again. Restore your pre-upgrade environment from backup (making sure to keep the original backup files in a separate location), fix the issues, and restart the Upgrade Assistant.