My Oracle Support Banner

OGG-13004 PROCEDURETRANDATA operation failed because of the following SQL error: {1} (Doc ID 2648258.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle GoldenGate - Version 12.3.0.1.0 and later
Information in this document applies to any platform.

Symptoms

Failed to enable supplemental logging for procedural replication:

GGSCI >  ADD   PROCEDURETRANDATA

2020-03-12 01:28:01  ERROR   OGG-13004  PROCEDURETRANDATA operation failed because of the following SQL error: {1}.

 

"ADD   PROCEDURETRANDATA"  equals to  "alter database add supplemental log data for procedural replication;"

 

If you login that OGG user and run it manually , you will get the correct error message.

SQL> alter database add supplemental log data for procedural replication;
alter database add supplemental log data for procedural replication
*
ERROR at line 1:
ORA-01031: insufficient privileges

 

You can run below command to check if supplemental logging for procedural replication is enabled or not:

 

GGSCI > info PROCEDURETRANDATA

2020-03-12 01:42:57  INFO    OGG-13007  Procedure level supplemental logging is enabled.

Or

SQL> SET SERVEROUTPUT ON
DECLARE
  on_or_off   NUMBER;
BEGIN
  on_or_off := DBMS_GOLDENGATE_ADM.GG_PROCEDURE_REPLICATION_ON;
  IF on_or_off=1 THEN
    DBMS_OUTPUT.PUT_LINE('Oracle GoldenGate procedural replication is ON.');
  ELSE
    DBMS_OUTPUT.PUT_LINE('Oracle GoldenGate procedural replication is OFF.');
  END IF;
END;
/
SQL>  Oracle GoldenGate procedural replication is ON.

PL/SQL procedure successfully completed.

Or

SQL>  select * from dba_supplemental_logging;

MIN PRI UNI FOR ALL PRO
--- --- --- --- --- ---
YES NO  NO  NO  NO  YES

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.