Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Running the SQL update scripts

When upgrading to an 8.5.x service pack (later than 8.5.00), after upgrading the Application Server you must run a set of SQL Update scripts to upgrade the BMC Server Automation database to the service pack level compatible with the Application Server. This topic includes the following sections:

Before you begin

Ensure that the computer on which you run the SQL Update scripts fulfills the following requirements:

  • Has access to the BMC Server Automation database server
  • Has SQL tools installed, such as SQL*Plus (in the case of Oracle) or sqlcmd (in the case of Microsoft SQL Server)

    You can install the sqlcmd utility from the SQL Server install media, or as part of the SQL Server 2008 R2 feature pack or the SQL Server 2012 feature pack. You can find the utility from the full SQL server install under Shared Features > Management Tools - Basic.
    Click here to download a standalone installer from the Microsoft website. 

In addition, ensure that the user that you created for the BMC Server Automation database owner has permissions to create tables and indexes in the database.

To run the SQL update scripts for an Oracle database

  1. Obtain the zipped package of SQL Update scripts from the BMC Electronic Product Distribution (EPD) website, as described in Downloading the installation files.
  2. This zipped package is named 85<Patch or SP level>-SQL_Update_Scripts.zip file, where <Patch or SP level> can be one of the following values: P1, P2, or SP1
  3. Extract the contents of the zipped package of SQL Update scripts to a temporary local directory.
  4. Navigate to the directory that contains the update scripts  (temporaryDirectory/8.5.0x/Remediation/oracle).
  5. Log on to SQL*Plus as the BMC Server Automation database owner (as provided to blasadmin during BMC Server Automation schema creation).
  6. Run the script, as follows:

    SQL>start install_hotfix_update_oracle_script.sql
    

To run the SQL update scripts for a Microsoft SQL Server database

  1. Obtain the zipped package of SQL Update scripts from the BMC Electronic Product Distribution (EPD) website, as described in Downloading the installation files.
  2. This zipped package is named 85<Patch or SP level>-SQL_Update_Scripts.zip file, where <Patch or SP level> can be one of the following values: P1, P2, or SP1.
  3. Extract the contents of the zipped package of SQL Update scripts to a temporary local directory.
  4. Navigate to the directory that contains the upgrade scripts (temporaryDirectory/8.5.0x/Remediation/sqlserver).
  5. Execute the install_hotfix_update_sqlserver_script.bat file with the following input parameters:
    install_hotfix_update_sqlserver_script.bat <DBServerName> <DBName> <Username> <Password>

    Example


    install_hotfix_update_sqlserver_script.bat testserver test_db BLuser BMC123

    Recommendation

    After upgrading the SQL update scripts from version 3.1.01 to 4.1, the scripts do not execute when the password has special characters.

    BMC recommends entering the password in double quotes while executing this script on command prompt.

Where to go from here

If you have upgraded the provisioning server (the Application Server enabled for provisioning), upgrade the components that BMC Server Automation uses in provisioning operating systems to bare metal machines. See:

Otherwise, return to the main Upgrading topic.


Was this page helpful? Yes No Submitting... Thank you

Comments

  1. Tim Usrey

    Please include the following as additional info in the prerequisites (see ISS04462985):

     

    The sqlcmd tool can be installed from the sql server install media or can be installed as part of the SQL Server 2008 R2 feature pack or SQL server 2012 feature pack.

     

    From the full SQL server install media it is under Shared Features-->Management Tools - Basic.

     

    Microsoft also provides a standalone installer at https://www.microsoft.com/en-us/download/details.aspx?id=36433

    Apr 30, 2015 09:23
    1. Fran Coughlin

      Hi Tim,

      Thanks VERY much for the comment! We appreciate you taking the time to add the info.

      The information has been added to the "Before you begin" section.

      Thanks and regards,

      Fran 

      Apr 30, 2015 11:02