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 |
|
SYSTEM Tablespace Size |
|
UNDO Tablespace Size |
|
TEMP Tablespace Size |
|
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: :, &, $, %, *, !, #, ., @, [, {, ], }, and ;. |
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
-
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
-
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
-
-
Add the following lines:
SQLNET.ENCRYPTION_CLIENT = REQUIRED
SQLNET.ENCRYPTION_TYPES_CLIENT = AES256
SQLNET.CRYPTO_CHECKSUM_CLIENT = REQUIRED
SQLNET.CRYPTO_CHECKSUM_TYPES_CLIENT = SHA256
-
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
-
-
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