Database server requirements

The following table lists the database server options for the Control-M full installation.

NOTE: You might experience performance degradation when the following occurs:

• Too much workload is placed on too few hard disks
• RedoLog files are placed on RAID-5 disks
• Rollback tablespace is placed on RAID-5 disks

  For more information, see 000105549.

  Database server	Description	Version
  PostgreSQL (BMC-supplied)	Installs automatically in the background when you install Control-M. NOTE: During an upgrade, the PostgreSQL database server versions is not updated.	9.5.5
  PostgreSQL (Existing)	A customer-supplied existing PostgreSQL full database server must be present (non-BMC source). The database server must have the following two extensions: plpgsql dblink NOTE: The database Administrator name must be postgres. OS authenticated logins to the database are not supported.	9.5.x 9.6.x
  Oracle	A customer-supplied existing Oracle full enterprise/standard edition database server must be present. An Oracle instant client is supplied in the background when you install Control-M. For more details, see Oracle requirements. NOTE: Oracle 12c is supported in the following scenarios: Installed as a regular database server that is not part of a Container database. Installed as a regular pluggable database (PDB) NOTE: Control-M/EM or Control-M/Server cannot be installed on an Oracle 12c Container database (CDB).	11g 12c
  MSSQL	A customer-supplied existing MSSQL full database server must be present. A Full MSSQL 2012,2014, or 2016 client that includes the OSQL and SQLCMD components must be present on any computer that hosts Control-M/EM or Control-M/Server. Mixed mode, which enables both Windows and SQL Server Authentication must be turned on. NOTE: Control-M installation with MSSQL must always be performed using an existing English language MSSQL database server.	2016 2014 2012

The following table contains the parameter information required to install Control-M on supported existing database servers. Check with your system administrator for the exact information required.

NOTE: The password must begin with a letter (A-Z, a-z) followed by 5-29 alphanumeric characters, underscores, or .“#.!@$*&:%-“ special characters.