Steps to install and setup Oracle GoldenGate 11g Release 1 (11.1.1)
Hello Guys,
Environment is as below:
Primary site (source): This is production DB and up and running.
RAC 2 nodes
Oracle RAC 11gr2
ASM
Enterprise Linux Server release 5.5 (Carthage)
target Site (destination): Software installed and instance has been created.
Standalone single server - Non RAC
Oracle 11gr2
ASM
Enterprise Linux Server release 5.5 (Carthage)
I am new to GG and I need to install and setup Oracle GoldenGate 11g Release 1 (11.1.1).
can anyone give me full steps from scratch ?
Confusions:
1.Do we need to install GG on all nodes?
2.db_name and instance name can be different on source and destination ?
3.Do we need to set any specific parameters in pfile/spfile for GG on source and destination?
4.any specific entries in listener.ora and tnsnames.ora for connectivity between source and destination?
5.Do we to configure anything on ASM for GG installation?
6.Do we need to create Standby DB first before GG installation?
responses will be highly appreciated.
Reagrds,
Edited by: LazyDBA11g on Apr 14, 2011 12:32 AM
Edited by: LazyDBA11g on Apr 14, 2011 12:40 AM
Edited by: LazyDBA11g on Apr 14, 2011 6:01 AM