Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration

2024-02-01 09:18
文章标签 oracle x86 10g configuration centos 64 4.8 11g solaris goldengate

本文主要是介绍Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

源端:
OS: Oracle Solaris 10 x86-64
DB: Oracle Database 11gR2(11.2.0.1)
IP: 192.168.106.164

同步表名: GGUSER.T_RSYNC








目标端:
OS: CentOS 4.8
DB: Oracle Database 10gR2(10.2.0.5)
IP: 192.168.106.161
同步表名 :GGTARGET.T_ISRSYNC









源端:安装goldengate
安装之前需要打开Oracle的supplemental log和force logging,将数据库设为Archive Mode

SQL> ALTER DATABASE force logging;DATABASE altered.SQL> ALTER DATABASE ADD supplemental log DATA;DATABASE altered.SQL> ALTER system switch logfile;System altered.
SQL> archive log list
DATABASE log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log SEQUENCE     7
NEXT log SEQUENCE TO archive   9
CURRENT log SEQUENCE           9
SQL>
-bash-3.2$ unzip Oracle\ GoldenGate\ V11.1.1.1.2\ for\ Oracle\ 11g\ 64bit\ on\ Solaris\ 10\ on\ x86-64.zip 
Archive:  Oracle GoldenGate V11.1.1.1.2 for Oracle 11g 64bit on Solaris 10 on x86-64.zipinflating: ggs_Solaris_x86_64_ora11g_64bit.tar  inflating: OGG_WinUnix_Rel_Notes_11 1 1 1 2.pdf  inflating: Oracle GoldenGate 11 1 1 1 README.txt  
-bash-3.2$ tar -xvof ggs_Solaris_x86_64_ora11g_64bit.tar
-bash-3.2$ ggsci -vOracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.-bash-3.2$
-bash-3.2$ ggsci Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.GGSCI (testdb) 1> CREATE subdirsCreating subdirectories UNDER CURRENT directory /u01/app/oracle/goldengateParameter files                /u01/app/oracle/goldengate/dirprm: created
Report files                   /u01/app/oracle/goldengate/dirrpt: created
Checkpoint files               /u01/app/oracle/goldengate/dirchk: created
Process STATUS files           /u01/app/oracle/goldengate/dirpcs: created
SQL script files               /u01/app/oracle/goldengate/dirsql: created
DATABASE definitions files     /u01/app/oracle/goldengate/dirdef: created
EXTRACT DATA files             /u01/app/oracle/goldengate/dirdat: created
TEMPORARY files                /u01/app/oracle/goldengate/dirtmp: created
Veridata files                 /u01/app/oracle/goldengate/dirver: created
Veridata LOCK files            /u01/app/oracle/goldengate/dirver/LOCK: created
Veridata Out-Of-Sync files     /u01/app/oracle/goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/goldengate/dirver/oosxml: created
Veridata Parameter files       /u01/app/oracle/goldengate/dirver/params: created
Veridata Report files          /u01/app/oracle/goldengate/dirver/report: created
Veridata STATUS files          /u01/app/oracle/goldengate/dirver/STATUS: created
Veridata Trace files           /u01/app/oracle/goldengate/dirver/trace: created
Stdout files                   /u01/app/oracle/goldengate/dirout: createdGGSCI (testdb) 2> exit


编辑manager参数文件,PORT为7809

-bash-3.2$ ggsci Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.GGSCI (testdb) 1> EDIT PARAMS MGR

启动MGR进程 

GGSCI (testdb) 2> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     STOPPED                                           GGSCI (testdb) 3> info mgrManager IS DOWN!GGSCI (testdb) 4> START MGRManager started.GGSCI (testdb) 5> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           GGSCI (testdb) 6> info mgrManager IS running (IP port testdb.7809).

-bash-3.2$ ps -ef|grep mgroracle  5865  5847   0 13:40:07 ?           0:00 ./mgr PARAMFILE /u01/app/oracle/goldengate/dirprm/mgr.prm REPORTFILE /u01/app/o

源端需要同步的表添加补充日志 

GGSCI (testdb) 1> dblogin userid system, password oracle
Successfully logged INTO DATABASE.GGSCI (testdb) 2> info trandata gguser.t_rsyncLogging OF supplemental redo log DATA IS disabled FOR TABLE GGUSER.T_RSYNC.GGSCI (testdb) 3> ADD trandata gguser.t_rsyncLogging OF supplemental redo DATA enabled FOR TABLE GGUSER.T_RSYNC.GGSCI (testdb) 4> info trandata gguser.t_rsyncLogging OF supplemental redo log DATA IS enabled FOR TABLE GGUSER.T_RSYNC




