goldengate目的端應用序列出錯:[ORA-06550: line 1, column 8: PLS-00201: identifier
implementing replication of cyclic sequences in GoldenGate [ID 1321558.1]
2. Install the SQL procedures needed to support sequence replication
When prompted for the user name, enter the appropriate OGG user (OGGADMIN in this case)3. Grant appropriate privileges to GGSCI user
At the Target Database:1. Grant appropriate privileges to Oracle Golden Gate Replicat User
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 EXT011. Connect to the source database
2. Stop Extract, if it is running
3. Start Extract with appropriate parameter file that identifies thesequences to be replicated
4. Flush the sequences to be replicated using FLUSH SEQUENCE command in GGSCIExample#1: To replicate all sequences contained in schemas HR and FINANCE
Example#2 To replicate sequences for schemas HR.SEQ1 and HR.SEQ2
[@more@]
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 databaseSQL> CREATE USER OGGADMIN IDENTIFIED BY ;
SQL> GRANT CONNECT,RESOURCE,DBA TO OGGADMIN;
SQL> sequence.sql
SQL> GRANT EXECUTE on OGGADMIN.updateSequence TO ggsciUser; (user used to
login to GGSCI)
SQL> GRANT EXECUTE on OGGADMIN.replicateSequence TO replicateUser;
GGSCI> DBLOGIN userid Password:
GGSCI> STOP EXTRACT EXT01
GGSCI> START EXTRACT EXT01
GGSCI> FLUSH SEQUENCE HR.*
GGSCI> FLUSH SEQUENCE FINANCE.*
GGSCI> FLUSH SEQUENCE HR.SEQ1
GGSCI> FLUSH SEQUENCE HR.SEQ2
[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1054575/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Postgre 中列出Column情報的命令
- goldengate 目的端程式引數APPLYNOOPUPDATES 和ALLOWNOOPUPDATESGoAPPOOP
- Error: PLS-00201: identifier 'DBMS_AQ'must be declaredErrorIDE
- 使用goldengate時,絕對禁止前臺應用程式連線目的庫Go
- goldengate 目的端replicat程式 執行緩慢的問題Go
- 解決一個小坑:error on line 1 at column 1: Document is emptyError
- PLS-00201: identifier 'MGMT_TIME_SYNC.STARTUPSYNC' must be declaredIDE
- oracle goldengate 複製端延時應用引數OracleGo
- 配置GoldenGate捕獲Replicat端資料應用異常Go
- goldengate 配置源頭 scott.* 到目的端scott2.*時,只是在目的端rep程式引數檔案中指定即可Go
- python json讀取資料:ValueError: Extra data: line 77 column 2 - line 16485 column 1 (char 1159 - 227243)PythonJSONError
- 應用序 or 正則序?
- GoldenGate 不支援從oracle 11g的 active dataguard 目的端進行extractGoOracle
- PbootCMS執行SQL發生錯誤!錯誤:no such column: def1bootSQL
- Excel Sheet Column Number Excel表列序號Excel
- expected '', but found BlockMappingStart in 'reader', line 13, column 1:nimbus.host:BloCAPP
- PbootCMS錯誤提示:執行SQL發生錯誤!錯誤:no such column: def1bootSQL
- 關於goldengate無主鍵表的update的同步(源端和目的端列數不一樣多)Go
- 【GoldenGate】Oracle GoldenGate Veridata 安裝配置與應用GoOracle
- 通過終端除錯 AngularJS 應用除錯AngularJS
- goldengate 目的端同步無主鍵無索引表時的rpt日誌(做update操作)Go索引
- ORA-06550錯誤程式碼的解決方法QB
- 錯誤:duplicate column name: picstitle
- 使用 Eclipse 遠端除錯 Java 應用程式Eclipse除錯Java
- Line註冊使用者數已超1億 向全球推出Line群組應用
- “工程結算”科目的實施與應用(轉)
- flutter佈局-1-columnFlutter
- 【原創】goldengate 目的端rep複製程式 遇到ora-00001 異常終止abend的血案Go
- 順序表應用8:最大子段和之動態規劃法動態規劃
- 使用 Eclipse 遠端除錯 Java 應用程式(mark)Eclipse除錯Java
- “工程結算”科目的實施與應用(2)(轉)
- 順序表應用5:有序順序表歸併
- 順序表應用6:有序順序表查詢
- rman duplicate出現PLS-00201錯誤解決
- Python 錯誤 SyntaxError: invalid character in identifierPythonErrorIDE
- 遠端除錯在Linux車機中的應用除錯Linux
- Vue進階(么伍么):el-table-column :key應用Vue
- GoldenGate 12.2 支援不可見列invisible column的複製Go