*** Please move GGS_ADMIN to its own tablespace

I’d been working on a newly refresh database and i need to enable ddl replication on our GG.

but i’m getting *** Please move GGS_ADMIN to its own tablespace
Continue reading

Advertisements

ORA-06512: at line 1 SQL BEGIN sys.dbms_xstream_gg.SET_FOO_TRIGGER_SESSION_CONTXT (fire=>TRUE); END;.

Just another day n the office where our Development was refresh from production.

Development DB is configured to have GG multi bidirectional replication.
I started the Manager, extract and pump without any issue but when starting the replicat i’m getting below error.

2016-05-09 13:34:41  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ckn2ure2.prm:  PROCESS ABENDING.
2016-05-09 13:40:18  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): start CKL2BRE2.
2016-05-09 13:40:18  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host gcxxxx2s:37774 (START REPLICAT CKL2BRE2 ).
2016-05-09 13:40:18  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  REPLICAT CKL2BRE2 starting.
2016-05-09 13:40:19  INFO    OGG-00995  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  REPLICAT CKL2BRE2 starting.
2016-05-09 13:40:19  INFO    OGG-03035  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2016-05-09 13:40:19  ERROR   OGG-00868  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  ORA-26944: User "GGS_ADMIN" attempted to invoke a procedure without proper permissions.
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 197
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 230
ORA-06512: at "SYS.DBMS_XSTREAM_GG", line 9
ORA-06512: at line 1 SQL BEGIN sys.dbms_xstream_gg.SET_FOO_TRIGGER_SESSION_CONTXT (fire=>TRUE); END;.
2016-05-09 13:40:19  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ckl2bre2.prm:  PROCESS ABENDING.
oracle@gcxxxx2s[CXXXESIT2] /gg111/112/11.2/11g =>

Continue reading

No valid default archive log destination directory found for thread 2

Recently we refresh our dev database from prod using rman cloning, totaling of 4 database representing 4 regions.

Oracle GG is use to replicate the data, multi bidirectional replication.

after the rman cloning, i started the GG using begin now but i’m getting below error with our main extract, pump and replicat is working fine.

2016-04-10 11:27:03  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  No valid default archive log destination directory found for thread 2.
2016-04-10 11:27:03  INFO    OGG-00546  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  Default thread stack size: 10485760.
2016-04-10 11:27:03  ERROR   OGG-00446  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  The number of Oracle redo threads (2) is not the same as the number of checkpoint threads (1). EXTRACT groups on RAC systems should be created with the THREADS parameter (e.g., ADD EXT , TRANLOG, THREADS 2, BEGIN...).
2016-04-10 11:27:03  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, cknm2bet.prm:  PROCESS ABENDING.

Continue reading

ERROR OGG-05500 Detected database metadata mismatch between current trail file

early at work today, i encountered a very seldom error in oracle gg. the OGG-05500.
checking the history of the database, recently one of our database we migrated it to its dedicated server.

Old DB Name : CXXXLU
New DB Name : CXXXLATU

our gg configuration is multibidirectional replication.
here is the error i receive in one of our replicat.

 
016-04-01 23:22:14  INFO    OGG-00996  Oracle GoldenGate Delivery for Oracle, ckltbrnm.prm:  REPLICAT CKLTBRNM started.
2016-04-01 23:22:24  ERROR   OGG-05500  Oracle GoldenGate Delivery for Oracle, ckltbrnm.prm:  Detected database metadata mismatch between current trail file /gg111/112/11g/dirdat/cxxxnuat/IN/LT/br000382 and the previous sequence.
DBNAME: [CXXXLATU]/[CXXXLU]
DBINSTANCE: [CXXXLATU1]/[CXXXLU1]
*DBCLIENTCHARSET: [0]/[1073741824].
2016-04-01 23:22:24  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, ckltbrnm.prm:  PROCESS ABENDING.

Continue reading

how to resync table for oracle golden gate.

its monday morning, and most of the time i’m doing nothing. my bz day of the week is from Tuesday to Thursday.hmmmm sometime friday.
today, a colleague of mine from other side of the world handover me a task to resync a table that being use for our goldengate replication.

1. exclude table need to be resync

2. check if no lag on repicat side.
3. stop replicat and extract
4. export table using datapump.
Continue reading