Oracle Requirements

Control-M, Control-M/EM, Control-M/Server and Control-M Workload Archiving can be installed on UNIX with an Oracle database. 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 one of the Control-M products.

The following topics list the Oracle requirements needed to install Control-M, Control-M/EM, Control-M/Server, and Control-M Workload Archiving on UNIX:

Oracle Database Server Memory Requirements

The following table lists the parameters and recommended values for an existing Oracle database server.

Parameter

Value

DB_BLOCK_SIZE

8192

OPTIMIZER_MODE

ALL_ROWS

CURSOR_SHARING

FORCE

PROCESSES

500

SGA_TARGET

1200 MB

PGA_AGGREGATE_TARGET

400 MB

MEMORY_TARGET

1600 MB

NOTE: If MEMORY_TARGET is defined, you do not need to define SGA_TARGET and PGA_AGGREGATE_TARGET.

Oracle Database Server Storage Requirements

The following table lists the minimum storage requirements for an existing Oracle database server.

Parameter

Value

Redolog groups

3

Redolog size

  • Small: 150

  • Medium: 250

  • Large: 400

SYSTEM tablespace size

  • Small: 750 MB

  • Medium: 1 GB

  • Large: 1.25 GB

UNDO tablespace size

  • Small: 350 MB

  • Medium: 500 MB

  • Large: 750 MB

TEMP tablespace size

  • Small: 150 MB

  • Medium: 300 MB

  • Large: 500 MB

Oracle Schema Checklist

The following table lists the Oracle resources you need for a Control-M , Control-M/EM, or a Control-M/Server installation. For the correct values, contact your Oracle site DBA.

Parameter

Value

Data tablespace size for both Control-M/EM and Control-M/Server

10 GB

Oracle tablespace name

 

Database username

 

Oracle Database Service name

 

Oracle LISTENER port number

 

Oracle Server hostname

 

Oracle SYSTEM password

Due to security reasons, the DBA might not be able to give you the password. If so, see Control-M Installation Without Oracle Database System Parameter.

CJK installation

Supports East Asian languages (Simplified Chinese, Traditional Chinese, Japanese, and Korean)

Verify that the database server character set is UTF-8.

Database user (DBO) password

The following special characters are not supported:

:&$%*!#.@ [{]};

Configuring Control-M/EM and Control-M/Server with Oracle Native Encryption

This procedure describes how to configure Control-M/EM and Control-M/Server with Oracle Native Encryption to connect to an Oracle server.

Begin

  1. Open a request to the site DBA to add the following lines to the sqlnet.ora file.

    • SQLNET.ENCRYPTION_SERVER= REQUIRED

    • SQLNET.ENCRYPTION_TYPES_SERVER= (AES256)

    • SQLNET.CRYPTO_CHECKSUM_SERVER= REQUIRED

    • SQLNET.CRYPTO_CHECKSUM_TYPES_SERVER= SHA256

  2. Navigate to one or more of the following:

    • Control-M/Server: $HOME/ctm_server /oracle/network/admin/sqlnet.ora

    • Control-M/EM: $HOME/em_server/oracle/network/admin/sqlnet.ora

  3. Add the following lines:

    • SQLNET.ENCRYPTION_CLIENT = REQUIRED

    • SQLNET.ENCRYPTION_TYPES_CLIENT = AES256

    • SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED

    • SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = SHA256

  4. Navigate to one or more of the following:

    • Control-M/Server: $HOME/ctm_server/oracle/network/admin/ojdbc.properties

    • Control-M/EM: $HOME/em_server/oracle/network/admin/ojdbc.properties

  5. Add the following lines:

    • oracle.net.encryption_client=REQUIRED

    • oracle.net.encryption_types_client=AES256

    • oracle.net.crypto_checksum_client=REQUIRED

    • oracle.net.crypto_checksum_types_client=SHA256