The OGG rep process started encountering Sys.dbms_streams_adm_utl_invok. Set_foo_trigger_session_contxt (fire=>true);

Ggsci (jjtest) 2> View report repzp*********************************************************************** Oracle GoldenGate Delivery for Oracle Version 11.1.1.1.2 oggcore_11.1.1.1.2_platforms_111004.2100 Linux, x64, 6 4bit (optimized), Oracle 10g on OCT 7 04:39:32 Copyright (C) 1995, and Oracle and/or its affiliates.                    All rights reserved. Starting at 2015-05-16 09:06:44***********************************************************************operating                         System version:linuxversion #1 SMP Wed Nov 21:22:00 EST., Release 2.6.18-348.el5node:jjtestmachine:x86_64 Soft limit hard limitaddress Space size:unlimited unlimitedheap size:unlimite D unlimitedfile size:unlimited unlimitedcpu time:unlimited unlimitedprocess ID: 4585Description: ************************************************************************* Running with the fol lowingParameters *************************************************************************replicat Repzpsetenv (Nls_lang = "American_america". ZHS16GBK ") Set environment variable (nls_lang=american_america.  ZHS16GBK) Assumetargetdefsuserid goldengate, password ******dboptions deferrefconst, Suppresstriggerssource Context: Sourcemodule: [ggdb.ora.db] SourceID: [/scratch/pradshar/view_storage/pradshar_bugdbrh40_1292 7937/OGGCORE/OPENSYS/SRC/GGLIB/GGDBORA/DBOCI.C] Sourcefunction: [Suppresstriggers] SourceLine: [ 5028] Threadbacktrace: [9] elements: [/u02/ggs/replicat (Cmessagecontext::addthreadcont Ext () +0x26) [0x5f1e56]]: [/u02/ggs/replicat (Cmessagefactory::createmessage (csourcecontext*, Unsi gned int, ...) +0X7B2) [0X5E88F2]: [/u02/ggs/replicat (_msg_err_db_generic_failure (csourcecontext*, Char const* , cmessagefactory::messagedisposition) +0X92) [0x5ad612]]: [/u02/ggs/replicat [0X8B37A6]]: [/u02/ggs/replicat (                          Odbc_param (char*, char*) +0xe65) [0x553535]]: [/u02/ggs/replicat [0x50075c]] : [/u02/ggs/replicat (MAIN+0X1D9) [0x507399]]: [/lib64/libc.so.6 (__libc_start_main+0xf4) [0x 353F21D9C4]]: [/u02/ggs/replicat (__GXX_PERSONALITY_V0+0X1E2) [0x4e3ffa]]2015-05-16 09:06:45 ERR OR OGG-00868 ora-06550:line 1, Column 7:pls-00201:identifier ' SYS. Dbms_streams_adm_utl_invok ' must be declaredora-06550:line 1, column 7:pl/sql:statement ignored, SQL BEGIN sys.dbms_stre Ams_adm_utl_invok. Set_foo_trigger_session_contxt (fire=>true); END;. 2015-05-16 09:06:45 ERROR OGG-01668 PROCESS abending.

The following article was found on MOS: OGG Replicat fails: "Pls-00201:identifier ' SYS." Dbms_xstream_gg ' must be declared ' (Doc ID 1424951.1)

This is 10.2.0.5 db, not 11.2 db, so use the following:

BEGIN  Dbms_streams_auth. Grant_admin_privilege (  grantee = ' GOLDENGATE ',  grant_privileges = true);  END;  /

[Email protected] ggs]$ sqlplus/as sysdbasql*plus:release 10.2.0.5.0-production on Sat may 09:13:06 2015Copyright (c) 1982, Oracle.  All rights reserved.connected to:oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit productionwith the part Itioning, OLAP, Data Mining and Real application testing optionssql> SELECT * from Dba_streams_administrator; No rows selectedsql> BEGIN   2   dbms_streams_auth. Grant_admin_privilege (   3   grantee = ' GOLDENGATE ',   4   grant_privileges = true);   5   END;   6   /pl/sql procedure successfully completed. Sql>  SELECT * from Dba_streams_administrator; USERNAME                       LOC ACC------------------------------------GOLDENGATE                     

The rep process starts smoothly.

The

OGG rep process started encountering Sys.dbms_streams_adm_utl_invok. Set_foo_trigger_session_contxt (fire=>true);