Configuring a database server

BMC Server Automation works in conjunction with an Oracle or SQL Server database server. The installation program can configure the Application Server to communicate with this database. However, you can manually configure the Application Server to communicate with the database, as described in this procedure.

Note

In a Multiple Application Server (MAS) environment, you can perform this task only once on each host machine. The database server settings that you configure are applied to all servers hosted on the single host machine. For more information about a Multiple Application Server environment, see Managing multiple Application Servers on the same host.

  1. Start the Application Server Administration console, as described in Starting the Application Server Administration console.
  2. To specify a connection string for the database, enter the following:
    set database connectionstring "<ConnectionString>"
    where string is a string that specifies the database type, the server running the database, the port the database listens on, and SQL Server database name or Oracle SID. The connection string can use one of the following formats:
    • jdbc:oracle:thin:@DBSERVER:PORT:SID
    • jdbc:sqlserver://DBSERVER:PORT;DatabaseName=DBNAME;SelectMethod=cursor
      When using one of the formats shown above, do the following:
    • Replace DBSERVER with the name or IP address of the server running the database.
    • Replace DBNAME with the name of the database or replace <SID> with the Oracle SID.
    • Replace PORT with the port number the database is listening on. By default, a BMC Server Automation installation uses the following database ports:

      Database Type

      Port Number

      Oracle

      1521

      SQL Server

      1433

  3. To specify the driver class for the database, enter the following:
    set database driverclass <class>
    where <class>is the Java class used to communicate with the database. Depending on the type of database you are using, you can define the class with one of the following strings:
    • oracle.jdbc.driver.OracleDriver
    • com.microsoft.sqlserver.jdbc.SQLServerDriver
  4. To specify the user ID and password for the database, enter the following two commands:
    set database userid <id> set database password ******
    where <id> is the user name that the database requires to authenticate your connection and ******** is the password assigned to that user ID.

    Note

    If you modify the BMC Server Automation database details (for example: server name, SID, or password), you must change the BMC BladeLogic Decision Support for Server Automation site context to use the modified details. For instructions on the changing the site context, see To manage the BMC Decision Support for Server Automation sites in the BMC BladeLogic Decision Support for Server Automation documentation.

  5. To specify a commit size for an Oracle database, enter the following:
    set database commitsize <size>
    where <size> is the maximum number of rows that can be updated in an Oracle database before you either have to commit your updates or roll them back. Commit size is primarily used when taking snapshots or performing audits in BMC Server Automation. A larger commit size means database processes execute more quickly, but at the same time you run the risk of losing more data if a database process fails.

    Tip

    Because Oracle databases can be highly tuned, consult your Oracle DBA to achieve best results when defining a commit size.

  6. Restart the Application Server.

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

Comments