Configure Oracle database type and server

Note: Installing Control Room on Oracle Database is deprecated. Microsoft SQL Server is the only database type that is available for installing Control Room.

Configure the Oracle Database Server for use with the Control Room by using the Database type wizard page.

Prerequisites

This procedure applies only to installations based on Microsoft Windows Server.

Oracle must be installed on a machine that is accessible from the Automation 360 Control Room.

Create users for Automation Anywhere to access the Database.

This is supported only on non-container Database. Oracle installation is supported only for first-time setup of Automation Anywhere. Oracle installation does not support updates.
Note: Oracle database for Control Room installation is supported only in Custom mode and not in Express mode.

Procedure

  1. Select Oracle database.
    An instance of the Oracle Server must be configured already. For more information, see Installing Control Room using custom mode for Oracle installation.
  2. Click Next.
    The Oracle Database server page is displayed (if you selected Oracle for configuring your database).
    The following sample illustration shows Oracle Database Server authentication for database connection:
    Example use case of Oracle database server installation window for database connection.
  3. Set the connection and authentication for the database server. Provide the following details:
    1. Database Server: Enter the server name or IP address of the Oracle Database server.
      The localhost IP address can be used.
    2. Database Port: Enter your database server port number. The default port is 1521.
    3. For the connection, select one of the following options and enter the name of your Oracle instance in the text field:
    OptionAction in text field (example)
    SID ORCL
    Service name ORCLPDB
    Note: The SID and service name entered in the text field provided is unique to your Oracle database. The Oracle instance name entered in the text field is not case-sensitive.
  4. In the Username field, enter your Oracle database user or schema name.
  5. In the Password field, enter the password for the user or schema name.
  6. Use Secure Connection: Select to use a CA certificate as specified.
    Note: Use the same host name for certificate and database connections.
  7. Certificate: This option is enabled when you select Use Secure Connection. Browse to select a CA certificate.
    Import HTTPS SSL, intermediate, and CA certificates
  8. Click Next.
    The database connection begins validating for the database server and the elastic search.
  9. Enter the Elasticsearch credentials in the fields provided.
    Add OpenSearch credentials