目标端ogg安装 

[oracle@joy goldengate]$ unzip Oracle\ GoldenGate\ V10.4.0.x\ FOR\ Oracle\ 10g\ ON\ RedHat\ 4.0.zip 
Archive:  Oracle GoldenGate V10.4.0.x FOR Oracle 10g ON RedHat 4.0.zipinflating: ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar  
[oracle@joy goldengate]$ tar -xvof ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar
[oracle@joy goldengate]$ ggsci -vOracle GoldenGate Command Interpreter FOR Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 ON Sep 17 2009 23:49:42Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.
[oracle@joy goldengate]$ ggsciOracle GoldenGate Command Interpreter FOR Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 ON Sep 17 2009 23:49:42Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.GGSCI (joy.localdomain) 1> CREATE subdirsCreating subdirectories UNDER CURRENT directory /u01/app/oracle/goldengateParameter files                /u01/app/oracle/goldengate/dirprm: created
Report files                   /u01/app/oracle/goldengate/dirrpt: created
Checkpoint files               /u01/app/oracle/goldengate/dirchk: created
Process STATUS files           /u01/app/oracle/goldengate/dirpcs: created
SQL script files               /u01/app/oracle/goldengate/dirsql: created
DATABASE definitions files     /u01/app/oracle/goldengate/dirdef: created
EXTRACT DATA files             /u01/app/oracle/goldengate/dirdat: created
TEMPORARY files                /u01/app/oracle/goldengate/dirtmp: created
Veridata files                 /u01/app/oracle/goldengate/dirver: created
Veridata LOCK files            /u01/app/oracle/goldengate/dirver/LOCK: created
Veridata Out-Of-Sync files     /u01/app/oracle/goldengate/dirver/oos: created
Veridata Out-Of-Sync XML files /u01/app/oracle/goldengate/dirver/oosxml: created
Veridata Parameter files       /u01/app/oracle/goldengate/dirver/params: created
Veridata Report files          /u01/app/oracle/goldengate/dirver/report: created
Veridata STATUS files          /u01/app/oracle/goldengate/dirver/STATUS: created
Veridata Trace files           /u01/app/oracle/goldengate/dirver/trace: created
Stdout files                   /u01/app/oracle/goldengate/dirout: created

编辑manager参数文件,PORT为7809 

GGSCI (joy.localdomain) 2> EDIT PARAMS MGR
PORT 7809

启动MGR进程 

GGSCI (joy.localdomain) 3> info mgrManager IS DOWN!GGSCI (joy.localdomain) 4> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     STOPPED                                           GGSCI (joy.localdomain) 5> START mgrManager started.GGSCI (joy.localdomain) 6> info mgrManager IS running (IP port joy.localdomain.7809).GGSCI (joy.localdomain) 7> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING





在源端配置Capture,添加一个extract组 

GGSCI (testdb) 2> ADD EXTRACT EORAJJ, TRANLOG, BEGIN NOW
EXTRACT added.GGSCI (testdb) 3> INFO EXTRACT EORAJJEXTRACT    EORAJJ    Initialized   2011-12-30 14:17   STATUS STOPPED
Checkpoint Lag       00:00:00 (updated 00:00:19 ago)
Log READ Checkpoint  Oracle Redo Logs2011-12-30 14:17:17  Seqno 0, RBA 0GGSCI (testdb) 4> INFO ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           
EXTRACT     STOPPED     EORAJJ      00:00:00      00:00:23

编辑extract参数文件 

GGSCI (testdb) 5> EDIT PARAMS EORAJJ
GGSCI (testdb) 6> VIEW params eorajjEXTRACT EORAJJ
USERID GGADMIN, PASSWORD ggadmin 
RMTHOST 192.168.106.161, MGRPORT 7809 
RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj 
TABLE GGUSER.T_RSYNC;

在源端添加目标端的trail文件 

GGSCI (testdb) 7> ADD RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj, EXTRACT EORAJJ, MEGABYTES 5
RMTTRAIL added.GGSCI (testdb) 8> INFO RMTTRAIL *EXTRACT Trail: /u01/app/oracle/goldengate/dirdat/jjEXTRACT: EORAJJSeqno: 0RBA: 0File SIZE: 5M

启动captrue进程 

