Oracle Goldengate Combat Installation

Ora-00845:memory_target not supported on the This system Error Resolution

# mount-t Tmpfs shmfs-o Size=7g/dev/shm

2. to make sure that the operating system restarts, the /etc/fstab file needs to be modified

Shmfs/dev/shm TMPFS size=7g 0

Implementation environment

Source-Side 172.16.0.173 oracle173

Target Side 172.16.0.174 oracle174

OGG Pre-Installation Preparation

put two Oracle Install the environment after the installation of 650) this.width=650; "title=" ogg01.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/69/ Wkiom1pap6lzasjraaatobgsfvu417.jpg "alt=" wkiom1pap6lzasjraaatobgsfvu417.jpg "/> decompression 650) this.width=650;" Title= "Ogg02.jpg" src= "http://s3.51cto.com/wyfs02/M02/43/6A/wKioL1PaQMvDaiO9AAEJnSs6-wY406.jpg" alt= " Wkiol1paqmvdaio9aaejnss6-wy406.jpg "/>

put ogg uploaded to /u01/app/ set permissions under Directory chown-r Oracle:oinstall/u01/app/ogg

Chmod-r +x/u01/app/ogg

650) this.width=650; "title=" ogg03.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/69/ Wkiom1pap7-i27xcaab9oh5luka988.jpg "alt=" Wkiom1pap7-i27xcaab9oh5luka988.jpg "/>

650) this.width=650; "title=" ogg04.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiol1paqomgdof6aabnm03omoo201.jpg "alt=" Wkiol1paqomgdof6aabnm03omoo201.jpg "/>

Set environment variables,

installation on source and target side GoldenGate

Enter the operating system command line, go to the installation path, execute:

Source-Side Steps

650) this.width=650; "title=" ogg05.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiol1paqpuism3caaeom0w1qqa600.jpg "alt=" Wkiol1paqpuism3caaeom0w1qqa600.jpg "/>

650) this.width=650; "title=" ogg06.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/wKiom1PaP--CZ7XcAAF7Bcc_ Brm515.jpg "alt=" Wkiom1pap--cz7xcaaf7bcc_brm515.jpg "/>

650) this.width=650; "title=" ogg07.jpg "src=" Http://s3.51cto.com/wyfs02/M02/43/6A/wKioL1PaQTLwCHyvAAAo_ Wek3wc800.jpg "alt=" Wkiol1paqtlwchyvaaao_wek3wc800.jpg "/>

650) this.width=650; "title=" ogg08.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiom1paqcxtjlaraacxzxhjup0713.jpg "alt=" Wkiom1paqcxtjlaraacxzxhjup0713.jpg "/>

650) this.width=650; "title=" ogg09.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/wKioL1PaQUzCcmCYAACjrbB_ Pr0193.jpg "alt=" Wkiol1paquzccmcyaacjrbb_pr0193.jpg "/>

Target-Side steps

650) this.width=650; "title=" ogg10.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiol1paqfdjihe9aaezm7hc890578.jpg "alt=" wkiol1paqfdjihe9aaezm7hc890578.jpg "/>650) this.width=650;" Title= " Ogg11.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/wKiom1PaQOTBywzLAAG_00j12rM085.jpg "alt=" Wkiom1paqotbywzlaag_00j12rm085.jpg "/>

650) this.width=650; "title=" ogg12.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiom1paqplzit--aaauz-unala101.jpg "alt=" wkiom1paqplzit--aaauz-unala101.jpg "/>

650) this.width=650; "title=" ogg13.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiol1paqhbhpgcxaacapkiglo4535.jpg "alt=" Wkiol1paqhbhpgcxaacapkiglo4535.jpg "/>

650) this.width=650; "title=" ogg14.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiom1paqqjsncluaaap6rtu6gm339.jpg "alt=" Wkiom1paqqjsncluaaap6rtu6gm339.jpg "/>

650) this.width=650; "title=" ogg15.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiol1paqjcchuxaaacvn5anht0405.jpg "alt=" Wkiol1paqjcchuxaaacvn5anht0405.jpg "/>

GoldenGate Synchronization Configuration

Oracle with the Oracle synchronization between

Source-side Oracle Database Settings

First create goldengate a dedicated database user.

sql> Create user GGs identified by GGs; -- Create a database user

650) this.width=650; "title=" ogg16.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiom1paqxsysbcxaaaq5ss9wo8507.jpg "alt=" Wkiom1paqxsysbcxaaaq5ss9wo8507.jpg "/>

sql> Grant DBA to GGs; -- Give GGs User-given DBA Permissions

650) this.width=650; "title=" ogg17.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiom1paqysqnevkaaa3c9cdojc463.jpg "alt=" Wkiom1paqysqnevkaaa3c9cdojc463.jpg "/>

Oracle the database needs to have the archive log turned on and the minimum additional log mode turned on.

sql> Select Supplemental_log_data_min from V$database; -- See if minimum additional log mode is turned on

sql> ALTER DATABASE add supplemental log data; -- turn on minimum additional log mode

