Sunday, June 12, 2016

Obey Files GoldenGate 11g/12c

Alot of people are getting confused on obey files 
obey files are used to run frequently used commands used in goldengate :) 

you can store and create obey files  in goldengate dirprm directory

steps to implement or use obey files 

1) create extract.prm, pump.prm and replicat.prm files required in  "/goldengate_home/dirprm/" directory 

2) create test1.oby files to add extract, pump and replicat in goldengate command utility "ggsci"

example of obey file

cat test1.oby
start mgr 
add extract ext_fst, tranlog begin now
add exttrail /local_trail/aa, extract ext_fst
start extract ext_fst
add extract pxt_fst, exttrailsource /local_trail/aa,  begin now
add rmttrail /remote_trail/aa, extract pxt_fst, megabytes 500
start pxt_fst

Will run obey files using goldengate command line utility 
ggsci> obey test1.oby

--Nikhil Tatineni--

Knowledge on GoldenGate#

Goldengate replicat waiting for commithttp://www.oracleinmemory.com/2015/11/goldengate-replicat-waiting-for-commit.htmlOGG:Replicat with Handlecollisionshttp://www.oracleinmemory.com/2015/11/oggreplicat-with-handlecollisions.htmlSPLITING OracleGoldenGate REPLICAThttp://www.oracleinmemory.com/2015/02/hey-guys-welcome-back.htmlGoldengate Replicat is running very slowhttp://www.oracleinmemory.com/2015/10/replicat-is-running-very-slow.htmlGoldengate Replicat's blocking itselfhttp://www.oracleinmemory.com/2015/10/replicats-blocking-itself.htmlOracle GoldenGate: SKIP LONG RUNNING TRANSACTIONShttp://www.oracleinmemory.com/2015/03/ogg-skip-long-running-transactions.htmlWhat is lag in OGG ?http://www.oracleinmemory.com/2015/10/what-is-lag-in-ogg.htmlGoldenGate Extract : Bounded Recoveryhttp://www.oracleinmemory.com/2015/10/extract-bounded-recovery.htmlGoldengate Extract is not moving?http://www.oracleinmemory.com/2015/02/extract-is-not-moving.htmlERROR OGG-00446  Missing filename opening checkpoint filehttp://www.oracleinmemory.com/2015/08/error-ogg-00446.htmlERROR  OGG-00665  OCI Error calling OCITransRollback (stathttp://www.oracleinmemory.com/2015/08/error-ogg-00665.htmlERROR  OGG-01028 Incompatible record : Bad record on trailhttp://www.oracleinmemory.com/2015/11/error-ogg-01028-incompatible-record-bad.htmlERROR OGG-00446: error 13 (Permission denied) http://www.oracleinmemory.com/2015/02/error-ogg-00446.htmlERROR OGG-01028 Formatting error on: tablehttp://www.oracleinmemory.com/2015/02/error-ogg-01028.htmlERROR OGG-01232 Receive TCP params error: TCP/IP error 73 http://www.oracleinmemory.com/2015/02/error-ogg-01232_1.htmlERROR 0GG-01031 There is a problem in network communication, a remote file problemhttp://www.oracleinmemory.com/2015/01/error-0gg-01031.htmlERROR OGG-00870  Database error 942 (ORA-00942: table or view does not exist SQL select..http://www.oracleinmemory.com/2016/03/goldengate-error-ogg-00870.htmlERROR OGG-00446 Unable to lockfile http://www.oracleinmemory.com/2016/03/error-ogg-00446-unable-to-lock-file.htmlERROR OGG-10144 (ecbn.prm) line 6: Parameter [ASMPASSWORD] is not valid for this configuration.http://www.oracleinmemory.com/2016/03/goldengate-error-ogg-10144.htmlERROR OGG-06220 Classic Extract does not support multitenant container http://www.oracleinmemory.com/2016/03/goldengate-error-ogg-06220.htmlERROR OGG-01224 Address already in use.http://www.oracleinmemory.com/2016/03/goldengate-error-ogg-01224.htmlERROR OGG-01668 problem at line 103.  Bad column definition: PREV_VDSL_UP_RATEhttp://www.oracleinmemory.com/2016/03/oracle-goldengate-error-ogg-01668.htmlERROR OGG-00665 OCI Error describe for query (status = 4031-ORA-04031 http://www.oracleinmemory.com/2016/03/goldengate-error-ogg-00665.htmlERROR OGG-00730 No minimum supplemental logging is enabled http://www.oracleinmemory.com/2016/03/error-ogg-00730-no-minimum-supplemental.htmlERROR OGG-01755 Cannot register or unregister EXTRACT http://www.oracleinmemory.com/2016/04/error-ogg-01755-cannot-register-or.html

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...