Upgrading the databases on Oracle

If you are using 

version 8.1 or any of the 8.1 Service Packs, before running ETL, you must run an upgrade script for each 8.1 and 8.1 SP site in your  installation.

• CDC tables for assets
• To upgrade the databases

If this is a fresh installation, you only have one database set up (the primary site). If this is an upgrade, you might have multiple databases in your environment.

CDC tables for assets

The database upgrade script ensures the successful transfer of incremental data from the 

database to the data warehouse in the 3_CONFIG_OBJECTS scenario, as follows.

Whenever a new entry is added in a Config Object table in the BMC Server Automation database, a trigger inserts the entry into the corresponding Config Object Dimension (also called CDC) table. The ETL process references the CDC tables for entries and only the entries that are added after the last ETL run (incremental entries) are loaded in the reports data warehouse. The CDC tables are added for the following assets:

• File System
• Complus
• Configuration
• .NET Assemblies
• Event Logs
• Custom objects (Hardware Information, UNIX Users, UNIX Groups, UNIX Processes, UNIX Daemon Listener)
• Security Settings
• Local Groups
• Local Users
• Registry
• Services
• Applications/HotFixes
• Packages
• Patches
• Products
• RPMs

To upgrade the databases

1. Navigate to the directory that contains the upgrade scripts.
   These are the scripts that you extracted from the BDSSA82-servicepackVersion-external-files.zip file, which are located in the /BDSSA/Db_Scripts/oracle/schema directory by default. For more information about the zip file, see Downloading-the-BMC-BladeLogic-Decision-Support-for-Server-Automation-External-Files.
2. Log on to SQL Plus as bladelogic (or the name you chose for the 

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

   user).

3. Run the following script:

   OM_upgrade_for_BDSSA_8.2.0_oracle.sql

4. The script prompts you for data and index tablespace names. Enter BLADELOGIC and BLADELOGIC_INDEX as tablespace names as illustrated in the following example:

   SQL> start OM_upgrade_for_BDSSA_8.2.0_oracle.sql;
   Enter value for data_tablespace_name: BLADELOGIC
   Enter value for index_tablespace_name: BLADELOGIC_INDEX
   

When the script completes, the database is upgraded. Repeat this process for each 

database. After completing this procedure, run ETL.