ON CALL DBA SUPPORT

— Database blog

Archive for December 16th, 2015

WARNING OGG-00706 Failed to add supplemental log group on table

Posted by ssgottik on 16/12/2015

GGSCI (nracm1 as gguser@source) 28> add trandata scott.account

Logging of supplemental redo log data is already enabled for table scott.ACCOUNT.

2015-12-16 04:06:58 WARNING OGG-00706 Failed to add supplemental log group on table scott.ACCOUNT due to ORA-32588: supplemental logging attribute primary key exists SQL ALTER TABLE “scott”.”ACCOUNT” ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE, FOREIGN KEY) COLUMNS /* GOLDENGATE_DDL_REPLICATION */.

SOLUTION :

GGSCI (nracm1 as gguser@source) 29> delete trandata scott.account

Logging of supplemental redo log data disabled for table scott.ACCOUNT.
TRANDATA for scheduling columns has been disabled on table ‘scott.ACCOUNT’.
GGSCI (nracm1 as gguser@source) 30> add trandata scott.account

Logging of supplemental redo data enabled for table scott.ACCOUNT.
TRANDATA for scheduling columns has been added on table ‘scott.ACCOUNT’.
GGSCI (nracm1 as gguser@source) 31>

Posted in ORACLE GOLDEN GATE | Leave a Comment »

INSTALLING ORACLE 12C GOLDEN GATE

Posted by ssgottik on 16/12/2015

1. UNZIP THE SOFTWARE

unzip gg software

2. GO TO Disk1

cd Disk1

3. RUN runInstaller

runInstaller

4. You will get GUI, you can install GG 12 BOTH ON 11G DATABASE AND 12C DATABASE :

STEP01

5. CLICK NEXT BY SELECTING YOUR DATABASE , HERE YOU NEED TO SPECIFY THE GG HOME LOCATION AND THE MANAGER PORT :

STEP02

6. CLICK NEXT :

STEP03

7. CLICK NEXT :

STEP04

8. INSTALLATION COMPLETE , CLOSE THE WINDOW:

STEP05

Posted in ORACLE GOLDEN GATE | Leave a Comment »