Database Software

Hi,

Oracle streams capture process is not capturing any updates made on table for which capture & apply process are configured.

Capture process & apply process are running fine showing enabled as status & no error. But, No new records are captured in ‘streams_queue_table’ when I update record in table, which is configured for capturing changes.

This setup was working till I got ‘ORA-01341: LogMiner out-of-memory’ error in alert.log file. I guess logminer is not capturing the updates from redo log.

Current Alert log is showing following lines for logminer init process
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 3, Transaction Chunk Size = 1
LOGMINER: Memory Size = 10M, Checkpoint interval = 10M

But same log was like this before
LOGMINER: Parameters summary for session# = 1
LOGMINER: Number of processes = 3, Transaction Chunk Size = 1
LOGMINER: Memory Size = 10M, Checkpoint interval = 10M We can clearly see reader, builder & preparer process are not starting after I got Out of memory exception in log miner.

To allocate more space to logminer, I tried to setup tablespace to logminer I got 2 exception which was contradicting each other error.
SQL> exec DBMS_LOGMNR.END_LOGMNR();
BEGIN DBMS_LOGMNR.END_LOGMNR(); END;

*
ERROR at line 1: ORA-06512: at "SYS.DBMS_LOGMNR", line 76
ORA-06512: at line 1

SQL> EXECUTE DBMS_LOGMNR_D.SET_TABLESPACE('logmnrts');
BEGIN DBMS_LOGMNR_D.SET_TABLESPACE('logmnrts'); END;

*
ERROR at line 1: ORA-06512: at "SYS.DBMS_LOGMNR_D", line 232
ORA-06512: at line 1

When I tried stopping logminer exception was ‘no logminer session is active’, But when I tried to setup tablespace exception was ‘active logminer sessions found’. I am not sure how to resolve this issue.

Please let me know how to resolve this issue.

Thanks
siva