Friday, 14 June 2019

OGG-02060 The Oracle mining database is not configured properly to support integrated capture

GGSCI (source.example.com as ggadmin@DB11G) 22> register extract extract1 database
2019-06-15 01:25:58 ERROR OGG-02060 The Oracle mining database is not configured properly to support integrated capture. The following configuration error must be fixed: Operation not supported because enable_goldengate_replication is not set to true.

==> alter enable_goldengate_replication to true in database.

SQL> show parameter enable_goldengate_replication
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE

SQL> alter system set enable_goldengate_replication=true scope=spfile;
System altered.

SQL> show parameter enable_goldengate_replication
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean TRUE

GGSCI (source.example.com) 1> dblogin userid ggadmin@srcdb password ********
Successfully logged into database.
GGSCI (source.example.com as ggadmin@DB11G) 2> register extract extract1 database
2019-06-15 01:29:21 INFO OGG-02003 Extract EXTRACT1 successfully registered with database at SCN 1063327.
GGSCI (source.example.com as ggadmin@DB11G) 3>

No comments:

Post a Comment

Login to the database as user C##GGUSER failed because of error Error while trying to retrieve text for error ORA-01804.

 Error :  2026-09-19 11:28:18  ERROR   OGG-00303  Unable to connect to database using user C##GGUSER@CDB. Ensure that the necessary privileg...