Important

   

Starting version 8.9.03, BMC Server Automation is renamed to TrueSight Server Automation. This space contains information about BMC Server Automation 8.9.02 and previous versions. For TrueSight Server Automation 8.9.03 and later releases, see TrueSight Server Automation 8.9.

Updating extended object definitions with new file server location

The way you execute the update_extended_object_script_location script depends on your database platform.

To update file server references on Oracle

  1. In the file structure extracted from BBSA<version>-<platform>.zip, copy the script from the following location (to a directory from which you can access SQL*Plus):

    LocationScript
    BBSA<version>-<platform>/files/configurations/
    db_scripts/oracle/utility/
    update_extended_object_script_location/
    update_extended_object_script_location.sql
  2. Change (cd) to the directory where you copied the scripts.
  3. Modify the update_extended_object_script_location.sql script file to update old_server and new_server variables before executing the script to update extended objects definitions which are stored on the file server.

    sqlplus <user> / <password> @update_extended_object_script_location.sql

To update file server references on SQL server

  1. In the file structure extracted from BBSA<version>-<platform>.zip, copy the scripts from the following locations to a directory from which you can access the sqlcmd utility:

    LocationScripts
    BBSA<version>-<platform>/files/configurations/
    db_scripts/sqlserver/utility/
    update_extended_object_script_location/
    update_extended_object_script_location.sql
  2. Change (cd) to the directory where you copied the scripts.

  3. Modify the update_extended_object_script_location.sql file to update old_server and new_server variables before executing the script to update extended object definitions which are stored on the file server.

    sqlcmd -s <sqlsrv host>[\<instance>] -U <user> -d <database> -i update_extended_object_script_location.sql -o <file_server_check_sqlserver.out>

    Replace the variables with the following values:

    sqlsrv

    Name of the SQL Server hosting the BMC Server Automation database.

    user

    User name of a database user that has the privileges required to perform this operation.

    database

    Name of the database.

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

Comments