GoldenGate Replication in Oracle Implementation

Hey there! Here's a snapshot of the setup you've got going on:

- Oracle Database: Version 12.1
- Oracle GoldenGate: Version 12c
- Operating System: Linux 6.5
- Oracle VM: You're using 2 virtual machines, one as the source and the other as the target.

If you're looking to download Oracle GoldenGate for Oracle on Linux x86-64 (a 530 MB download), you can grab it from this link: During the installation process, you'll need to specify the GoldenGate version.

To set up some environment variables, you can use these commands:
export ORACLE_HOME=/ora/oracle/app/oracle/product/12.1.0/dbhome_1
export ORACLE_SID=orasap
export PATH=/ora/oracle/ggs12:$PATH
export LD_LIBRARY_PATH=/ora/oracle/ggs12:$ORACLE_HOME/lib
You're currently located in the `/ora/oracle/ggs12` directory. To interact with the Oracle Database, you can use SQL*Plus like this:
sqlplus / as sysdba
You're connected to an Oracle Database 12c Enterprise Edition Release Cool features like Partitioning, OLAP, Advanced Analytics, and Real Application Testing are at your disposal.

You've got a script called `marker_setup.sql` which is used to set up markers for Oracle GoldenGate. It prompts you for the name of a schema (gguser in this case) where the GoldenGate database objects will reside. There's a similar script `ddl_setup.sql` for Oracle GoldenGate DDL Replication setup. Make sure to have the schema ready before running these scripts and stop any DDL replication.

After you've executed those scripts, some verification steps are carried out to ensure everything's running smoothly.

Also, there's a role setup script `role_setup.sql` that creates the role `GGS_GGSUSER_ROLE`. This role should be granted to users assigned to Extract, GGSCI, and Manager processes. You can do this with a SQL command like:
For instance, if your user is `gguser`, you'd execute:
Finally, there's a script `ddl_enable.sql` that alters a trigger.

That's a rundown of the steps and commands in your setup! If you have any questions or need further assistance, feel free to ask.
Next Post Previous Post
No Comment
Add Comment
comment url