OGG rep进程启动遇到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, 64bit (optimized), Oracle 10g on Oct  7 2011 04:39:32
 
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.


                    Starting at 2015-05-16 09:06:44
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Wed Nov 28 21:22:00 EST 2012, Release 2.6.18-348.el5
Node: jjtest
Machine: x86_64
                         soft limit   hard limit
Address Space Size   :    unlimited    unlimited
Heap Size            :    unlimited    unlimited
File Size            :    unlimited    unlimited
CPU Time             :    unlimited    unlimited

Process id: 4585

Description: 

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
replicat repzp
setenv ( NLS_LANG =  " AMERICAN_AMERICA.ZHS16GBK " )
Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

assumetargetdefs

userid goldengate, password ******

DBOPTIONS DEFERREFCONST, SUPPRESSTRIGGERS

Source Context :
  SourceModule            : [ggdb.ora.db]
  SourceID                : [/scratch/pradshar/view_storage/pradshar_bugdbrh40_12927937/oggcore/OpenSys/src/gglib/ggdbora/dboci.c]
  SourceFunction          : [suppressTriggers]
  SourceLine              : [5028]
  ThreadBacktrace         : [9] elements
                          : [/u02/ggs/replicat(CMessageContext::AddThreadContext()+0x26) [0x5f1e56]]
                          : [/u02/ggs/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned 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) [0x353f21d9c4]]
                          : [/u02/ggs/replicat(__gxx_personality_v0+0x1e2) [0x4e3ffa]]

2015-05-16 09:06:45  ERROR   OGG-00868  ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_STREAMS_ADM_UTL_INVOK' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored, SQL BEGIN sys.dbms_streams_adm_utl_invok.SET_FOO_TRIGGER_SESSION_CONTXT (fire=>TRUE); END;.

2015-05-16 09:06:45  ERROR   OGG-01668  PROCESS ABENDING.

在mos上搜到如下的文章：OGG Replicat Fails: "PLS-00201: identifier 'SYS.DBMS_XSTREAM_GG' must be declared" (Doc ID 1424951.1)

我这是10.2.0.5的db，不是11.2的db，于是就用下面的：

BEGIN 
 DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE( 
 grantee => 'GOLDENGATE', 
 grant_privileges => true); 
 END; 
 /

 

[oracle@jjtest ggs]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sat May 16 09:13:06 2015

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SELECT * FROM dba_streams_administrator; 

no rows selected

SQL> 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                     YES YES

SQL> 

 

REP进程顺利启动。