Free Video Tutorial On Installation Of Oracle Golden Gate Bridge

Oracle Goldengate Tutorials for Beginners. March 10, 2020 at 11:35 am. I have 5 yrs exp as an Oracle DBA. Ghulam Mohyuddin Zafar. March 10, 2020 at 12:04 pm. ORACLE DEVELOPER. Majid Ali Mohammed. June 7, 2020 at 6:07 am. I want to learn golden gate.i hav 10yrs oracle DBA experience.

Gavin, appreciate your inputs and efforts on the Golden Gate tutorial. I just wanted to pass on some info on one of the most common errors with Golden Gate as posted earlier. On Oracle 10g (10.2.0.4) and Golden Gate Version 11.1.1.1 on Linux GGSCI (OracleVM2) 1 dblogin userid ggate password ggate Successfully logged into database. This tutorial shows you how to deploy data replication using Oracle GoldenGate Studio 12.2.1. Oracle GoldenGate Studio displays its main page, you can now star creating projects and solutions. Feel free to create more activity on the database and monitor the statistics accumulated by OGG Studio in the 'Monitoring' page. You have several. 3 Installing the Oracle GoldenGate Microservices Architecture 3.1 Performing an Interactive Installation with OUI 3-1 3.2 Performing a Silent Installation with OUI 3-2 Part III Installing the Oracle GoldenGate Classic Architecture 4 Installing Classic Oracle GoldenGate for Oracle Database 4.1 Setting ORACLEHOME and ORACLESID 4-1.

1- Download the GG software from the following location
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html
I used the following for my platform (Windows 2003 Server)
Oracle GoldenGate v11.1.1.0.0 for Oracle 11g 64 bit on Windows XP, 2003, 2008(13 MB)
2- Download Oracle Client ( if you don't have already installed), test your client with some existing Oracle database. You don't need to install the client if you are using the same machine for Oracle Golden Gate where Oracle database is running in my case, my Oracle Databases 10g (source + target) were running on Windows 32bit and I had to install the OGG on Windows 64bit so I installed the Oracle Client on that machine with necessary modification in tnsnames.ora for Source and Target databases.
3- As OGG must be running on source and target do the following to get it installed on both systems.
i) Extract the Oracle GoldenGate zip file by winzip to a drive eg; E:
ii) Run the command shell and change directories to the new Oracle GoldenGate directory.
C:Documents and Settingsinam>e:
iii) From the Oracle GoldenGate directory, run the GGSCI program.
D:TempGGGG_SOURCE_HOMEDEV_ONSRV1
Oracle GoldenGate Command Interpreter for Oracle
Version 11.1.1.0.0 Build 078
Windows x64 (optimized), Oracle 10 on Jul 28 2010 14:52:12
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
GGSCI (DB2) 1>
iv) In GGSCI, issue the following command to create the Oracle GoldenGate working directories.
GGSCI (DB2) 1> create subdirs
Creating subdirectories under current directory E:OGGGoldenGate
Parameter files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirprm: created
Report files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirrpt: created
Checkpoint files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirchk: created
Process status files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirpcs: created
SQL script files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirsql: created
Database definitions files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirdef: created
Extract data files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirdat: created
Temporary files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirtmp: created
Veridata files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirver: created
Veridata Lock files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirverlock: created
Veridata Out-Of-Sync files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirveroos: created
Veridata Out-Of-Sync XML files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirveroosxml: created
Veridata Parameter files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirverparams: created
Veridata Report files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirverreport: created
Veridata Status files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirverstatus: created
Veridata Trace files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirvertrace: created
Stdout files D:TempGGGG_SOURCE_HOMEDEV_ONSRV1dirout: created
v) Issue the following command to exit GGSCI.
GGSCI (DB2) 2> Exit
Preparing Database for Golden Gate
We then need to create a database user which will be used by the GoldenGate Manager, Extract and Replicat processes. We create the user GGS_OWNER and grant it the required privileges.
SQL> create tablespace ggs_data
2 datafile ‘D:oracleproduct10.2.0oradataHOMEDEVHOMEDEVGGS_DATA.DBF’ size 200m;
SQL> create user ggs_owner identified by ggs_owner
2 default tablespace ggs_data
3 temporary tablespace temp;
User created.
SQL> grant connect,resource to ggs_owner;
Grant succeeded.
SQL> grant select any dictionary, select any table to ggs_owner;
Grant succeeded.
SQL> grant create table to ggs_owner;
Grant succeeded.
SQL> grant flashback any table to ggs_owner;
Grant succeeded. Free video tutorial on installation of oracle golden gate center

Free video tutorial on installation of oracle golden gate center

SQL> grant execute on dbms_flashback to ggs_owner;
Grant succeeded.
SQL> grant execute on utl_file to ggs_owner;
Grant succeeded.
We can then confirm that the GoldenGate user we have just created is able to connect to the Oracle database
GGSCI (DB2) 4> DBLOGIN USERID ggs_owner@homedev, PASSWORD ggs_owner
Successfully logged into database.
Enable Supplemental Logging
We need to enable supplemental logging at the database level otherwise we will get this error when we try to start the Extract process -
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
SELECT SUPPLEMENTAL_LOG_DATA_MIN,supplemental_log_data_pk, supplemental_log_data_ui FROM V$DATABASE;
Related Posts:

Free Video Tutorial On Installation Of Oracle Golden Gate Bridge

Oracle GoldenGate Tutorial Part 1 - Concepts and Architecture

Oracle GoldenGate Tutorial Part 3 - Manager process

Oracle GoldenGate Tutorial Part 4 - Working with OGG

Live Reporting with OGG

Live Reporting with Data Pump -GG

OGG Reference - Commands and Options

SQL Server to SQL Server Replication using GG

Free Video Tutorial On Installation Of Oracle Goldengate