Preparing the CDA Database

• 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

• TNSNAMES.ORA configured to access the Oracle Database

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

• Install SQL Server Management Studio to access the database

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

Installation with following parameters:

• It is recommended to use lowercase when working with PostgreSQL.

• There are some mandatory and recommended database settings that will help you optimize your database to achieve top performance. See: Recommendations for PostgreSQL

• 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

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