Upgrade Product Schemas Using the Upgrade Assistant

After stopping servers and processes, use the Upgrade Assistant to upgrade supported product schemas to the current release of Oracle Fusion Middleware.

1. Stop your Oracle Fusion Middleware environment.
   1. Go to the Existing_DOMAIN_HOME/bitools/bin directory.
   2. Run stop.cmd (Windows) or stop.sh (Linux) to stop the Oracle BI instance and servers.
2. Start the Upgrade Assistant.
   1. Go to the NEW_ORACLE_HOME/oracle_common/upgrade/bin directory.
   2. Run the command: ./ua
3. On the Welcome screen, review information. Click Next.
4. On the Selected Schemes screen, select Individually Selected Schemas, and then click Next.
5. On the Available Components screen, make sure you don't select Oracle Data Integrator and User Messaging Service (UMS) schemas for pre upgrade readiness check, and then click Next.
6. On the Domain Directory screen, enter the existing 11.1.1.10.3 install domain directory and click Next.
   View all the schemas one after another, and you need to enter DBA password, schema passwords.
7. On the Prerequisites screen, acknowledge that the prerequisites have been met by selecting all the check boxes. Click Next.
8. On the BIPLATFORM Schema 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.
9. On the OPSS Schema 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.
10. On the IAU Schema 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.
11. On the STB Schema 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.
12. On the WLS Schema 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.
13. 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.
14. 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.
15. On the Upgrade Progress screen, monitor the status of the upgrade, and then Click Next.
16. 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.