GGSCI (jjtest) 2> view report repzp***********************************************************************Oracle GoldenGate Delivery for OracleVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100Linux, 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_64soft 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;USERNAMELOC ACC—————————— — —GOLDENGATEYES YESSQL>
REP进程顺利启动。
接受失败，是我们不常听到或看到的一个命题，