650) this.width=650; "title=" ogg18.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiol1paqsohc1usaadz4to-up4518.jpg "alt=" Wkiol1paqsohc1usaadz4to-up4518.jpg "/>

in real production applications, it is best to open simultaneously ORACLE forced log mode to prevent the source database from being ignored by direct path loading Redo This part of the data cannot be synchronized:

Sql> select force_logging from V$database;

sql> Alter database force logging;

650) this.width=650; "title=" ogg19.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiom1paqgyqismlaacahthaufu511.jpg "alt=" Wkiom1paqgyqismlaacahthaufu511.jpg "/>

light on minimum additional log mode is not enough, you need to GoldenGate in Use Add Trandata The command forces redo logging primary key values to ensure successful replication on the target side:

ggsci> dblogin userid ggs,password ggs --goldengate Sign In oarcle Database

ggsci>add trandata dssc.<tablename> -- table names can be used with wildcard characters

650) this.width=650; "title=" ogg20.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiom1paqjqt60z1aadewjeyz04655.jpg "alt=" Wkiom1paqjqt60z1aadewjeyz04655.jpg "/>

Target side

650) this.width=650; "title=" ogg21.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiol1paq7irvqogaabveipwtzo999.jpg "alt=" Wkiol1paq7irvqogaabveipwtzo999.jpg "/>

Configure DML Sync

on the source side configuration Extract Process

650) this.width=650; "title=" ogg22.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiom1paqsurdw0-aad-cmieopy255.jpg "alt=" Wkiom1paqsurdw0-aad-cmieopy255.jpg "/>

Configuration TTEXTL and the Exttrail the correspondence between

650) this.width=650; "title=" ogg23.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiom1paqvtgzsbiaadfhssigq4102.jpg "alt=" Wkiom1paqvtgzsbiaadfhssigq4102.jpg "/>

on the source side configuration Pump Process

650) this.width=650; "title=" ogg24.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiom1paqx6xvmxuaacpnce9v-s344.jpg "alt=" Wkiom1paqx6xvmxuaacpnce9v-s344.jpg "/>

650) this.width=650; "title=" ogg25.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiol1pargjsbbu2aacwylppcv4963.jpg "alt=" Wkiol1pargjsbbu2aacwylppcv4963.jpg "/>

Configuration ttextr and the Rmttrail the correspondence between

650) this.width=650; "title=" ogg26.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/wKioL1PaRJixTJEIAABsPuyl7_8693. JPG "alt=" wkiol1parjixtjeiaabspuyl7_8693.jpg "/>

configure on the target side Replicat Process

to be Replicat Process Add Checkpoint Table ,

650) this.width=650; "title=" ogg27.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/wKioL1PaRM_ Rhlcoaabzrab12bo203.jpg "alt=" Wkiol1parm_rhlcoaabzrab12bo203.jpg "/>

on the target side of the ogg under Software catalog :

650) this.width=650; "title=" ogg28.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiol1parrvrvmw2aae-0ujerh8100.jpg "alt=" Wkiol1parrvrvmw2aae-0ujerh8100.jpg "/>

650) this.width=650; "title=" ogg29.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/wKioL1PaRUvjdwVXAAD4ZPLu_ C4292.jpg "alt=" Wkiol1paruvjdwvxaad4zplu_c4292.jpg "/>

exception handling, the exception table needs to be on the target side of the GGs manually established under the User:

650) this.width=650; "title=" ogg30.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiom1parhnisqwiaagvnzfqlkg374.jpg "alt=" Wkiom1parhnisqwiaagvnzfqlkg374.jpg "/>

650) this.width=650; "title=" ogg31.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiol1pardtzl9ecaajwjbwyoy4038.jpg "alt=" wkiol1pardtzl9ecaajwjbwyoy4038.jpg "/>

Start the source side

650) this.width=650; "title=" ogg32.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiom1parpoyra8haafgueemcbs142.jpg "alt=" Wkiom1parpoyra8haafgueemcbs142.jpg "/>

Start the target side

650) this.width=650; "title=" ogg33.jpg "src=" http://s3.51cto.com/wyfs02/M00/43/6A/ Wkiom1parseqyc9aaads-9nho4m609.jpg "alt=" Wkiom1parseqyc9aaads-9nho4m609.jpg "/>

Complete Test

Source-Side Insert data

650) this.width=650; "title=" ogg34.jpg "src=" http://s3.51cto.com/wyfs02/M01/43/6A/ Wkiol1parnejb20taae1puy3buq902.jpg "alt=" Wkiol1parnejb20taae1puy3buq902.jpg "/>

View Target Side

650) this.width=650; "title=" ogg35.jpg "src=" http://s3.51cto.com/wyfs02/M02/43/6A/ Wkiol1parq7xjve-aafmyq2snj0661.jpg "alt=" Wkiol1parq7xjve-aafmyq2snj0661.jpg "/>

This article is from the "Fly Hung 膤" blog, please be sure to keep this source http://jxzhfei.blog.51cto.com/1382161/1533434