- Oracle GoldenGate Enterprise Manager Plug-in (OEM Plug-in) is certified to monitor GGCS.
You can have integrated view to monitor GoldenGate and GGCS in Oracle Enterprise Manager supporting Hybrid Cloud Gateway Agent. - GGCS Trial is now available.
You can request 30 days trials to use GGCS in Oracle Public Cloud. - GGCS now supports delivery to Oracle Database 12.2 on Database Cloud Service.
Oracle GoldenGate Cloud Service (GGCS) 16.4.5 was released. In this version, GGCS includes the following new features and certifications:
0 Comments
Let's discuss how to create an Oracle GoldenGate Replication Hub on AWS EC2. The followings will be discussed:
1. Installing Oracle GoldenGate
After an E2 service is provisioned, you can use SFTP to send the Oracle GoldenGate software to the EC2 instance. > sftp -i < private_key> <ec2-user@ec2_ip_address>
Then, you need to use OUI to install Oracle GoldenGate for Oracle Database. If there is no GUI access, you can choose the silent install option shown as follows:
./runInstaller -silent -responseFile <response_file>
Note that Oracle GoldenGate for Oracle Database has two installation options: ORA12c and ORA11g. You need to tell OUI installer which option to choose in the response file. The followings are the example response files for Oracle GoldenGate Silent Installation. You can update the installation location etc. based on your environment.
2. Installing Oracle Database Client
You need to install Oracle Database Client to connect to a source or target database from Oracle GoldenGate. Based on which database the Oracle GoldenGate instance will be used to capture and deliver data, you install different version of the Oracle Database Client. In the example, I installed both Oracle Database Client for 11g and 12c so that the Oracle GoldenGate Replication Hub can work with both Oracle Database 11g and 12c in RDS.
Do I need to install full Oracle Database for Oracle GoldenGate remote capture and delivery?
Answer: No, you need only need the "Administrator" Oracle Database Client?
When installing the Oracle Database Client, please choose the Administrator option shown as follows:
Why do I get the "ggsci: error while loading shared libraries: libnnz12.so: cannot open shared object file: No such file or directory" error?
Answer: Please make sure you choosed the Administrator option when installing the Oracle Database Client. If you install with InstanceClient option, you could get this error.
3. Configuring Oracle GoldenGate
In the following example, we use the Oracle Database 12c client to work with Oracle Database 12c on RDS as the example. After softwares are installed, you then need to set up the LD_LIBRARY_PATH environment variable to run GGSCI, the command-line utility for Oracle GoldenGate:
export LD_LIBRARY_PATH=<oracle_db_12_client_directory>
As required by GoldenGate installation, you then need to create sub-directories, and start the GoldenGate manager:
$ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO Linux, x64, 64bit (optimized), Oracle 11g on Dec 12 2015 00:54:38 Operating system character set identified as UTF-8. Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved. GGSCI> create subdirs GGSCI > edit param mgr Port 7865 GGSCI> start mgr Manager started. GGSCI> info mgr Manager is running (IP port ip-172-30-3-169.ec2.internal.7865, Process ID 9108).
4. Preparing the Data Replication
With GoldenGate manager started, you can perform a simple database connection validate to prepare the replication. The following example checks an RDS database connection:
$ export ORACLE_HOME=<gg_install_home> $ ./ggsci Oracle GoldenGate Command Interpreter for Oracle Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48 Operating system character set identified as UTF-8. Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved. GGSCI> dblogin userid <rds_master_user_name>@<rds_endpoint>:<rds_sqlnet_port>/<rds_db_sid> password *** Successfully logged into database.
Why do I get the "OGG-02550 ORACLE_HOME is not set to Oracle software directory." error?
Answer: This is because you need to set up the ORACLE_HOME environment variable to point to Oracle GoldenGate installation home.
5. AMI Image
The result setup is created as an AMI image with the followings:
6. Resources
Editing Notes: Created: 6/17/2016 Last Updates: 12/9/2016
|
GoldenGate Cloud ServiceOracle GoldenGate Cloud Service (GGCS) is an extension of Oracle GoldenGate to provide rea-time replication in Cloud. Links
Buzzwords
Disruption Dynamic Mobile Real-Time Security Data-Driven Globalization High Performance Digitization Web Scale Last Updated
March 2018
Categories
All
|