Sunday, July 15, 2018

ERROR OGG-08221 Cannot register or unregister EXTRACT because of the following SQL error: OCI Error 1,653.



DB Version:  12.1.0.2.0
GG Version:  12.2

SET Database environment
Login to database from ggsci using goldengate alias (or) with user/password if Alias not created

mylocaldev.domain.com : dbstage:/goldengate/home $ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (mylocaldev.domain.com as GGADMIN@dbstage) 1> dblogin useridalias ggadmin
Successfully logged into database.

GGSCI (mylocaldev.domain.com as GGADMIN@dbstage) 2> register extract EMYDBST database

2017-08-23 13:10:58  ERROR   OGG-08221  Cannot register or unregister EXTRACT EMYDBST because of the following SQL error: OCI Error 1,653.


In DB alert log:

Wed Aug 23 13:28:44 2017
ORA-1653: unable to extend table SYS.AUD$ by 128 in tablespace SYSTEM
ORA-1653: unable to extend table SYS.AUD$ by 1024 in tablespace SYSTEM

Ok now we know the issue and once the tablespace space issue is resolved then GG register command is success, Cheers !!


0 comments:

Post a Comment

Auto Scroll Stop Scroll