OGG rep进程启动遇到sys.dbms_streams_adm_utl_invok.SET_FOO_TRIGGER_SESSION_CONTXT (fire=>TRUE);

来源：互联网发布：deepin ubuntu 编辑：程序博客网时间：2024/05/17 03:07

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:LinuxVersion #1 SMP Wed Nov 28 21:22:00 EST 2012, Release 2.6.18-348.el5Node: jjtestMachine: x86_64                         soft limit   hard limitAddress Space Size   :    unlimited    unlimitedHeap Size            :    unlimited    unlimitedFile Size            :    unlimited    unlimitedCPU Time             :    unlimited    unlimitedProcess id: 4585Description: *************************************************************************            Running with the following parameters                  *************************************************************************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_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 declaredORA-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 sysdbaSQL*Plus: Release 10.2.0.5.0 - Production on Sat May 16 09:13:06 2015Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit ProductionWith the Partitioning, 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                     YES YESSQL>

REP进程顺利启动。

0 0