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