Follow the instructions in this section to prepare the host for Oracle GoldenGate.
Configure the storage for Oracle GoldenGate.
On Cluster 1:
psomal # clrs create -t SUNW.HAStoragePlus -p zpools=/gg2 gg-hsp-rs psoma1 # clrs enable gg-hsp-rs
On Cluster 2:
vzsoma1a # clrs create -t SUNW.HAStoragePlus -p zpools=/gg2 gg-hsp-rs vzsoma1a # clrs enable gg-hsp-rs
Add the users.
root@psoma1:~# useradd -u 2000 -g dba -m -s /usr/bin/bash -d /export/home/gg gg root@psoma2:~# useradd -u 2000 -g dba -m -s /usr/bin/bash -d /export/home/gg gg root@vzsoma1a:~# useradd -u 2000 -g dba -m -s /usr/bin/bash -d /export/home/gg gg root@vzsoma1a:~# useradd -u 2000 -g dba -m -s /usr/bin/bash -d /export/home/gg gg
Add the LD_LIBRARY_PATH to the environment of gg on all nodes.
In this example, the /gg1 or the /gg2 entry is the only LD_LIBRARY_PATH entry in the .profile file.
On psoma1 and psoma2:
LD_LIBRARY_PATH=/gg2 export LD_LIBRARY_PATH
On vzsoma1a and vzsoma2a:
LD_LIBRARY_PATH=/gg1 export LD_LIBRARY_PATH
Set the permissions on the shared file system.
On Cluster 1:
root@psoma1:~# chown -R gg:dba/gg2
On Cluster 2:
root@vzsoma1a:~# chown -R gg:dba/gg1
Install the Oracle GoldenGate software.
As user gg, untar the Oracle GoldenGate binaries in /gg1 on vzsoma1a and /gg2 on psoma1, assuming these are the nodes which own the shared storage.
gg@psoma1:/gg2$ tar xvf /temp/ggs_Solaris_sparc_MySQL_64bit.tar gg@vzsoma1a:/gg1$ tar xvf /temp/ggs_Solaris_sparc_MySQL_64bit.tar
Configure the Oracle GoldenGate instances.
As user gg perform the following tasks:
Create the Oracle GoldenGate instance subdirectories.
gg@vzsoma1a:/gg1$ ./ggsci GGSCI(vzsoma1a) 1> create subdirs gg@psoma1:/gg2$ ./ggsci GGSCI(psoma1) 1> create subdirs
Configure the manager on Cluster 1.
GGSCI(psoma1) 3> edit params mgr PORT 7809 DYNAMICPORTLIST 7810-7820 AUTORESTART ER *, RETRIES 4, WAITMINUTES 4 STARTUPVALIDATIONDELAY 5 PURGEOLDEXTRACTS /gg2/dirdat/mm*, USECHECKPOINTS, MINKEEPHOURS 2 GGSCI (psoma1) 3>
Configure the manager on Cluster 2.
GGSCI(vzsoma1a) 3> edit params mgr PORT 7909 DYNAMICPORTLIST 7910-7920 AUTORESTART ER *, RETRIES 4, WAITMINUTES 4 STARTUPVALIDATIONDELAY 5 PURGEOLDEXTRACTS /gg1/dirdat/mm*, USECHECKPOINTS, MINKEEPHOURS 2 GGSCI(vzsoma1a) 3>
Configure the extract on Cluster 1.
GGSCI(psoma1) 9> edit param mysqlext EXTRACT mysqlext DBOptions Host soma-3 SourceDB golden UserID gg Password gg TranLogOptions AltLogDest /mys2/data/logs/bin-log.index DISCARDFILE /gg2/mysqlext.dsc, PURGE RMTHOST soma-1, MGRPORT 7909 RMTTRAIL /gg1/dirdat/XX TABLE golden.*;
Add the extract on Cluster 1.
GGSCI(psoma1) > Add Extract MySQLEXT TranLog Begin now
Add the remote trail on Cluster 1.
GGSCI(psoma1) >Add RmtTrail /gg1/dirdat/XX extract MySQLEXT
Configure the replicat on Cluster 2.
GGSCI(vzsoma1a) 11> edit param mysqlrep REPLICAT mysqlrep DBOptions Host soma-1 TargetDB golden USERID gg PASSWORD gg DISCARDFILE /gg1/mysqlrep.dsc, PURGE REPERROR DEFAULT, ABEND AssumeTargetDefsMap golden.*, Target golden.*;
Add the replicat on Cluster 2.
GGSCI(vzsoma1a) 11> Add Replicat MySQLREP \ exttrail /gg1/dirdat/XX nodbcheckpoint
Define the Ipv6 policy on both the clusters.
GGSCI(psoma1) >edit params ./GLOBALS USEIPV6 GGSCI(vzsoma1a) >edit params ./GLOBALS USEIPV6
Start the manager on both the clusters.
GGSCI(psoma1) > start mgr GGSCI (vzsoma1a) >start mgr
Start the extract and replicat processes on both the clusters.
GGSCI(psoma1) > start er * GGSCI(vzsoma1a) > start er *
Check if all the processes are running on both the clusters.
GGSCI(psoma1) > info all GGSCI(vzsoma1a) > info all
Stop the extract and replicat processes on both the clusters
GGSCI(psoma1) > stop er * GGSCI(vzsoma1a) > stop er *
Stop the manager process on both the clusters.
GGSCI(psoma1) > stop mgr ! GGSCI(psoma1) > exit GGSCI(vzsoma1a) > stop mgr ! GGSCI(vzsoma1a) > exit
Kill the server process on the cluster with replicats configured.
vzsoma1a # pkill -f server
Create the Oracle GoldenGate resources.
psoma1 # clrt register ORCL.GoldenGate psoma1 # clrs create -d -g db1-rg \ -t GoldenGate \ -p user=gg \ -p Basepath=/gg2 \ -p port=7809 \ -p parameter_file=/gg2/dirprm/mgr.prm \ -p database_resource=mys-rs \ -p resource_dependencies=mys-rs,soma-3 \ -p resource_dependencies_offline_restart=gg-hsp-rs \ gg2-rs psoma1 # clrs enable gg2-rs vzsoma1a # clrt register ORCL.GoldenGate vzsoma1a # clrs create -d -g db2-rg \ -t GoldenGate \ -p user=gg \ -p Basepath=/gg1 \ -p port=7909 \ -p parameter_file=/gg1/dirprm/mgr.prm \ -p database_resource=mys-rs \ -p resource_dependencies=mys-rs,soma-1 \ -p resource_dependencies_offline_restart=gg-hsp-rs \ gg1-rs vzsoma1a # clrs enable gg1-rs