Replicat process fails to start due to OGG-665 and ORA-439 on Oracle 11.2.0.1 SE/SE One (Doc ID 1936787.1)

Last updated on NOVEMBER 06, 2014

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 to 12.1.2.1.1 [Release 12.1]
Oracle Database - Standard Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Information in this document applies to any platform.

Symptoms

 Replicat process fails to start due to OGG-665 and ORA-439

2014-09-27 09:40:39 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep01.prm: REPLICAT REP01 starting.
2014-09-27 09:40:39 WARNING OGG-02904 Oracle GoldenGate Delivery for Oracle, rep01.prm: Replication of PARTIAL XML containing NCHAR/NVARCHAR/NCLOB data may cause divergence.
2014-09-27 09:40:39 INFO OGG-03059 Oracle GoldenGate Delivery for Oracle, rep01.prm: Operating system character set identified as US-ASCII.
2014-09-27 09:40:39 INFO OGG-02695 Oracle GoldenGate Delivery for Oracle, rep01.prm: ANSI SQL parameter syntax is used for parameter parsing.
2014-09-27 09:40:39 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep01.prm: Successfully set environment variable ORACLE_HOME=/home/se11201/app/oracle/product.
2014-09-27 09:40:39 INFO OGG-02095 Oracle GoldenGate Delivery for Oracle, rep01.prm: Successfully set environment variable ORACLE_SID=se11201.
2014-09-27 09:40:39 ERROR OGG-00665 Oracle GoldenGate Delivery for Oracle, rep01.prm: OCI Error executing single row select (status = 439-ORA-00439: : Streams Capture
ORA-06512: "SYS.DBMS_STREAMS", 16
), SQL<BEGIN dbms_streams.set_tag(:1); END;>.
2014-09-27 09:40:39 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep01.prm: PROCESS ABENDING.

 

Cause

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