My Oracle Support Banner

Oracle Database 11.2.0.1 SE/SE One の環境で Replicat プロセスの起動が OGG-665/ORA-439 のエラーにより失敗する (Doc ID 1936788.1)

Last updated on AUGUST 04, 2018

適用範囲:

Oracle GoldenGate - バージョン 12.1.2.0.0 から 12.1.2.1.1 [リリース 12.1]
Oracle Database - Standard Edition - バージョン 11.2.0.1 から 11.2.0.1 [リリース 11.2]
この文書の内容はすべてのプラットフォームに適用されます。

現象

Replicat プロセスの起動時に OGG-665 と 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.

 

原因

To view full details, 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 a vibrant support community of peers and Oracle experts.