Configuring the ARA Database Server

Click the image to expand it.

To Configure the ARA Database Server

Find the required configuration details for Oracle or MS SQL database management systems below:

See also:General Requirements for Automic Release Automation

Component Requirements
Oracle Database Instance
  • Use character set WE8ISO8859P1 or UTF-8

    Determine the Oracle Database installation set:
    SELECT * FROM NLS_DATABASE_PARAMETERS;

  • Database Block Size 8192 Byte is required.
  • NLS_LENGTH_SEMANTICS = BYTE
  • Prepare table spaces UC4_DATA and UC4_INDEX
Oracle Server Preparations

  • TNSNAMES.ORA configured to access the Oracle Database

Define the AUTOMIC_ARA_DATA/INDEX tablespace

  • Tablespace Data 1024 MB
  • Tablespace Index 512 MB
  • Tablespace definition:
    • CREATE TABLESPACE AUTOMIC_ARA_DATA DATAFILE
      '<PATH>\automic_ara_data.ora' SIZE 1024M
      AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
      DEFAULT STORAGE
      (INITIAL 512K NEXT 2048K MAXEXTENTS UNLIMITED) ;
    • CREATE TABLESPACE AUTOMIC_ARA_INDEX DATAFILE
      '<PATH>\automic_ara_index.ora' SIZE 512M
      AUTOEXTEND ON NEXT 96M MAXSIZE UNLIMITED
      DEFAULT STORAGE (INITIAL 512K NEXT 512K MAXEXTENTS UNLIMITED);

ClosedMicrosoft SQL Server

Component Requirements
MS SQL Database Instance

Installation with following parameters:

  • Standard-Sorting
  • Case-insensitive
  • Standard code page 1252
  • Make sure that the 'autoshrink' option is not activated
  • ARA connects via TCP/IP, so you need to make sure that your server and client has TCP/IP connection enabled (MS SQL Configuration Manager)
Server Preparations

  • Install SQL Server Management Studio to access the database

Preparation Steps Progress

Next steps:

Configuring the ARA Server

Configuring the ARA Client

Configuring the AE Agents

Security Setup for Super Users

Previous Steps:

Download and Prepare the Installation Files

Prepare Configuration for AE Database

Configuring the AE Server

Configuring the AWI Server