Performing the upgrade

This topic describes the procedure for upgrading 

.

• To run the Database assessment script
• To upgrade the reports data warehouse
• Where to go from here

To upgrade 

from earlier releases, complete all of the following tasks in the specified sequence:

1. Ensure that your databases are configured appropriately. For more information, see Database-recommendations.
2. Install 

   The macro unmigrated-inline-wiki-markup from Confluence is no longer available.

   (see Installing).
   The prompt displays the current installed version and notifies whether it is supported for upgrade. If the current installed version is not supported for upgrade, BMC recommends that you abort the installation. For information about the supported upgrade paths, see Supported-upgrade-paths.
3. (For Oracle only) If you are upgrading from any version earlier than 8.2, before the reports data warehouse upgrade starts during the product upgrade, the installation program asks if you want to continue with the data warehouse upgrade. If you have already run the Database assessment script and if the database-level parameters are compliant with the BMC recommended settings, click Yes (type Y on UNIX) and continue with the upgrade, and skip to step 6 to check the progress of the upgrade. If you have not run the Database assessment script earlier, click No (type N on UNIX), and go to step 5.
4. (For SQL Server only) The Database assessment script is not available. Skip to step 6 to check the progress of the upgrade process. 
5. BMC recommends that you run the Database assessment script now, and run the data warehouse upgrade script later. See To run the Database assessment scriptand To upgrade the reports data warehouse.
6. Verify whether the upgrade is completed successfully as follows:

   • (Microsoft Windows) After the upgrade is complete, the following message appears on the screen:

     An upgrade from <oldversion> to <newversion> completed successfully.

   • (UNIX) The upgrade process runs in the background. Monitor the BDSSAinstallationDirectory/logs/etl/upgrade_manager_timestamp.log file for the following message:

     An upgrade from <oldversion> to <newversion> completed successfully.

To run the Database assessment script

1. On the command prompt, navigate to the BDSSAInstallationDirectory/contents/db/scripts/oracle directory.
2. Log on to SQLPlus as a sysdba user.

3. Enter the following command:

   SQL> @bdssa_db_config_recommendation.sql
   

You can view the output of the preceding command in the bdssa_db_config_recommendation_log.out file created in the current working directory. This output file contains the database-level parameters and their current settings and also determines whether these settings are compliant with the BMC recommended settings.

To upgrade the reports data warehouse

1. From the command prompt, navigate to the BDSSAinstallationDirectory/etl/bin directory.

2. Enter the following command:

   nsh upgrade_warehouse.nsh

For Oracle deployments, if the reports data warehouse upgrade fails due to insufficient UNDO space, you must extend the UNDO space and run the upgrade script again. The upgrade process starts from the step at which it failed in the previous instance.

For Microsoft SQL Server deployments, if the reports data warehouse upgrade fails during the product upgrade process, enter the following command from the BDSSAinstallationDirectory/etl/bin directory to run the data warehouse upgrade later:

For SQL Server deployments, if you see the following message in the BDSSAinstallationDirectory/logs/etl/upgrade_manager_timestamp.log file during the database upgrade , you can ignore it:

Where to go from here

After you finish the upgrade, you must complete the post-upgrade steps described in Configuring-after-upgrade.