1. Migrating and Upgrading to Oracle Analytics Server
  2. Upgrading Scaled-Out Systems
  3. Upgrading Product Schemas
  4. Upgrading Product Schemas Using the Upgrade Assistant

Upgrading Product Schemas Using the Upgrade Assistant

Navigate through the screens in the Upgrade Assistant to upgrade the product schemas.

If you are using DB2 in your existing BI instance, then perform the following before starting the upgrade process:

  1. Sign in to the WebLogic Console.
  2. Go to Datasources under Services and select wlsservices_datasource.
  3. Change the user for data source 'wlsservices_datasource' from <PREFIX>_WLS_RUNTIME to <PREFIX>_WLS.

    For example: Change the user from L1_WLS_RUNTIME to L1_WLS.

You can now proceed with the upgrade process.

To upgrade product schemas with the Upgrade Assistant:
  1. On the Welcome screen, review an introduction to the Upgrade Assistant and information about important pre-upgrade tasks. Click Next.

    Note:

    For more information about any Upgrade Assistant screen, click Help on the screen.
  2. On the Selected Schemas screen, select option:
    • All Schemas Used by a Domain to allow the Upgrade Assistant to discover and select all components that have a schema available to upgrade in the domain specified in the Domain Directory field. This is also known as a domain assisted schema upgrade. Additionally, the Upgrade Assistant pre-populates connection information on the schema input screens.

      Note:

      Oracle recommends that you select All Schemas Used by a Domain for most upgrades to ensure all of the required schemas are included in the upgrade.
    • Individually Selected Schemas if the domain uses the Oracle ATP (Autonomous Transaction Processing) database.

    Click Next.

  3. If you selected All Schemas Used by a Domain: On the Component List screen you will see two lists of schemas. The first list shows the components whose schemas are present in the domain and will be upgraded. The second list shows the list of missing schemas that may need to be created. If none of the required schemas are missing, you will only see the first list. Review both lists and click Next.
    The Upgrade Assistant will attempt to create any missing schemas using the schema credentials used to create the existing domain schemas. You do not need to launch the Repository Creation Utility.
    If you want to exclude some components or schemas from the list, navigate back to the All Schemas screen and select Individually Selected Schemas. This option allows you to select only those schemas you want included in the upgrade.
  4. If you selected Individually Selected Schemas to upgrade the schema for the Oracle ATP database, perform these steps:
    1. Select all the components including Oracle Business Intelligence.
    2. In the schema details screen, input the full TNS connect string in the database connection string field, enter other details, and then click Next to proceed.
  5. On the Prerequisites screen, acknowledge that the prerequisites have been met by selecting all the check boxes. Click Next.

    Note:

    The Upgrade Assistant does not verify whether the prerequisites have been met.
  6. On the BIPLATFORM Schema [BIEE_PLATFORM] screen, the system automatically populates data in the other fields from the existing 12c schema.
    Enter the database administrator account: DBA username and password for the database containing the BIEE_PLATFORM schema and click Connect.
    When you see the message “Connection to database successfully completed”, click Next.
  7. On the IAU Schema [BIEE_IAU] screen, the system automatically populates data in the other fields from the existing 12c schema.
    Enter the database administrator account: DBA username and password for the database containing the BIEE_IAU schema and click Connect.
    When you see the message “Connection to database successfully completed”, click Next.
  8. On the OPSS Schema [BIEE_OPSS] screen, the system automatically populates data in the other fields from the existing 12c schema.
    Enter the database administrator account: DBA username and password for the database containing the BIEE_OPSS schema and click Connect.
    When you see the message “Connection to database successfully completed”, click Next.
  9. On the MDS Schema [BIEE_MDS] screen, the system automatically populates data in the other fields from the existing 12c schema.
    Enter the database administrator account: DBA username and password for the database containing the BIEE_MDS schema and click Connect.
    When you see the message “Connection to database successfully completed”, click Next.
  10. On the STB Schema [BIEE_STB] screen, the system automatically populates data in the other fields from the existing 12c schema.
    Enter the database administrator account: DBA username and password for the database containing the BIEE_STB schema and click Connect.
    When you see the message “Connection to database successfully completed”, click Next.
  11. On the WLS Schema [BIEE_WLS_RUNTIME] screen, the system automatically populates data in the other fields from the existing 12c schema.
    Enter the database administrator account: DBA username and password for the database containing the BIEE_WLS_RUNTIME schema and click Connect.
    When you see the message “Connection to database successfully completed”, click Next.
  12. On the Examine screen, review the status of the Upgrade Assistant as it examines each schema, verifying that the schema is ready for upgrade. If the status is Examine finished, click Next.
    If the examine phase fails, Oracle recommends that you cancel the upgrade by clicking No in the Examination Failure dialog. Click View Log to see what caused the error.

    Note:

    • If you resolve any issues detected during the examine phase without proceeding with the upgrade, you can start the Upgrade Assistant again without restoring from backup. However, if you proceed by clicking Yes in the Examination Failure dialog box, you need to restore your pre-upgrade environment from backup before starting the Upgrade Assistant again.

    • Canceling the examination process has no effect on the schemas or configuration data; the only consequence is that the information the Upgrade Assistant has collected must be collected again in a future upgrade session.

  13. On the Upgrade Summary screen, review the summary of the schemas that will be upgraded and/or created.
    Verify that the correct Source and Target Versions are listed for each schema you intend to upgrade.
    If you want to save these options to a response file to run the Upgrade Assistant again later in response (or silent) mode, click Save Response File and provide the location and name of the response file. A silent upgrade performs exactly the same function that the Upgrade Assistant performs, but you do not have to manually enter the data again.
    Click Next .
  14. On the Upgrade Progress screen, monitor the status of the upgrade.

    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 schema isn't upgraded successfully, refer to the Upgrade Assistant log files for more information.

    Note:

    The progress bar on this screen displays the progress of the current upgrade procedure. It does not indicate the time remaining for the upgrade.

    Click Next.

  15. If the upgrade is successful: On the Upgrade Success screen, click Close to complete the upgrade and close the wizard.

    If the upgrade fails: On the Upgrade Failure screen, click View Log to view and troubleshoot the errors. The logs are available at NEW_ORACLE_HOME/oracle_common/upgrade/logs.

    Note:

    If the upgrade fails, you must restore your pre-upgrade environment from backup, fix the issues, then restart the Upgrade Assistant.