GGSCI (testdb) 10> START EXTRACT EORAJJSending START request TO MANAGER ...
EXTRACT EORAJJ starting
GGSCI (testdb) 12> INFO EXTRACT EORAJJ, DETAILEXTRACT    EORAJJ    LAST Started 2011-12-30 14:28   STATUS RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:08 ago)
Log READ Checkpoint  Oracle Redo Logs2011-12-30 14:28:51  Seqno 9, RBA 10195456Target EXTRACT Trails:Remote Trail Name                                Seqno        RBA     MAX MB/u01/app/oracle/goldengate/dirdat/jj                 0        970          5EXTRACT SOURCE                          BEGIN             END             /u01/app/oracle/oradata/parmary_joydb/redo03.log  2011-12-30 14:17  2011-12-30 14:28NOT Available                           * Initialized *   2011-12-30 14:17CURRENT directory    /u01/app/oracle/goldengateReport file          /u01/app/oracle/goldengate/dirrpt/EORAJJ.rpt
Parameter file       /u01/app/oracle/goldengate/dirprm/eorajj.prm
Checkpoint file      /u01/app/oracle/goldengate/dirchk/EORAJJ.cpe
Process file         /u01/app/oracle/goldengate/dirpcs/EORAJJ.pce
Stdout file          /u01/app/oracle/goldengate/dirout/EORAJJ.OUT
Error log            /u01/app/oracle/goldengate/ggserr.logGGSCI (testdb) 13> INFO EXTRACT EORAJJEXTRACT    EORAJJ    LAST Started 2011-12-30 14:28   STATUS RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:05 ago)
Log READ Checkpoint  Oracle Redo Logs2011-12-30 14:30:04  Seqno 9, RBA 10201600
GGSCI (testdb) 14> VIEW REPORT EORAJJ***********************************************************************Oracle GoldenGate Capture FOR OracleVersion 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  5 2011 00:35:18Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.Starting at 2011-12-30 14:28:44
***********************************************************************Operating System Version:
SunOS
Version Generic_147441-01, Release 5.10
Node: testdb
Machine: i86pcsoft LIMIT   hard LIMIT
Address SPACE SIZE   :    unlimited    unlimited
Heap SIZE            :    unlimited    unlimited
File SIZE            :    unlimited    unlimited
CPU TIME             :    unlimited    unlimitedProcess id: 6111Description: ***********************************************************************
**            Running WITH the following parameters                  **
***********************************************************************
EXTRACT EORAJJ
USERID GGADMIN, PASSWORD *******
RMTHOST 192.168.106.161, MGRPORT 7809
RMTTRAIL /u01/app/oracle/goldengate/dirdat/jj
TABLE GGUSER.T_RSYNC;2011-12-30 14:28:44  INFO    OGG-01635  BOUNDED RECOVERY: reset TO initial OR altered checkpoint.Bounded Recovery Parameter:
Options    = BRRESET
BRINTERVAL = 4HOURS
BRDIR      = /u01/app/oracle/goldengateCACHEMGR virtual memory VALUES (may have been adjusted)
CACHEBUFFERSIZE:                         64K
CACHESIZE:                                2G
CACHEBUFFERSIZE (soft MAX):               4M
CACHEPAGEOUTSIZE (normal):                4M
PROCESS VM AVAIL FROM OS (MIN):        3.53G
CACHESIZEMAX (strict force TO disk):   3.13GDATABASE Version:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS FOR Solaris: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - ProductionDATABASE LANGUAGE AND CHARACTER SET:
NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK" 
NLS_LANGUAGE     = "AMERICAN" 
NLS_TERRITORY    = "AMERICA" 
NLS_CHARACTERSET = "ZHS16GBK" 2011-12-30 14:28:46  WARNING OGG-01423  No valid DEFAULT archive log destination directory found FOR thread 1.2011-12-30 14:28:46  INFO    OGG-01515  Positioning TO BEGIN TIME DEC 30, 2011 2:17:17 PM.2011-12-30 14:28:46  INFO    OGG-01516  Positioned TO SEQUENCE 9, RBA 9965072, DEC 30, 2011 2:17:17 PM.2011-12-30 14:28:51  INFO    OGG-01226  Socket buffer SIZE SET TO 27985 (FLUSH SIZE 27985).2011-12-30 14:28:51  INFO    OGG-01052  No recovery IS required FOR target file /u01/app/oracle/goldengate/dirdat/jj000000, at RBA 0 (file NOT opened).2011-12-30 14:28:51  INFO    OGG-01478  Output file /u01/app/oracle/goldengate/dirdat/jj IS USING format RELEASE 10.4/11.1.***********************************************************************
**                     Run TIME Messages                             **
***********************************************************************2011-12-30 14:28:51  INFO    OGG-01517  POSITION OF FIRST record processed SEQUENCE 9, RBA 9965072, SCN 0.1025011, DEC 30, 2011 2:17:49 PM.
GGSCI (testdb) 15> INFO ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           
EXTRACT     RUNNING     EORAJJ      00:00:00      00:00:09




在目标端配置Delivery进程,创建编辑GLOBALS参数,创建checkpointtable 

GGSCI (joy.localdomain) 1> EDIT PARAMS ./GLOBALSCHECKPOINTTABLE GGTARGET.ggckpttab
GGSCI (joy.localdomain) 1> dblogin userid system, password oracle
Successfully logged INTO DATABASE.GGSCI (joy.localdomain) 2> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           GGSCI (joy.localdomain) 3> ADD CHECKPOINTTABLENo checkpoint TABLE specified, USING GLOBALS specification (GGTARGET.ggckpttab)...Successfully created checkpoint TABLE GGTARGET.GGCKPTTAB.
GGTARGET@joydb:~>SELECT tname FROM tab;TNAME
------------------------------
T_ISRSYNC
GGCKPTTABGGTARGET@joydb:~>DESC ggckpttabName                                      NULL?    TYPE----------------------------------------- -------- ----------------------------GROUP_NAME                                NOT NULL VARCHAR2(8)GROUP_KEY                                 NOT NULL NUMBER(19)SEQNO                                              NUMBER(10)RBA                                       NOT NULL NUMBER(19)AUDIT_TS                                           VARCHAR2(29)CREATE_TS                                 NOT NULL DATELAST_UPDATE_TS                            NOT NULL DATECURRENT_DIR                               NOT NULL VARCHAR2(255)

配置Delivery,添加replicat组 

GGSCI (joy.localdomain) 4> ADD REPLICAT RORAJJ, EXTTRAIL /u01/app/oracle/goldengate/dirdat/jj
REPLICAT added.

创建编辑replicat参数文件 

GGSCI (joy.localdomain) 5> EDIT PARAMS RORAJJ
REPLICAT RORAJJ
USERID GGADMIN, PASSWORD ggadmin
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE /u01/app/oracle/goldengate/dirrpt/RORAJJ.DSC, PURGE
MAP GGUSER.T_RSYNC, TARGET GGTARGET.T_ISRSYNC;
GGSCI (joy.localdomain) 7> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           
REPLICAT    STOPPED     RORAJJ      00:00:00      00:04:55

启动replicat进程 

GGSCI (joy.localdomain) 8> START REPLICAT RORAJJSending START request TO MANAGER ...
REPLICAT RORAJJ startingGGSCI (joy.localdomain) 9> INFO ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           
REPLICAT    RUNNING     RORAJJ      00:00:00      00:00:05




验证数据同步


源端

-bash-3.2$ ggsci Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct  4 2011 23:54:06Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.GGSCI (testdb) 1> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           
EXTRACT     RUNNING     EORAJJ      00:00:00      00:00:10    
-bash-3.2$ sqlplus gguser/gguserSQL*Plus: Release 11.2.0.1.0 Production ON Fri DEC 30 15:00:05 2011Copyright (c) 1982, 2009, Oracle.  ALL rights reserved.Connected TO:
Oracle DATABASE 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing optionsSQL> INSERT INTO t_rsync2  VALUES(3  1,'Weicheng Zhong','Oracle Database 10g OCP,Oracle GoldenGate 10 Certified Implementation Specialist');1 ROW created.SQL> commit;Commit complete.

目标端 

[oracle@joy goldengate]$ ggsci Oracle GoldenGate Command Interpreter FOR Oracle
Version 10.4.0.19 Build 002
Linux, x86, 32bit (optimized), Oracle 10 ON Sep 17 2009 23:49:42Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.GGSCI (joy.localdomain) 1> info ALLProgram     STATUS      GROUP       Lag           TIME Since ChkptMANAGER     RUNNING                                           
REPLICAT    RUNNING     RORAJJ      00:00:00      00:00:03   
[oracle@joy goldengate]$ sqlplus ggtarget/ggtargetSQL*Plus: Release 10.2.0.5.0 - Production ON Fri DEC 30 15:07:28 2011Copyright (c) 1982, 2010, Oracle.  ALL Rights Reserved.Connected TO:
Oracle DATABASE 10g Enterprise Edition Release 10.2.0.5.0 - Production
WITH the Partitioning, OLAP, DATA Mining AND REAL Application Testing optionsGGTARGET@joydb:~>SET linesize 150
GGTARGET@joydb:~>col rname format a15
GGTARGET@joydb:~>col rdesc format a81
GGTARGET@joydb:~>SELECT * FROM t_isrsync;RID RNAME           RDESC
---------- --------------- ---------------------------------------------------------------------------------1 Weicheng Zhong  Oracle DATABASE 10g OCP,Oracle GoldenGate 10 Certified Implementation Specialist

