Preparing the CDA Database

Here you find the required configuration details for the database management systems.

See also: General Requirements for Upgrading CDA

Oracle

Find below the list of components and their 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 CDA_DATA and CDA_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_CDA_DATA DATAFILE
  '<PATH>\automic_cda_data.ora' SIZE 1024M
  AUTOEXTEND ON NEXT 1280K MAXSIZE UNLIMITED
  DEFAULT STORAGE
  (INITIAL 512K NEXT 2048K MAXEXTENTS UNLIMITED) ;

   

  CREATE TABLESPACE AUTOMIC_CDA_INDEX DATAFILE
  '<PATH>\automic_cda_index.ora' SIZE 512M
  AUTOEXTEND ON NEXT 96M MAXSIZE UNLIMITED
  DEFAULT STORAGE (INITIAL 512K NEXT 512K MAXEXTENTS UNLIMITED);

MS SQL Server

• 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
  • CDA connects via TCP/IP, so you need to make sure that your server and client has TCP/IP connection enabled (MS SQL Configuration Manager)
  • Disable the "Always On Availability Groups" option ("Is HADR Enable" property). Refer to: https://msdn.microsoft.com/en-us/library/ff878259.aspx.
  • Select the "SQL Server and Windows Authentication mode" option. Refer to: https://msdn.microsoft.com/en-us/library/ms188670.aspx

• Server Preparations

  Install SQL Server Management Studio to access the database

• Create the Database

  The size of the transaction protocol should be at least 25% of the database size (for evaluation systems using Truncate Log)

PostgreSQL

• PostgreSQL Database Instance

  Installation with the following parameters:

  • It is recommended to use lowercase when working with PostgreSQL.
  • There are some mandatory and recommended database settings in Preparing the AE Database - PostgreSQL that will help you optimize your database to achieve top performance.
  • The initial database space required for a CDA installation depends on the type and size of the system:

    Test systems: 1 GB

    Production systems

    • Small systems: 5 - 20 GB

    • Medium systems: 20 - 50 GB

    • Large systems: > 50 GB

    See also: CDA System Requirements and Sizing

• Server Preparations

  You can use either a graphical interface, such as pgAdmin, or a command line interface, such as psql, to install PostgreSQL.

Next step:

Reviewing the CDA Server System and Security