Oracle to Oracle Replication with Oracle Multitenant
When deploying a GoldenGate Hub configuration it is important to have the right skills. Just because the "Oracle" name is on the package does not make it necessarily a "DBA" tool. There are certain skills needed to successfully manage an environment such as this.
Linux skills - Linux / Unix skills are important for managing a GoldenGate environment, there are times that the GUI interfaces won't accommodate everything needed to be done from a process standpoint.
vi - vi is the standard for editing tools on linux/*nix environments, and for some folks this can be a challenging tool to master. Spending time here is well worth the time spent.
Explain scripting - Knowledge of a key scripting language is
GoldenGate common library
Oracle GoldenGate High Availability Jinyu's Blog
How to Add Swap Space for Oracle GoldenGate Replication
Oracle Grid Infrastructure Bundled Agents (XAG) are Oracle Grid Infrastructure (GI) components that provide the HA framework to application resources and resource types managed through the bundled agent management interface, AGCTL. This post will help to understand, implement the XAG agents to have local HA for Golden Gate.
To install, this zip file needs to be downloaded and expanded in a temporary directory.
Currently there is a function to do this, typically the directory to store the current version zipfile is /ora01/Oracle_SW/xagXX (where XX is the version of the XAG software you wish to install).
The $XAG_HOME and sub-directories must be owned by Oracle Grid Infrastructure install owner.
The setup script, xagsetup.sh, must be run as the Oracle Grid Infrastructure install owner.
The xagsetup.sh script offers the option to install local only (current node, which is the default) or to install on all nodes in the cluster or, a subset of nodes in the cluster where the application is targeted to run.
When deploying the bundled agents to multiple nodes in the cluster, the xagsetup.sh is executed on only one node of the cluster, and the xagsetup.sh script will attempt to create $XAG_HOME directory on all remote nodes. (the XAG standard home directory is /oracle/admin/xag_XX (where XX is the current version number)