同步成功 

[oracle@joy goldengate]$ logdump Oracle GoldenGate Log File Dump Utility
Version 10.4.0.19 Build 002Copyright (C) 1995, 2009, Oracle AND/OR its affiliates.  ALL rights reserved.Logdump 1 >OPEN /u01/app/oracle/goldengate/dirdat/jj000000
CURRENT LogTrail IS /u01/app/oracle/goldengate/dirdat/jj000000 
Logdump 2 >ghdr ON
Logdump 3 >headertoken ON
Logdump 4 >usertoken ON
Logdump 5 >detail ON
Logdump 6 >detail DATA
Logdump 8 >n
TokenID x47 'G' Record Header    Info x01  LENGTH  235 
TokenID x48 'H' GHDR             Info x00  LENGTH   49 
TokenID x44 'D' DATA             Info x00  LENGTH  119 
TokenID x54 'T' GGS Tokens       Info x00  LENGTH   47 
TokenID x5a 'Z' Record Trailer   Info x01  LENGTH  235 
___________________________________________________________________ 
Hdr-Ind    :     E  (x45)     Partition  :     .  (x04)  
UndoFlag   :     .  (x00)     BeforeAfter:     A  (x41)  
RecLength  :   119  (x0077)   IO TIME    : 2011/12/30 15:03:39.368.781   
IOType     :     5  (x05)     OrigNode   :   255  (xff) 
TransInd   :     .  (x03)     FormatType :     R  (x52) 
SyskeyLen  :     0  (x00)     Incomplete :     .  (x00) 
AuditRBA   :          9       AuditPos   : 12447248 
Continued  :     N  (x00)     RecCount   :     1  (x01) 2011/12/30 15:03:39.368.781 INSERT               Len   119 RBA 970 
Name: GGUSER.T_RSYNC 
After  Image:                                             Partition 4   G  s   0000 0005 0000 0001 3100 0100 1200 0000 0e57 6569 | ........1........Wei  6368 656e 6720 5a68 6f6e 6700 0200 5400 0000 504f | cheng Zhong...T...PO  7261 636c 6520 4461 7461 6261 7365 2031 3067 204f | racle DATABASE 10g O  4350 2c4f 7261 636c 6520 476f 6c64 656e 4761 7465 | CP,Oracle GoldenGate  2031 3020 4365 7274 6966 6965 6420 496d 706c 656d |  10 Certified Implem  656e 7461 7469 6f6e 2053 7065 6369 616c 6973 74   | entation Specialist  
COLUMN     0 (x0000), Len     5 (x0005)  0000 0001 31                                      | ....1  
COLUMN     1 (x0001), Len    18 (x0012)  0000 000e 5765 6963 6865 6e67 205a 686f 6e67      | ....Weicheng Zhong  
COLUMN     2 (x0002), Len    84 (x0054)  0000 0050 4f72 6163 6c65 2044 6174 6162 6173 6520 | ...POracle DATABASE   3130 6720 4f43 502c 4f72 6163 6c65 2047 6f6c 6465 | 10g OCP,Oracle Golde  6e47 6174 6520 3130 2043 6572 7469 6669 6564 2049 | nGate 10 Certified I  6d70 6c65 6d65 6e74 6174 696f 6e20 5370 6563 6961 | mplementation Specia  6c69 7374                                         | list  Logdump 9 >n
Logdump 10 >n
Logdump 11 >


















这篇关于Oracle GoldenGate for Oracle 11g(Solaris 10 x86-64) to Oracle 10g(CentOS 4.8) configuration的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！


http://www.chinasem.cn/article/666797。

相关文章

Oracle查询优化之高效实现仅查询前10条记录的方法与实践

Oracle查询优化之高效实现仅查询前10条记录的方法与实践

