Streams Capture Aborted as Logminer process Recieves ORA-1652 (Doc ID 1542512.1)

Last updated on APRIL 08, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.

Goal

Streams capture aborted with following error:

error 1280 in STREAMS process
ORA-01280: Fatal LogMiner Error.
OPIRIP: Uncaught error 447. Error stack:
ORA-00447: fatal error in background process
ORA-01280: Fatal LogMiner Error.

 

On checking the alert log shows-

 

Thu Mar 28 22:00:15 2013
ORA-1652: unable to extend temp segment by 128 in tablespace                 TEMP
Thu Mar 28 22:00:15 2013
krvxerpt: Errors detected in process 87, role builder.
Thu Mar 28 22:00:15 2013
krvxmrs: Leaving by exception: 604
Thu Mar 28 22:00:15 2013
Errors in file /u01/app/oracle/admin/DB2P/bdump/db01_p003_5139.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms