Please enable JavaScript to view this site.

2020/10/25

Oracle LogMiner Capture (SQDLOGM):

1.Oracle RAC for Oracle 11, 12 and 19 - Oracle 11 and 12 captures must have the --disable-continuous-mining parameter added to their Capture Configuration (.cab) files:

Syntax

 $ sqdconf modify <cab_file_name>

  --disable-continuous-mining

 

Keyword and Parameter Descriptions

<cab_file_name>  - Path and name of the Capture/Publisher Configuration (.cab) file.

  --disable-continuous-mining -  Oracle RAC capture only. This option instructs the Capture Agent not to use the Oracle LogMiner CONTINUOUS_MINE option which is not supported by Oracle 11 or 12 on a RAC system. The --disable-continuous-mining option is the default for Oracle version 19 on both RAC and non-RAC systems.

 

2.Oracle Capture now requires SELECT authority on V$THREAD in addition to the other existing LogMiner requirements.

3.Additional Oracle 19 stability improvements including tolerating ORA-1013 generated by user cancellation of the Capture agent.