《Oracle查询优化之高效实现仅查询前10条记录的方法与实践》：本文主要介绍Oracle查询优化之高效实现仅查询前10条记录的相关资料,包括使用ROWNUM、ROW_NUMBER()函数、FET... 目录1. 使用 ROWNUM 查询2. 使用 ROW_NUMBER() 函数3. 使用 FETCH FI
阅读更多...
数据库oracle用户密码过期查询及解决方案

数据库oracle用户密码过期查询及解决方案

《数据库oracle用户密码过期查询及解决方案》：本文主要介绍如何处理ORACLE数据库用户密码过期和修改密码期限的问题,包括创建用户、赋予权限、修改密码、解锁用户和设置密码期限,文中通过代码介绍... 目录前言一、创建用户、赋予权限、修改密码、解锁用户和设置期限二、查询用户密码期限和过期后的修改1.查询用
阅读更多...
Oracle数据库使用 listagg去重删除重复数据的方法汇总

Oracle数据库使用 listagg去重删除重复数据的方法汇总

《Oracle数据库使用listagg去重删除重复数据的方法汇总》文章介绍了在Oracle数据库中使用LISTAGG和XMLAGG函数进行字符串聚合并去重的方法,包括去重聚合、使用XML解析和CLO... 目录案例表第一种：使用wm_concat() + distinct去重聚合第二种：使用listagg，
阅读更多...
oracle中exists和not exists用法举例详解

oracle中exists和not exists用法举例详解

《oracle中exists和notexists用法举例详解》：本文主要介绍oracle中exists和notexists用法的相关资料,EXISTS用于检测子查询是否返回任何行,而NOTE... 目录基本概念：举例语法pub_name总结 exists （sql 返回结果集为真）not exists (s
阅读更多...
Oracle的to_date()函数详解

Oracle的to_date()函数详解

《Oracle的to_date()函数详解》Oracle的to_date()函数用于日期格式转换,需要注意Oracle中不区分大小写的MM和mm格式代码,应使用mi代替分钟,此外,Oracle还支持毫... 目录oracle的to_date()函数一.在使用Oracle的to_date函数来做日期转换二.日
阅读更多...
oracle数据库索引失效的问题及解决

oracle数据库索引失效的问题及解决

《oracle数据库索引失效的问题及解决》本文总结了在Oracle数据库中索引失效的一些常见场景,包括使用isnull、isnotnull、!=、、、函数处理、like前置%查询以及范围索引和等值索引... 目录oracle数据库索引失效问题场景环境索引失效情况及验证结论一结论二结论三结论四结论五总结ora
阅读更多...
Oracle Expdp按条件导出指定表数据的方法实例

Oracle Expdp按条件导出指定表数据的方法实例

《OracleExpdp按条件导出指定表数据的方法实例》：本文主要介绍Oracle的expdp数据泵方式导出特定机构和时间范围的数据,并通过parfile文件进行条件限制和配置,文中通过代码介绍... 目录1.场景描述 2.方案分析3.实验验证 3.1 parfile文件3.2 expdp命令导出4.总结
阅读更多...
Oracle数据库执行计划的查看与分析技巧

Oracle数据库执行计划的查看与分析技巧

《Oracle数据库执行计划的查看与分析技巧》在Oracle数据库中,执行计划能够帮助我们深入了解SQL语句在数据库内部的执行细节,进而优化查询性能、提升系统效率,执行计划是Oracle数据库优化器为... 目录一、什么是执行计划二、查看执行计划的方法（一）使用 EXPLAIN PLAN 命令（二）通过 S
阅读更多...
CentOS系统使用yum命令报错问题及解决

CentOS系统使用yum命令报错问题及解决

《CentOS系统使用yum命令报错问题及解决》文章主要讲述了在CentOS系统中使用yum命令时遇到的错误,并提供了个人解决方法,希望对大家有所帮助,并鼓励大家支持脚本之家... 目录Centos系统使用yum命令报错找到文件替换源文件为总结CentOS系统使用yum命令报错http://www.cppc
阅读更多...
《x86汇编语言：从实模式到保护模式》视频来了

《x86汇编语言：从实模式到保护模式》视频来了

《x86汇编语言：从实模式到保护模式》视频来了 很多朋友留言，说我的专栏《x86汇编语言：从实模式到保护模式》写得很详细，还有的朋友希望我能写得更细，最好是覆盖全书的所有章节。 毕竟我不是作者，只有作者的解读才是最权威的。 当初我学习这本书的时候，只能靠自己摸索，网上搜不到什么好资源。 如果你正在学这本书或者汇编语言，那你有福气了。 本书作者李忠老师，以此书为蓝本，录制了全套视频。 试
阅读更多...

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2