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 JANUARY 12, 2020
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]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
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//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=Name1.
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.
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//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=Name1.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |