ON CALL DBA SUPPORT

— Database blog

Archive for December, 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>

Advertisements

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 »

Configuring ASM failed with the following message: ORA-00845: MEMORY_TARGET not supported on this system

Posted by ssgottik on 13/12/2015

ERROR DURING INSTALLATION :
Configuring ASM failed with the following message:
Configuring HA resource failed. The following error occurred:
PRCR-1079 : Failed to start resource ora.asm
CRS-5017: The resource action “ora.asm start” encountered the following error:
ORA-00845: MEMORY_TARGET not supported on this system
. For details refer to “(:CLSN00107:)” in “/u01/app/grid/diag/crs/nracm1/crs/trace/ohasd_oraagent_grid.trc”.

CRS-2674: Start of ‘ora.asm’ on ‘nracm1’ failed

SOLUTION :

Starting with Oracle Database 12c, If MEMORY_MAX_TARGET or MEMORY_TARGET is set to a non zero value, and an incorrect size is assigned to the shared memory, it will result in an ORA-00845 error at startup.

Increase the size of MEMORY_TARGET and RESTART THE INSTALLATION.

Thanks

Posted in ASM | Leave a Comment »