Sunday, June 12, 2016

Convert Classic Replicat to Integrated Replicat GoldenGate



scenario # converting goldengate classic replicat into integrated replicat 

step1: dblogin into the database using ggsuser and password 
step2: Stop classic replicat
step3: alter the replicat to integrated mode
step4: start replicat 

prechecks # 
before make sure new following parameter is enabled on oracle database 
enable_goldengate_replication=true  

step1 # 
ggsci> dblogin userid ggsuser password oracle 
Step2 # 
ggsci> stop replicat rep_int
Step3 #
ggsci> alter replicat rep_int, Integrated 
Step4 # 
ggsci> start replicat rep_int 


--Nikhil Tatineni--
--12c Integrated Replicat -- 

Querys to monitor RAC

following few  Query's will help to find out culprits-  Query to check long running transaction from last 8 hours  Col Sid Fo...