Oracle GoldenGate Learning-- installation and configuration of AIX system
Oracle GoldenGate Learning-- installation and configuration of AIX system
System environment
Operating system: AIX5.3-09
DB Soft: Oracle 10gR2
As shown in the following figure:
The system environment is actually building an one-way OGG on the AIX system.
Download OGG:
Http://www.oracle.com/technetwork/cn/middleware/goldengate/downloads/index.html
< 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0Cached Transaction Size Distribution 0: 0 < 4K: 0 4K: 0 0 | 16K: 0 0 64K: 0 0 | 256K: 0 0 1M: 0 0 | 4M: 0 0 16M: 0 0 | 64M: 0 0 256M: 0 0 | 1G: 0 0 4G: 0 0 | 16G: 0 0 64G: 0 0 | 256G: 0 0 1T: 0 0 | 4T: 0 0 16T: 0 0 | 64T: 0 0 256T: 0 0 |1024T: 0 0================================================================================CUMULATIVE STATS FOR SUPERPOOLCACHE Transaction Statstrans active = 0 max concurrent = 0non-zero total = 0 trans total = 0CACHE File Cachingdisk current = 0 disk total = 0disk caching = 0 file cached = 0file retrieves = 0CACHE MANAGEMENTbuffer links = 0 anon gets = 0forced unmaps = 0 cnnbl try = 0cached out = 0 force out = 0Allocation Request Distribution< 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0Cached Transaction Size Distribution 0: 0 < 4K: 0 4K: 0 0 | 16K: 0 0 64K: 0 0 | 256K: 0 0 1M: 0 0 | 4M: 0 0 16M: 0 0 | 64M: 0 0 256M: 0 0 | 1G: 0 0 4G: 0 0 | 16G: 0 0 64G: 0 0 | 256G: 0 0 1T: 0 0 | 4T: 0 0 16T: 0 0 | 64T: 0 0 256T: 0 0 |1024T: 0 0QUEUE Statistics:num queues = 15 default index = 0cur len = 0 max len = 0q vm current = 0 vm max = 0q hits = 0 q misses = 0queue size q hits curlen maxlen cannibalized 0 64K 0 0 0 0 1 128K 0 0 0 0 2 256K 0 0 0 0 3 512K 0 0 0 0 4 1M 0 0 0 0 5 2M 0 0 0 0 6 4M 0 0 0 0 7 8M 0 0 0 0 8 16M 0 0 0 0 9 32M 0 0 0 0 10 64M 0 0 0 0 11 128M 0 0 0 0 12 256M 0 0 0 0 13 512M 0 0 0 0 14 1G 0 0 0 0================================================================================RUNTIME STATS FOR CACHE POOL #0POOL INFO group: rini_1 id: p475264_BLOBtrans active = 0 trans concurrent (max) = 0trans total = 0 (0 )flag = 0x00000030last error = (0=)Allocation Request Distribution< 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0================================================================================CUMULATIVE STATS FOR CACHE POOL #0POOL INFO group: rini_1 id: p475264_BLOBtrans active = 0 trans concurrent (max) = 0trans total = 0 (0 )flag = 0x00000030last error = (0=)Allocation Request Distribution< 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0QUEUE Statistics:num queues = 15 default index = 0cur len = 0 max len = 0q vm current = 0 vm max = 0q hits = 0 q misses = 0queue size q hits curlen maxlen cannibalized 0 64K 0 0 0 0 1 128K 0 0 0 0 2 256K 0 0 0 0 3 512K 0 0 0 0 4 1M 0 0 0 0 5 2M 0 0 0 0 6 4M 0 0 0 0 7 8M 0 0 0 0 8 16M 0 0 0 0 9 32M 0 0 0 0 10 64M 0 0 0 0 11 128M 0 0 0 0 12 256M 0 0 0 0 13 512M 0 0 0 0 14 1G 0 0 0 0================================================================================RUNTIME STATS FOR CACHE POOL #0POOL INFO group: rini_1 id: p475264_BLOBtrans active = 0 trans concurrent (max) = 0trans total = 0 (0 )flag = 0x00000030last error = (0=)Allocation Request Distribution< 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0================================================================================CUMULATIVE STATS FOR CACHE POOL #0POOL INFO group: rini_1 id: p475264_BLOBtrans active = 0 trans concurrent (max) = 0trans total = 0 (0 )flag = 0x00000030last error = (0=)Allocation Request Distribution< 128B: 0 128B: 0 0 | 512B: 0 0 2K: 0 0 | 8K: 0 0 32K: 0 0 | 128K: 0 0 512K: 0 0 | 2M: 0 0 8M: 0 0 | 32M: 0 0 128M: 0 0 | 512M: 0 0 2G: 0 0 | 8G: 0GGSCI (aix211) 3>
View the ogg log:
Source side (aix212)
[oracle@aix212@] $tail-f / ogg/ggserr.log 2014-09-23 15:25:24 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, pora_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.2014-09-23 15:25:24 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, pora_1.prm: Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/dirtmp.2014-09-23 15:25:24 INFO OGG-00993 Oracle GoldenGate Capture for Oracle Pora_1.prm: EXTRACT PORA_1 started.2014-09-23 15:25:30 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, pora_1.prm: Socket buffer size set to 27985 (flush size 27985). 2014-09-23 15:25:30 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, pora_1.prm: No recovery is required for target file. / dirdat/pa000000, at RBA 0 (file not opened). 2014-09-23 15:25:30 INFO OGG-01478 Oracle GoldenGate Capture for Oracle Pora_1.prm: Output file. / dirdat/pa is using format RELEASE 11.2.2014-09-23 15:47:44 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start eini-1.2014-09-23 15:47:51 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start eini_1.2014-09-23 15:47:51 INFO OGG-00963 Oracle GoldenGate Manager for Oracle Mgr.prm: Command received from GGSCI on host aix212 (START EXTRACT EINI_1). 2014-09-23 15:47:51 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EINI_1 starting.2014-09-23 15:47:51 INFO OGG-01017 Oracle GoldenGate Capture for Oracle, eini_1.prm: Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.2014-09-23 15:47:51 INFO OGG-00992 Oracle GoldenGate Capture for Oracle Eini_1.prm: EXTRACT EINI_1 starting.2014-09-23 15:47:51 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, eini_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.2014-09-23 15:47:51 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eini_1.prm: Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/dirtmp.2014-09-23 15:47:51 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, eini_1.prm: EXTRACT EINI_1 started.
Destination side (aix211)
[oracle@aix211 ogg] $tail-f ggserr.log 2014-09-23 15:26:58 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host aix211 (START REPLICAT RORA_1). 2014-09-23 15:26:58 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RORA_1 starting.2014-09-23 15:26:59 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle Rora_1.prm: REPLICAT RORA_1 starting.2014-09-23 15:26:59 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US_POSIX, LC_ALL:.2014-09-23 15:27:00 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, rora_1.prm: Virtual Memory Facilities for: COM anon alloc: mmap (MAP_ANON) anon free: munmap file alloc: mmap (MAP_SHARED) file free: munmap target directories: / ogg/dirtmp.2014-09-23 15:27:01 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, rora_1.prm: REPLICAT RORA_1 started.
IV. Synchronous testing
Source: 16:27:33 SCOTT@ orcl > select * from emp_ogg EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO--7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 1014 rows selected. 16:27:41 SCOTT@ orcl > update emp_ogg set deptno=40 where empno=7788;1 row updated. 16:28:06 SCOTT@ orcl > commit;Commit complete.target:16:26:31 SCOTT@ prod > truncate table emp_ogg;Table truncated. 16:26:44 SCOTT@ prod > select * from emp_ogg No rows selected 16:28:23 SCOTT@ prod > / EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO-- -7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 40 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC -81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 1014 rows selected.
@ at this point, the data synchronization on the destination side and the source side is successful, and the one-way transmission of OGG is basically configured!
