goldengate目的端应用序列出错:[ORA-06550: line 1, column 8: PLS-00201: identifier

implementing replication of cyclic sequences in GoldenGate [ID 1321558.1]

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
@ were never tested – hide, customer does not need to know this
and did not work seamlessly.
      

This note describes the proper implementation of replication of cyclic sequences.

Scope and Application

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.
      

implementing replication of cyclic sequences in GoldenGate

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 ;
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 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

[@more@]

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/161195/viewspace-1054575/,如需转载,请注明出处,否则将追究法律责任。

转载于:http://blog.itpub.net/161195/viewspace-1054575/

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值