To establish a connection to the Orchestrator database, you must set the database connection parameters.

Prerequisites

  • Set up a new database to use with the Orchestrator server. See Setting Up the Orchestrator Database.

  • If you use an SQL Server database configured to use dynamic ports, verify that the SQL Server Browser service is running.

  • To prevent transactional deadlocks when using Microsoft SQL Server database, you must enable the ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT database options.

  • If your Microsoft SQL Server database uses dynamic ports, ensure that the SQL Server Browser is running.

  • To avoid an ORA-01450 error when using the Oracle database, verify that you have configured the size of the database block properly. The minimum required size depends on the size of the block your Oracle database index is using.

  • To store characters in the correct format in an Oracle database, set the NLS_CHARACTER_SET parameter to AL32UTF8 before configuring the database connection and building the table structure for Orchestrator. This setting is crucial for an internationalized environment.

  • To configure Orchestrator to communicate with the database over a secure connection, make sure that you import the database SSL certificate. For more information, see Import the Database SSL Certificate.

Procedure

  1. Log in to Control Center as an administrator.
  2. Click Configure Database.
  3. From the Database type drop-down menu, select the type of database that you want the Orchestrator server to use.

    Option

    Description

    Oracle

    Configures Orchestrator to work with an Oracle database instance.

    SQL Server

    Configures Orchestrator to work with a Microsoft SQL Server database instance.

    PostgreSQL

    Configures Orchestrator to work with a PostgreSQL database instance.

    In-Process DerbyDB

    Configures Orchestrator to work with the in-process DerbyDB database.

    Note:

    You must not use DerbyDB.

    Note:

    The support for Microsoft SQL Server database and Oracle database is deprecated and will be removed in future versions.

  4. Enter the database connection parameters and click Save changes.

    Option

    Description

    Server address

    The database server IP address or DNS name.

    This option is applicable for all databases.

    Port

    The database server port is used for communication with your database.

    This option is applicable for all databases.

    Use SSL

    Select Use SSL to use an SSL connection to the database. To use this option, you must make sure that you import the database SSL certificate into Orchestrator.

    This option is applicable for all databases.

    Database name

    The full unique name of your database. The database name is specified in the SERVICE_NAMES parameter in the initialization parameter file.

    This option is valid only for SQL Server, and PostgreSQL databases.

    User name

    The user name that Orchestrator uses to connect to and operate the selected database. The name you select must be a valid user on the target database with db_owner rights.

    This option is applicable for all databases.

    Note:

    The default user name for the preconfigured PostgreSQL database is vmware.

    Password

    The password for the user name.

    This option is applicable for all databases.

    Note:

    The default password for the preconfigured PostgreSQL database is vmware.

    Instance name (if any)

    The name of the database instance that can be identified by the INSTANCE_NAME parameter in the database initialization parameter file.

    This option is valid only for SQL Server and Oracle databases.

    Domain

    To use Windows authentication, enter the domain name of the SQL Server machine, for example company.org.

    To use SQL authentication, leave this text box blank.

    This option is valid only for SQL Server and specifies whether you want to use Windows or SQL Server authentication.

    Use Windows authentication mode (NTLMv2)

    Select to send NTLMv2 responses when using Windows authentication.

    This option is valid only for SQL Server.

    If the specified parameters are correct, a message states that the connection to the database is successful.

  5. Update the table structure for Orchestrator, if required.
  6. Click Save changes.

Results

The database connection is successfully configured.