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