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