if you are receiving this error while registering the extract
GGSCI (oel601 as ggadmin@TROY_1) 7> dblogin userid ggadmin@TROY password ggadmin
Successfully logged into database.
GGSCI (oel601 as ggadmin@TROY_2) 8> register extract E_WBR01 database;
2020-08-25 14:21:58 WARNING OGG-02064 Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.
2020-08-25 14:21:58 ERROR OGG-15415 Log archive destination at the source database must be configured with the NOREGISTER attribute for destination id '1'.
2020-08-25 14:21:58 ERROR OGG-15415 Log archive destination at the source database must be configured with the NOREGISTER attribute for destination id '1'.
as per (Doc ID 2414573.1)
remove unique name from local archive destination
SQL> sho parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST valid_for=(ALL_LOGFILES,A
LL_ROLES) DB_UNIQUE_NAME=TROYalter system set log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES)' scope=both sid='*';
SQL> sho parameter log_archive_dest_1
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_1 string LOCATION=USE_DB_RECOVERY_FILE_
DEST valid_for=(ALL_LOGFILES,A
LL_ROLES)now able to register extract
GGSCI (oel601 as ggadmin@TROY_2) 9> register extract E_WBR01 database;
2020-08-25 14:34:25 WARNING OGG-02064 Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.
2020-08-25 14:34:59 INFO OGG-02003 Extract E_WBR01 successfully registered with database at SCN 68899852715.
DBATracker 