Oracle Golden Gate

                                        Migrating GG from Active Data Guard(standby) to Primary                                   1. GG set up in Primary DB – Ops.DBA team  [2-4 days needed for setup] a. New setup of GG – on Primary i. Unix team 1. Create user 2. Create Group 3. Folder Permissions 4. Setup of PowerBroker a. 2 teams need to be added : Ops.DBA, EIMSGG ii. Install GG software 1. No reboot required b. Confirm ports are opened from Primary DB to Exadata and Teradata i. Have scripts to run to check ii. EIMSGG to get confirmation ports are already open 1. If not, then need to submit port opening request [takes 1-2 weeks] c. WO raised to Ops.DBA for i. SW installation ii. Approvals required iii. Ops.DBA to raise SSH access Unix.  Then set up permissions for GG d. Verification by EIMSGG team [post software installation and necessary permission granted as above] 2. GG Replication for sample tables – EIMSGG team [1 day] a. EIMSGG t

                How to crosscheck the firewall port has opened from source to target We can check by telnet or curl command. Sometimes in some system telnet will not work,but we can check by curl command. Exadata Source:- Telnet is not working, but Curl is working .The firewall port 7839 is working in Exadata production  Curl command demonstration  ---------------------------- [oracle@ixyp04dbadm01 ~]$ telnet 192.168.10.80 7839  -bash: telnet: command not found  [oracle@ixyp04dbadm01 ~]$ curl -v telnet://192.168.10.80:7839  * About to connect() to 192.168.10.80 port 7839 (#0)  *   Trying 192.168.10.80... connected  * Connected to 192.168.10.80 (192.168.10.80) port 7839 (#0)  * Closing connection #0  [oracle@ixyp04dbadm01 ~]$ Telnet command demonstration ----------------------------- i47ulpora15:/apps/oracle> telnet 192.168.10.80 7839 Trying... i47ulpora15:/apps/oracle> curl -v telnet://192.168.10.80:7839 ksh: curl:  not found.  i47ulpora15:/apps/oracle&

                          syllabus for ogg 12c exam Exam Number: 1Z0-447 Oracle GoldenGate (OGG) Overview ? Describe OGG functional overview and common topologies ? Describe OGG Veridata and Management Pack functionality ? Describe the difference between real-time data integration replication and Data Manipulation Language (DML) replication Architecture Overview ? Describe OGG components ? Create the two types of Capture processes for Oracle database ? Create the three types of Replicat processes ? Explain the difference between an Extract and Pump, and local and remote trails ? Configure OGG's process recovery mechanism Install and Configure OGG ? Download and Install OGG, and differentiate between various installers (zip, OUI, tar) ? Synchronize source and target databases with the Initial Load ? Prepare database for OGG CDC and check databases with OGG schema check script ? Configure OGG Replication component parameter files ? Configure the OGG Command Interf

                    Log in Processes for golden gate having different database 1.Log in process in goldengate for Teradata ggsci>dblogin sourcedb td_uat, userid DBU_GGATE_MEMP, PASSWORD DBU_GGATE$FEB17 2.Log in process in goldengate for SQL Server Database ggsci>dblogin targetdb td_uat, userid DBU_GGATE_MEMP, PASSWORD DBU_GGATE$FEB17 3.Log in process in goldengate for Oracle ggsci>dblogin USERIDALIAS ogg_bmscrbu 4.Log in process in goldengate for Hadoop(Cloudera) (There is no db login for Hadoop as it has only hdfs file system rather than database)

          How to check or investigate certain process from a big file like ggserr.log file [oracle@ftdcslsinf623 11.1.1.0.27]$ awk '/STOPPED/ {print}' ggserr.log '|' awk '/ABENDED/ {print}' ggserr.log REPLICAT RARLI03T: STOPPED

        Shells Script to Monitor Golden Gate processes are stopped or abended #!/bin/ksh #---------------------------------------------------------------# # Script to check the Statistics in the Golden Gate             # #---------------------------------------------------------------# # Annadakant Mishra (qa853) # Feb  2018 set -x #---------------------------------------------------------------# # Function to check on Statistics on GG running                 # #---------------------------------------------------------------# HOST=`hostname` ORACLE_BASE=/u02/app/oracle; export ORACLE_BASE export GG_HOME=/u02/app/oracle/product/11.1.1.0.27 export ORACLE_LOG=/u02/app/oracle/local/logs PATH=$PATH:$HOME/bin:/bin:/usr/bin:/usr/local/bin:$GG_HOME; export PATH ACTIVE_GG_NODE=`hostname` #MAIL_ADDRESS= #MAIL_ADDRESS=qa853@gmail.com SCRIPT_BASE=/u02/app/oracle/local/scripts/ggMon LogFile=/u02/app/oracle/local/logs/GoldenGate_LagMon.log #Create check file CHKDT=`date &quo

                            Recover of Corrupted Definition File in Golden Gate In one of the golden gate setup ,we are not able to start the replicate in the target side. It was showing some error like below 2019-02-20 02:31:22   ERROR    OGG-00303   Problem at line 27.   Expecting file, table, or record definition. 2019-02-20 02:31:22   ERROR    OGG-01668   PROCESS ABENDING. Solution:- If the golden gate version is Version 11.1.1.0.27,then we will see this type of error in the report file while we want to start the replicate process. 1.Go to the source server and generate the new definition file by using ./defgen utility Gg_home$ ./defgen paramfile /oracle/app/oracle/product/oggnew/dirprm/prcc_defgen_teradata.prm 2. new definition file will be created in   the below location of source server $Gg_home/dirdef/prcc_defgen_teradata 3.transfer the prcc_defgen_teradata file to target by scp or open this text file by cat command ,copy to a notepad++ ,paste in th