Posts

ERROR   OGG-02022  Oracle GoldenGate Capture for Oracle, ext.prm:  Logmining server does not exist on this Oracle database.

Solution: set the correct DB environment and register OGG extract GGSCI (oracledev.domain.com) 4> info all Program     Status      Group       Lag at Chkpt  Time Since Chkpt MANAGER     RUNNING EXTRACT     STOPPED     EXT      00:00:00      00:33:03 EXTRACT     STOPPED     PUMP      00:00:00      00:56:48 GGSCI (oracledev.domain.com) 5>  register Extract EXT database 2017-02-28 16:32:46  ERROR   OGG-08216  ERROR: Cannot register or unregister EXTRACT EXT because no database login was provided. Use DBLOGIN to establish a connection. GGSCI (oracledev.domain.com) 6>  dblogin useridalias ggadmin Successfully logged into database. GGSCI (oracledev.domain.com as GGADMIN@demodb) 7>  register Extract EXT database 2017-02-28 16:37:40  INFO    OGG-02003  Extract EXT successfully registered with database at SCN 324129978306. GGSCI (oracledev.domain.com as GGADMIN@demodb) 16> start EXT Sending START request to MANAGER ... EXTRACT EXT starting GG
Post a Comment
Read more

Differences between Oracle DataGuard and GoldenGate

Golden Gate Data Guard High latency (latency is the duration of redo transfer) Low latency Uses TCP/IP to connect Uses Tnsnames to connect Doesn't have the fast-start failover utility Has the fast-start failover utility Little or no gaps Near zero downtime upgrade Live reporting Operational Business Intelligence (Data warehouse) Transactional Data integration Always have gap issues Down-time Can replicate Just a table Would always replicate the entire data Can be open read write   recovery mode (mount mode) Capable Query offloading
Post a Comment
Read more