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登录时忘记用户名或密码该如何解决

Oracle登录时忘记用户名或密码该如何解决

《Oracle登录时忘记用户名或密码该如何解决》：本文主要介绍如何在Oracle12c中忘记用户名和密码时找回或重置用户账户信息,文中通过代码介绍的非常详细,对同样遇到这个问题的同学具有一定的参... 目录一、忘记账户：二、忘记密码：三、详细情况情况 1：1.1. 登录到数据库1.2. 查看当前用户信息1.
阅读更多...
MySQL 中的服务器配置和状态详解(MySQL Server Configuration and Status)

MySQL 中的服务器配置和状态详解(MySQL Server Configuration and Status)

《MySQL中的服务器配置和状态详解(MySQLServerConfigurationandStatus)》MySQL服务器配置和状态设置包括服务器选项、系统变量和状态变量三个方面,可以通过... 目录mysql 之服务器配置和状态1 MySQL 架构和性能优化1.1 服务器配置和状态1.1.1 服务器选项
阅读更多...
oracle DBMS_SQL.PARSE的使用方法和示例

oracle DBMS_SQL.PARSE的使用方法和示例

《oracleDBMS_SQL.PARSE的使用方法和示例》DBMS_SQL是Oracle数据库中的一个强大包,用于动态构建和执行SQL语句,DBMS_SQL.PARSE过程解析SQL语句或PL/S... 目录语法示例注意事项DBMS_SQL 是 oracle 数据库中的一个强大包，它允许动态地构建和执行
阅读更多...
PLsql Oracle 下载安装图文过程详解

PLsql Oracle 下载安装图文过程详解

《PLsqlOracle下载安装图文过程详解》PL/SQLDeveloper是一款用于开发Oracle数据库的集成开发环境,可以通过官网下载安装配置,并通过配置tnsnames.ora文件及环境变... 目录一、PL/SQL Developer 简介二、PL/SQL Developer 安装及配置详解1.下
阅读更多...
CentOS系统Maven安装教程分享

CentOS系统Maven安装教程分享

《CentOS系统Maven安装教程分享》本文介绍了如何在CentOS系统中安装Maven,并提供了一个简单的实际应用案例,安装Maven需要先安装Java和设置环境变量,Maven可以自动管理项目的... 目录准备工作下载并安装Maven常见问题及解决方法实际应用案例总结Maven是一个流行的项目管理工具
阅读更多...
oracle如何连接登陆SYS账号

oracle如何连接登陆SYS账号

《oracle如何连接登陆SYS账号》在Navicat12中连接Oracle11g的SYS用户时,如果设置了新密码但连接失败,可能是因为需要以SYSDBA或SYSOPER角色连接,解决方法是确保在连接... 目录oracle连接登陆NmOtMSYS账号工具问题解决SYS用户总结oracle连接登陆SYS账号
阅读更多...
Oracle数据库如何切换登录用户(system和sys)

Oracle数据库如何切换登录用户(system和sys)

《Oracle数据库如何切换登录用户(system和sys)》文章介绍了如何使用SQL*Plus工具登录Oracle数据库的system用户,包括打开登录入口、输入用户名和口令、以及切换到sys用户的... 目录打开登录入口登录system用户总结打开登录入口win+R打开运行对话框，输php入：sqlp
阅读更多...
查询Oracle数据库表是否被锁的实现方式

查询Oracle数据库表是否被锁的实现方式

《查询Oracle数据库表是否被锁的实现方式》本文介绍了查询Oracle数据库表是否被锁的方法,包括查询锁表的会话、人员信息,根据object_id查询表名,以及根据会话ID查询和停止本地进程,同时,... 目录查询oracle数据库表是否被锁1、查询锁表的会话、人员等信息2、根据 object_id查询被
阅读更多...
解决Spring运行时报错:Consider defining a bean of type ‘xxx.xxx.xxx.Xxx‘ in your configuration

解决Spring运行时报错:Consider defining a bean of type ‘xxx.xxx.xxx.Xxx‘ in your configuration

《解决Spring运行时报错:Considerdefiningabeanoftype‘xxx.xxx.xxx.Xxx‘inyourconfiguration》该文章主要讲述了在使用S... 目录问题分析解决方案总结问题Description:Parameter 0 of constructor in x
阅读更多...
Oracle查询优化之高效实现仅查询前10条记录的方法与实践

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

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

Copyright China编程 23002807@qq.com

沪ICP备2023033072号-2