Oracle GoldenGate Studio is a graphical interface management tool. This tool makes it easier to complete the Ogg replication design. Installing this tool requires Java 8 (1.8) JDK software, which can be downloaded from the official Oracle website.
1. Installation process
Run the following command as an Oracle User:
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euhc7xzj2maack2zsmed8701.png "width=" 580 "height=" 123 "/>
The first popup interface will require the inventory directory to be specified, and this directory Oracle user must have read and write permissions.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euhdcc-osgaaikbt6hmlu027.png "width=" 580 "height=" 381 "/>
Welcome screen, Next
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiol1euhdkgfg0naahnosyu3ri668.png "width=" 580 "height=" 474 "/>
This step selects Skip software updates, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/84/8e/wkiol1euhdxgtvgzaagxwyijuvo151.png "width=" 580 "height=" 472 "/>
Specify the installation directory, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiom1euhdrd43gdaag6m4twvb0042.png "width=" 580 "height=" 472 "/>
There is only one default full installation option, the next step.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euhd2zeuk3aage5-2pxuq006.png "width=" 580 "height=" 475 "/>
Installation summary information.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiol1euhecw31-6aaiyxbk6smg118.png "width=" 580 "height=" 470 "/>
installation process, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiom1euhekakohcaah2whrehj0920.png "width=" 580 "height=" 473 "/>
When the installation is complete, click Finish to exit.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/84/8e/wkiol1euhebyvphdaajr7uz7dou700.png "width=" 580 "height=" 472 "/>
2. Creating the Oracle GoldenGate Studio Repository Schema
[[Email protected] ~]$ CD $OGG _home/oracle_common/bin[[email protected] ~]$ export java_home=/usr/java/jdk1.8.0_73 [[ Email protected] bin]$/rcurcu Logfile:/tmp/rcu2016-07-12_14-42_647144778/logs/rcu.log
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euheir2ejxaafued6fzvm388.png "width=" 580 "height=" 451 "/>
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiol1euheqxtdejaagfrvqlais148.png "width=" 580 "height=" 457 "/>
Select System load and Product load, next.
650) this.width=650; "title=" image "style=" border-top:0px;border-right:0px;background-image:none;border-bottom:0 px;padding-top:0px;padding-left:0px;border-left:0px;padding-right:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiol1euhe3s8xwxaahhubbao2y625.png "height=" 458 "/>
Specify the database connection information, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euhfcyeieiaahduapeckc103.png "width=" 580 "height=" 453 "/>
Select Create new prefix, select Oracle GoldenGate in the Components box, others remain default, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/84/8e/wkiol1euhflwrkn0aagji4nbayi230.png "width=" 580 "height=" 453 "/>
Set the account password, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euhftdv_staaffalqwyh8656.png "width=" 580 "height=" 453 "/>
Set the supervisor password and choose the encryption method, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiom1euhfbabsdpaag8gclkjgi605.png "width=" 580 "height=" 454 "/>
Specify table space information, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m02/84/8e/wkiom1euhfnhclypaag_dbo_xqc806.png "width=" 580 "height=" 452 "/>
Summary information, next.
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m00/84/8e/wkiom1euhfyitmktaag8xbvejje280.png "width=" 580 "height=" 454 "/>
Summary information after installation is complete.
3. Visit Oracle GoldenGate Studio
[Email protected] ~]$ Cd/u01/app/oracle/middleware/oracle_home/oggstudio/bin[[email protected] bin]$./oggstudio Oracle GoldenGate Studio Copyright (c) 1997, Oracle and/or its affiliates. All rights reserved. Type the full pathname of a JDK installation (or ctrl-c to quit), the path would be stored in/home/oracle/.oggstudio/12.2. 1.1.0/product.conf/usr/java/jdk1.8.0_73
For initial access, you need to configure the relevant user information, and the user is created during the installation process, as shown in:
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;margin:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" Http://s3.51cto.com/wyfs02/M01/84/8E/wKioL1eUhF3xkxqFAACqVtwWGeU199.png "Width=" 520 "height=" 389 "/>
650) this.width=650; "title=" image "style=" border-right-width:0px;background-image:none;border-bottom-width:0px; padding-top:0px;padding-left:0px;padding-right:0px;border-top-width:0px; "border=" 0 "alt=" image "src=" http:// S3.51cto.com/wyfs02/m01/84/8e/wkiol1euhf6igka3aaevxdasnow086.png "width=" 580 "height=" 340 "/>
Reference documents:
1. Fusion Middleware installing Oracle GoldenGate Studio
This article from "candon123" blog, declined reprint!
Oracle Fusion Middleware 12c GoldenGate Studio installation