- Installing Oracle GoldenGate
- Installing Oracle Database Client
- Configuring Oracle GoldenGate
- Preparing the Data Replication
- AMI Image
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>
./runInstaller -silent -responseFile <response_file>
- GoldenGate for 11g OUI response file: ggora11.rsp
- GoldenGate for 12c OUI response file: ggora12.rsp
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.
Answer: No, you need only need the "Administrator" Oracle Database Client?
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.
export LD_LIBRARY_PATH=<oracle_db_12_client_directory>
$ ./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).
$ 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.
Answer: This is because you need to set up the ORACLE_HOME environment variable to point to Oracle GoldenGate installation home.
- Oracle GoldenGate 12.2 for Oracle 11g
- Oracle GoldenGate 12.2 for Oracle 12c
- Oracle Database Client 11g
- Oracle Database Client 12c
- Cheatsheet: how_to_create_gg_hub_on_ec2
- 12/9/2016: Added the clarification on Oracle Database Client for Oracle GoldenGate remote capture and delivery.