查看: 107|回复: 0

[笔记] Implementing replication of cyclic sequences in GoldenGate (文档 ID 1321558.1)

[复制链接]
论坛徽章:
2
Hadoop研习者初级
日期:2016-08-04 14:41:05Oracle研习者高级
日期:2019-07-25 14:10:03
发表于 2019-7-15 10:56 | 显示全部楼层 |阅读模式

SQL Oracle RAC DBA PL/SQL Goldengate

Implementing replication of cyclic sequences in GoldenGate (文档 ID 1321558.1)
跳至内容

My Oracle Support 徽标
PowerView 已关闭

宋章康 (可用)
  上次刷新时间: 2014-12-2 下午10:35 HKT(0)   
与我们联系
帮助

  

面板知识服务请求补丁程序和更新程序社区认证系统收集器高级客户服务设置
收藏夹  
近期搜索
全局搜索 全局搜索



文档显示

提供反馈...  
  
搜索: OGG-01444 Error in replicating sequence value [ORA-06550


还原窗格

单击此项可添加到收藏夹  Implementing replication of cyclic sequences in GoldenGate (文档 ID 1321558.1) 转到底部转到底部
In this Document
Purpose
Scope
Details
  References
APPLIES TO:
Oracle GoldenGate - Version 10.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 04-Feb-2013***
PURPOSE
OGG has added support for replication of cyclic sequences in the 11.1.1.1.x builds.
     
Backport: Any code prior to v11.1.1.x must contain patch 9428942 to reliably replicate cyclic sequences.
     
Documentation for versions 10.0, 10.4 and 11.1 states that extract supports sequences. In fact, sequences were not intended to be supported and did not work seamlessly.
This note describes the proper implementation of replication of cyclic sequences.
SCOPE
This covers the replication of cyclic sequences in the 11.1.1.1.x and subsequent builds.
   
Backport: Any code prior to v11.1.1.x must contain patch 9428942 to reliably replicate cyclic sequences.
Failure to use the right code version or to follow the implementation and installation procedures might result in a replicat abend with messages similar to this:
2011-04-20 17:35:53 ERROR OGG-01444 Oracle GoldenGate Delivery for Oracle, rora01.prm: Error in replicating sequence value [ORA-06550: line 1, column 8: PLS-00201: identifier 'GGS.REPLICATESEQUENCE' must be declared ORA-06550: line 1, column 8: PL/SQL: Statement ignored, SQL BEGIN "GGS" .replicateSequence (TO_NUMBER(1386506), TO_NUMBER(0), TO_NUMBER(1), 'XSUP', TO_NUMBER(0), 'SEQ_SR_ACCESSNO', 'GGS', TO_NUMBER(2), TO_NUMBER (0), ''); END;].
2011-04-20 17:35:53 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rora01.prm: PROCESS ABENDING.

DETAILS
Implementing cyclic sequences:

NOTE: You must be logged in as SYSDBA to install sequence.sql

Note that steps 1-3 are required on BOTH source and target.
1. If  an OGG User for DDL replication has been created,  proceed to Step 2. Otherwise, create OGG user (say OGGADMIN). This should be the same Oracle user used for DDL replication. Connect as SYSDBA to the Oracle database
SQL> CREATE USER OGGADMIN IDENTIFIED BY <password>;
SQL> GRANT CONNECT,RESOURCE,DBA TO OGGADMIN;
2. Install the SQL procedures needed to support sequence replication
SQL> sequence.sql
When prompted for the user name, enter the appropriate OGG user (OGGADMIN in this case)
3. Grant appropriate privileges to GGSCI user
SQL> GRANT EXECUTE on OGGADMIN.updateSequence TO ggsciUser; (user used to
login to GGSCI)
At the Target Database:
1. Grant appropriate privileges to Oracle Golden Gate Replicat User

SQL> GRANT EXECUTE on OGGADMIN.replicateSequence TO replicateUser;
FIRST USE:
----------
Before  starting to replicate sequences,  the following steps must be performed at the source database. . In the following steps,  assume the extract name is EXT01
1. Connect to the source database
GGSCI> DBLOGIN userid <GGSCI-user> Password:
2. Stop Extract, if it is running
GGSCI> STOP EXTRACT EXT01
3. Start Extract with appropriate parameter file that identifies thesequences to be replicated
GGSCI> START EXTRACT EXT01
4. Flush the sequences to be replicated using FLUSH SEQUENCE command in GGSCI
Example#1: To replicate all sequences contained in schemas HR and FINANCE
GGSCI> FLUSH SEQUENCE HR.*
GGSCI> FLUSH SEQUENCE FINANCE.*
Example#2 To replicate sequences for schemas HR.SEQ1 and HR.SEQ2
GGSCI> FLUSH SEQUENCE HR.SEQ1
GGSCI> FLUSH SEQUENCE HR.SEQ2
REFERENCES
BUG:11678726 - REPLICAT ABENDED WITH ORA-04002 FOR SEQUENCE WITH  NOCHECKSEQUENCEVALUE
@ BUG:11854609 - SEQUENCE SUPPORT DOCUMENTATION

Sequences will start to be maintained correctly once Extract has processed redo generated after the FLUSH SEQUENCE calls.
At both Source and Target Database:

  
文档详细信息

为此文档评级通过电子邮件发送此文档的链接在新窗口中打开文档可打印页

类型:
状态:
上次主更新:
上次更新:
BULLETIN
PUBLISHED
2013-2-5
2014-4-22

  
相关产品


Oracle GoldenGate
     
  
信息中心

  此文档无可用的信息中心。
     
  
文档引用

  此文档无可用的引用。
     
  
最近查看

Replicat Abends with &quot;OGG-01154 SQL error 1403 mapping&quot; [1329189.1]
Bequeath Connection Generates ORA-12560: TNS: Protocol Adapter Error [831007.1]
Bequeath connection sqlplus / as sysdba to a Pluggable database failed with ORA-12560 [1580696.1]
How to Perform Hot-site Maintenance Failover with GoldenGate [1397455.1]
10.2.0.4 "relink all" Or "relink precomp" Fails With "make: Fatal error: Don’t know how to make target `$ORACLE_HOME/precomp/lib/libpfo.a’ [567386.1]
显示更多
     

相关内容


产品

Middleware > Data Integration > GoldenGate > Oracle GoldenGate

关键字

CYCLIC;GOLDENGATE;INSTALL & CONFIGURE;INSTALLATION;PROCEDURES;SEQUENCE

错误

53 ERROR;ORA-4002;ORA-6550;PLS-201
返回页首返回页首
     

Copyright (c) 2014, Oracle. All rights reserved.
   
Legal Notices and Terms of Use
  
Privacy Statement


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册 新浪微博登陆

本版积分规则

 

GMT+8, 2019-9-20 11:26 , Processed in 0.202428 second(s), 32 queries .

关闭

扫一扫加入
本版微信群