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

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...