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.
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.
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.