Overview
You can install Oracle GoldenGate for Oracle RAC using:
You can install Oracle GoldenGate for Oracle RAC using:
- Shared Storage
- NFS, OCFS2, DBFS, OCFS
- Local file system
You can Install Oracle GoldenGate 12c in 2 ways:
In this article I will demonstrate how to Install Oracle GoldenGate 12c using GUI on a full Rack Exadata Database Machine using ACFS file system.
What is ACFS?
Automatic Storage Management Cluster File System (ACFS) was introduced in Oracle database 11gR2. ACFS is a general purpose single-node or cluster file system on top of ASM. ACFS can be accessed using industry-standard Network Attached Storage (NAS) file access protocols: Network File System (NFS) and Common Internet File System (CIFS)
Installing GoldenGate on ACFS
ACFS file systems are mounted on all nodes in a cluster. Oracle GoldenGate is supported in an Oracle ACFS environment. GoldenGate should be installed in the cluster to capture the data from the database.
How to configure ACFS?
Take a look at the below 2 articles on how to configure ACFS on Exadata Database Machine.
- Graphical User Interface (GUI)
- Using response file (Silent)
In this article I will demonstrate how to Install Oracle GoldenGate 12c using GUI on a full Rack Exadata Database Machine using ACFS file system.
What is ACFS?
Automatic Storage Management Cluster File System (ACFS) was introduced in Oracle database 11gR2. ACFS is a general purpose single-node or cluster file system on top of ASM. ACFS can be accessed using industry-standard Network Attached Storage (NAS) file access protocols: Network File System (NFS) and Common Internet File System (CIFS)
Installing GoldenGate on ACFS
ACFS file systems are mounted on all nodes in a cluster. Oracle GoldenGate is supported in an Oracle ACFS environment. GoldenGate should be installed in the cluster to capture the data from the database.
How to configure ACFS?
Take a look at the below 2 articles on how to configure ACFS on Exadata Database Machine.
Flex ASM: http://netsoftmate.blogspot.in/2017/03/configure-acfs-on-exadata-running.html
Standard ASM: http://netsoftmate.blogspot.in/2017/02/configure-acfs-on-exadata-database.html
Environment:
Standard ASM: http://netsoftmate.blogspot.in/2017/02/configure-acfs-on-exadata-database.html
Environment:
- Exadata Database Machine X5-2 Full Rack
- Oracle GoldenGate 12.2.0.1
- Oracle Database 12.2.0.1
- ASM Cluster File System (ACFS)
Verify ACFS is running and mounted
dm01db01-orcldb1 {/acfs_ogg/fbo_ggs_Linux_x64_shiphome/Disk1}: ./runInstaller
Specify the GoldenGate Software location. Here I am using /acfs_ogg (ACFS file system)
Specify the Database Home Location and Manager port (Default Manager port is 7809)
Click Next
Review the Installation Summary and click Install
Oracle GoldenGate Software Installation in progress
Installation completed. Click Close
dm01db01-+ASM1 {/home/oracle}:/u01/app/12.2.0.1/grid/bin/crsctl stat res ora.acfs_dg.acfsvol.acfs -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.acfs_dg.acfsvol.acfs
ONLINE ONLINE dm01db01 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db02 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db03 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db04 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db05 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db06 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db07 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db08 mounted on /acfs_ogg
,STABLE
--------------------------------------------------------------------------------
dm01db01-+ASM1 {/home/oracle}:dcli -g ~/dbs_group -l oracle 'df -h /acfs_ogg'
dm01db01: Filesystem Size Used Avail Use% Mounted on
dm01db01: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db02: Filesystem Size Used Avail Use% Mounted on
dm01db02: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db03: Filesystem Size Used Avail Use% Mounted on
dm01db03: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db04: Filesystem Size Used Avail Use% Mounted on
dm01db04: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db05: Filesystem Size Used Avail Use% Mounted on
dm01db05: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db06: Filesystem Size Used Avail Use% Mounted on
dm01db06: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db07: Filesystem Size Used Avail Use% Mounted on
dm01db07: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db08: Filesystem Size Used Avail Use% Mounted on
dm01db08: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
Steps to Download Oracle GoldenGate 12c Software
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.acfs_dg.acfsvol.acfs
ONLINE ONLINE dm01db01 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db02 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db03 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db04 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db05 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db06 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db07 mounted on /acfs_ogg
,STABLE
ONLINE ONLINE dm01db08 mounted on /acfs_ogg
,STABLE
--------------------------------------------------------------------------------
dm01db01-+ASM1 {/home/oracle}:dcli -g ~/dbs_group -l oracle 'df -h /acfs_ogg'
dm01db01: Filesystem Size Used Avail Use% Mounted on
dm01db01: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db02: Filesystem Size Used Avail Use% Mounted on
dm01db02: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db03: Filesystem Size Used Avail Use% Mounted on
dm01db03: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db04: Filesystem Size Used Avail Use% Mounted on
dm01db04: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db05: Filesystem Size Used Avail Use% Mounted on
dm01db05: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db06: Filesystem Size Used Avail Use% Mounted on
dm01db06: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db07: Filesystem Size Used Avail Use% Mounted on
dm01db07: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
dm01db08: Filesystem Size Used Avail Use% Mounted on
dm01db08: /dev/asm/acfsvol-223 4.9T 12G 4.9T 1% /acfs_ogg
Steps to Download Oracle GoldenGate 12c Software
- Open a web browser and enter www.oracle.com in the address bar
- This will bring you to the Oracle website home page
- On this page hover on the download tab and click on "middleware"
- Click GoldenGate
- Accept the agreement and select the desired Oracle GoldenGate version for your platform.
- Here I am downloading "Oracle GoldenGate 12.2.0.1.1 for Oracle on Linux x86-64"
- Copy the zip file from your desktop to Exadata Compute node 1 using WinScp
- Drag and Drop the file from left to right in to a directory
- Here I am copying the file to /u01/app/oracle/software location
- File copy is in progress
Steps to Install Oracle GoldenGate 12c software using OUI (Graphical Interface)
- Login to Exadata Compute node 1 as Oracle software owner and navigate to the Oracle GoldenGate staging location
dm01db01-orcldb1 {/home/oracle}:cd /u01/app/oracle/software
dm01db01-orcldb1 {/u01/app/oracle/software}:ls -ltr
total 464928
-rw-r--r-- 1 oracle oinstall 475611228 Jan 2 04:51 fbo_ggs_Linux_x64_shiphome.zip
dm01db01-orcldb1 {/u01/app/oracle/software}:ls -ltr
total 464928
-rw-r--r-- 1 oracle oinstall 475611228 Jan 2 04:51 fbo_ggs_Linux_x64_shiphome.zip
- Copy software zip file to ACFS location /acfs_ogg
dm01db01-orcl1 {/u01/app/oracle/software}: cp fbo_ggs_Linux_x64_shiphome.zip /acfs_ogg/
- Unzip the Oracle GoldenGate 12c software
dm01db01-orcldb1 {/u01/app/oracle/software}: cd /acfs_ogg
dm01db01-orcldb1 {/acfs_ogg}:ls -l
total 467040
-rw-r--r-- 1 oracle oinstall 475611228 Mar 25 01:51 fbo_ggs_Linux_x64_shiphome.zip
dm01db01-orcldb1 {/acfs_ogg}:unzip fbo_ggs_Linux_x64_shiphome.zip
Archive: fbo_ggs_Linux_x64_shiphome.zip
creating: fbo_ggs_Linux_x64_shiphome/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/OuiConfigVariables.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/productlanguages.properties
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/setperms1.sh
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_filemap.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_dirs.lst
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/racfiles.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_dirs.lst
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_filemap.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_exp_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_exp_1.xml
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/globalvariables/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/Dialogs/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/Dialogs/standardDialogs/
......
creating: fbo_ggs_Linux_x64_shiphome/Disk1/response/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
inflating: OGG-12.2.0.1-README.txt
inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf
dm01db01-orcldb1 {/acfs_ogg}:ls -ltr
total 467412
drwxr-xr-x 3 oracle oinstall 20480 Dec 12 2015 fbo_ggs_Linux_x64_shiphome
-rw-r--r-- 1 oracle oinstall 1559 Jan 18 2016 OGG-12.2.0.1-README.txt
-rw-r--r-- 1 oracle oinstall 282294 Jan 18 2016 OGG-12.2.0.1.1-ReleaseNotes.pdf
drwx------ 2 root root 65536 Mar 23 08:53 lost+found
-rw-r--r-- 1 oracle oinstall 475611228 Mar 25 01:51 fbo_ggs_Linux_x64_shiphome.zip
dm01db01-orcldb1 {/acfs_ogg}:ls -l
total 467040
-rw-r--r-- 1 oracle oinstall 475611228 Mar 25 01:51 fbo_ggs_Linux_x64_shiphome.zip
dm01db01-orcldb1 {/acfs_ogg}:unzip fbo_ggs_Linux_x64_shiphome.zip
Archive: fbo_ggs_Linux_x64_shiphome.zip
creating: fbo_ggs_Linux_x64_shiphome/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/runInstaller
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/OuiConfigVariables.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/productlanguages.properties
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/setperms1.sh
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_filemap.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_dirs.lst
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/racfiles.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_dirs.lst
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_filemap.jar
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora11g_exp_1.xml
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/fastcopy/oracle.oggcore.top_ora12c_exp_1.xml
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/globalvariables/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/Dialogs/
creating: fbo_ggs_Linux_x64_shiphome/Disk1/stage/Dialogs/standardDialogs/
......
creating: fbo_ggs_Linux_x64_shiphome/Disk1/response/
inflating: fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp
inflating: OGG-12.2.0.1-README.txt
inflating: OGG-12.2.0.1.1-ReleaseNotes.pdf
dm01db01-orcldb1 {/acfs_ogg}:ls -ltr
total 467412
drwxr-xr-x 3 oracle oinstall 20480 Dec 12 2015 fbo_ggs_Linux_x64_shiphome
-rw-r--r-- 1 oracle oinstall 1559 Jan 18 2016 OGG-12.2.0.1-README.txt
-rw-r--r-- 1 oracle oinstall 282294 Jan 18 2016 OGG-12.2.0.1.1-ReleaseNotes.pdf
drwx------ 2 root root 65536 Mar 23 08:53 lost+found
-rw-r--r-- 1 oracle oinstall 475611228 Mar 25 01:51 fbo_ggs_Linux_x64_shiphome.zip
- Change directory to Disk1 and run the Installer
dm01db01-orcldb1 {/acfs_ogg}:cd fbo_ggs_Linux_x64_shiphome
dm01db01-orcldb1 {/acfs_ogg/fbo_ggs_Linux_x64_shiphome}:cd Disk1/
dm01db01-orcldb1 {/acfs_ogg/fbo_ggs_Linux_x64_shiphome/Disk1}:ls -ltr
total 160
drwxr-xr-x 4 oracle oinstall 20480 Dec 12 2015 install
drwxr-xr-x 11 oracle oinstall 20480 Dec 12 2015 stage
-rwxr-xr-x 1 oracle oinstall 918 Dec 12 2015 runInstaller
drwxrwxr-x 2 oracle oinstall 20480 Dec 12 2015 response
dm01db01-orcldb1 {/acfs_ogg/fbo_ggs_Linux_x64_shiphome}:cd Disk1/
dm01db01-orcldb1 {/acfs_ogg/fbo_ggs_Linux_x64_shiphome/Disk1}:ls -ltr
total 160
drwxr-xr-x 4 oracle oinstall 20480 Dec 12 2015 install
drwxr-xr-x 11 oracle oinstall 20480 Dec 12 2015 stage
-rwxr-xr-x 1 oracle oinstall 918 Dec 12 2015 runInstaller
drwxrwxr-x 2 oracle oinstall 20480 Dec 12 2015 response
dm01db01-orcldb1 {/acfs_ogg/fbo_ggs_Linux_x64_shiphome/Disk1}: ./runInstaller
Select the Database version for which you are installing Oracle GoldenGate Software.
Here I am Installing Oracle GoldenGate for Oracle Database 12c
Click Next
Specify the GoldenGate Software location. Here I am using /acfs_ogg (ACFS file system)
Specify the Database Home Location and Manager port (Default Manager port is 7809)
Click Next
Review the Installation Summary and click Install
Oracle GoldenGate Software Installation in progress
Installation completed. Click Close
- Open the .bash_profile and add the following two variables
dm01db01-orcldb1 {/home/oracle}: vi .bash_profile
export GG_HOME=/acfs_ogg/app/oracle/product/12.2.0.1/gghome
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$GG_HOME
*** Repeat the above step on all the nodes to update the .bash_profile***
export GG_HOME=/acfs_ogg/app/oracle/product/12.2.0.1/gghome
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$GG_HOME
*** Repeat the above step on all the nodes to update the .bash_profile***
- Execute the .bash_profile and verify the variables.
dm01db01-orcldb1 {/home/oracle}: . .bash_profile
dm01db01-orcldb1 {/home/oracle}: echo $GG_HOME
/acfs_ogg/app/oracle/product/12.2.0.1/gghome
dm01db01-orcldb1 {/home/oracle}: echo $LD_LIBRARY_PATH
/u01/app/oracle/product/12.2.0.1/dbhome/lib:/u01/app/oracle/product/12.2.0.1/dbhome/lib32:/acfs_ogg/app/oracle/product/12.2.0.1/gghome
dm01db01-orcldb1 {/home/oracle}: echo $GG_HOME
/acfs_ogg/app/oracle/product/12.2.0.1/gghome
dm01db01-orcldb1 {/home/oracle}: echo $LD_LIBRARY_PATH
/u01/app/oracle/product/12.2.0.1/dbhome/lib:/u01/app/oracle/product/12.2.0.1/dbhome/lib32:/acfs_ogg/app/oracle/product/12.2.0.1/gghome
- Let's connect to ggsci prompt and verify the manager process
dm01db01-orcldb1 {/home/oracle}:cd $GG_HOME
dm01db01-orcldb1 {/acfs_ogg/app/oracle/product/12.2.0.1/gghome}:./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 (dm01db01.netsoftmate.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dm01db01.netsoftmate.com) 2> info mgr
Manager is running (IP port dm01db01.netsoftmate.com.15000, Process ID 10249).
dm01db01-orcldb1 {/acfs_ogg/app/oracle/product/12.2.0.1/gghome}:./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 (dm01db01.netsoftmate.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dm01db01.netsoftmate.com) 2> info mgr
Manager is running (IP port dm01db01.netsoftmate.com.15000, Process ID 10249).
- Let's verify it from node 2 this time. See the "info mgr" output. It clearly says that the mgr is up on node 1 that is dm01db01 using process ID 10249.
dm01db02-orcldb2 {/home/oracle}:cd $GG_HOME
dm01db02-orcldb2 {/acfs_ogg/app/oracle/product/12.2.0.1/gghome}:./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 (dm01db02.netsoftmate.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dm01db02.netsoftmate.com) 3> info mgr
Manager is running (IP port dm01db01.netsoftmate.com.15000, Process ID 10249).
dm01db02-orcldb2 {/acfs_ogg/app/oracle/product/12.2.0.1/gghome}:ps -ef|grep mgr
oracle 19219 823 0 04:06 pts/0 00:00:00 grep mgr
dm01db01-orcldb1 {/home/oracle}:dcli -g dbs_group -l oracle 'ls -l /acfs_ogg/app/oracle/product/12.2.0.1/'
dm01db01: total 52
dm01db01: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db02: total 52
dm01db02: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db03: total 52
dm01db03: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db04: total 52
dm01db04: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db05: total 52
dm01db05: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db06: total 52
dm01db06: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db07: total 52
dm01db07: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db08: total 52
dm01db08: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
Conclusion
This completes our Oracle GoldenGate 12c installation on Exadata database machine using ACFS. We have seen how much easy it is to install Oracle GoldenGate software using GUI interface. The key for installing Oracle GoldenGate on 12c a RAC environment is to choose a shared location for software. You can also choose to install Oracle GoldenGate on local file system if you don't have a shared location.
dm01db02-orcldb2 {/acfs_ogg/app/oracle/product/12.2.0.1/gghome}:./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 (dm01db02.netsoftmate.com) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
GGSCI (dm01db02.netsoftmate.com) 3> info mgr
Manager is running (IP port dm01db01.netsoftmate.com.15000, Process ID 10249).
dm01db02-orcldb2 {/acfs_ogg/app/oracle/product/12.2.0.1/gghome}:ps -ef|grep mgr
oracle 19219 823 0 04:06 pts/0 00:00:00 grep mgr
dm01db01-orcldb1 {/home/oracle}:dcli -g dbs_group -l oracle 'ls -l /acfs_ogg/app/oracle/product/12.2.0.1/'
dm01db01: total 52
dm01db01: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db02: total 52
dm01db02: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db03: total 52
dm01db03: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db04: total 52
dm01db04: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db05: total 52
dm01db05: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db06: total 52
dm01db06: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db07: total 52
dm01db07: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
dm01db08: total 52
dm01db08: drwxr-xr-x 26 oracle oinstall 20480 Mar 25 03:57 gghome
Conclusion
This completes our Oracle GoldenGate 12c installation on Exadata database machine using ACFS. We have seen how much easy it is to install Oracle GoldenGate software using GUI interface. The key for installing Oracle GoldenGate on 12c a RAC environment is to choose a shared location for software. You can also choose to install Oracle GoldenGate on local file system if you don't have a shared location.
No comments:
Post a Comment