2.1 Summary of Manager Parameters

Manager is the parent process of Oracle GoldenGate and is responsible for the management of its processes, resources, user interface, and the reporting of thresholds and errors. In most cases default settings for Manager suffice.

Parameter Description

ACCESSRULE

Adds security access rules for Manager.

CHARSET

Specifies a multibyte character set for the process to use instead of the operating system default when reading the parameter file.

COMMENT | --

Allows insertion of comments in a parameter file.

SOURCEDB

Specifies a data source name as part of the login information.

USERIDALIAS

Provides login information for Manager when it needs to access the database.

Manager parameters: port management.

Parameter Description

DYNAMICPORTLIST

Specifies the ports that Collector can dynamically allocate.

PORT

Establishes the TCP/IP port number on which Manager listens for requests.

Manager parameters: Process management.

Parameter Description

AUTORESTART

Specifies processes to be restarted by Manager after a failure.

AUTOSTART

Specifies processes to be started when Manager starts.

BOOTDELAYMINUTES

Determines how long after system boot time Manager delays until performing main processing activities. This parameter supports Windows.

MONITORING_HEARTBEAT_TIMEOUT

Sets a process as non-responsive in a specified number of seconds.

UPREPORT

Determines how often process heartbeat messages are reported.

Manager parameters: Event management.

Parameter Description

DOWNREPORT

Controls the frequency for reporting stopped processes.

LAGCRITICAL

Specifies a lag threshold that is considered critical and generates a warning to the error log.

LAGINFO

Specifies a lag threshold at which an informational message is reported to the error log.

LAGREPORT

Sets an interval for reporting lag time to the error log.

Manager parameters: Maintenance.

Parameter Description

CHECKMINUTES

Determines how often Manager cycles through maintenance activities.

PURGEDDLHISTORY | PURGEDDLHISTORYALT

Purges rows from the Oracle DDL history table when they are no longer needed.

PURGEMARKERHISTORY

Purges Oracle marker table rows that are no longer needed.

PURGEOLDEXTRACTS for Extract and Replicat

Purges trail data that is no longer needed.

PURGEOLDEXTRACTS for Manager

Purges trail files when processing has finished; Oracle recommends use of this parameter rather than the PURGEOLDEXTRACTS for Extract and Replicat parameter.

PURGEOLDTASKS

Purges Extract and Replicat tasks after a specified period of time.

STARTUPVALIDATIONDELAY[CSECS]

Sets a delay time after which Manager checks that processes are still running after startup.

VERIDATAREPORTAGE

Purges old Veridata report files when they have reached the specified age limit.