Home » Server Options » Replication » GoldenGate Error (Oracle 12 GoldenGate and 11gR2 database; RHEL 6.5)
GoldenGate Error [message #659991] Tue, 07 February 2017 02:55
morad_dba
Messages: 93
Registered: June 2008
Member
Dear all,

I am testing GoldenGate. I am using GoldenGate 12c for replication using Database 11g on two seperate nodes.


In noode 1
========

I am getting error like below:

[oracle@gg1 gg_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 11g on Dec 12 2015 00:54:38
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.

GGSCI (gg1) 2> dblogin userid ggowner password ggowner;
Successfully logged into database.

GGSCI (gg1 DBLOGIN as ggowner) 3> add trandata hr.*
ERROR: Could not retrieve default catalog name.


What does default catalog mean?

Am i missing any step?

I completed the step like

SQL> @role_setup.sql

Enter GoldenGate schema name:ggowner

SQL> GRANT GGS_GGSUSER_ROLE TO ggowner;

Grant succeeded.

But Same catalog errors appears.


NOTE:
SQL> select NAME, LOG_MODE, FORCE_LOGGING, SUPPLEMENTAL_LOG_DATA_MIN from v$database;

NAME      LOG_MODE     FOR SUPPLEME
--------- ------------ --- --------
ORCL1     ARCHIVELOG   YES YES



Regards,
Morad.


[Updated on: Tue, 07 February 2017 03:06]

Report message to a moderator

Previous Topic: Import Tables to Source Schema in Golden Gate
Next Topic: DDL execution Impact : GG having only DML configuration
Goto Forum:
  


Current Time: Thu Mar 28 07:36:14 CDT 2024