Tuesday, January 24, 2017

Replicate process stopped due ot ORA-01536 even sufficient space available in tablespace


Replicate process stopped due to ORA-01536 even sufficient space available in table-space



OGG-01815  Oracle GoldenGate Delivery for Oracle, replicate.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /home/oracle/app/oracle/product/12.1.0/dbhome_2/dirtmp.
OGG-00446  Oracle GoldenGate Delivery for Oracle, replicate.prm:  OCI Error ORA-01536: space quota exceeded for tablespace 'OGG_DATA' (status = 1536). Inserting into checkpoint table OGG_USER.GGS_CHECKPOINT, group RSCOTT, SQL .
OGG-01668  Oracle GoldenGate Delivery for Oracle, replicate.prm:  PROCESS ABENDING.




Cause: -Replicate process stop in target database with ORA-01536 error.But sufficient space is available in the database.
Reason:-Goldengate user don’t have unlimited tablespace permission in the database. But we need to follow the below steps in source database.( Doc ID 1930290.1)

1)      @ddl_disable.sql
2)      Grant permission to the user.
3)      @ddl_enable.sql

The below error displayed if you try to grant permission without above steps.


Now start the replicate process in target and check the goldengate logfile.