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.

Updating file server references

The way you execute the file_server_change 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/file_server_change/
    file_server_change_oracle.sql
  2. Change (cd) to the directory where you copied the scripts.
  3. Execute the following SQL*Plus command to change all file server references so they point to the new default file server:

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


    Running this command produces output similar to the following example:


    file_server_change script sample output

    The Default File Server and root path current setting //devfs1/blade/storage3/ PL/SQL procedure successfully completed.


    The number of rows updated by each update statement will vary in your database.

  4. To be certain that all references point to the new file server, run the file_server_check script again (see Checking file server references). The output should identify only one file server, and its values should be those of the new file server and storage location.

To update file server references on SQL server

  1. In the file structure extracted from BBSA<version>-<platform>.zip, copy the script 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/file_server_change/
    • file_server_change_sqlserver.bat
    • file_server_change_sqlserver.sql
  2. Change (cd) to the directory where you copied the scripts.
  3. Change all file server references so they point to the new default file server by running the following command:

    file_server_change_sqlserver sqlsrv <user> <database>


    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.

  4. To be certain that all references point to the new file server, run the file_server_check script again (see Checking file server references). The output should identify only one file server, and its values should be those of the new file server and storage location.

Where to go from here

If you have extended objects in your environment, see Updating extended object definitions with new file server location

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

Comments