ERROR: No Checkpoint Table Specified For ADD REPLICAT

In this post, we are going to have look at Goldengate issue.

While adding the replicate, you may get the below error.

GGSCI (sec75-2) 2> add replicat LOYTSTR, exttrail /ggatebss/oradata/RBM12C/R4

ERROR: No checkpoint table specified for ADD REPLICAT.

Solution:

Checkpoint table needs to be created on the replication side.

1. Login to ggsci with dblogin

GGSCI (sec75-2) 4> dblogin USERID TEST_GGATE, PASSWORD TEST_GGATE

Successfully logged into a database.

2. Add checkpoint table

GGSCI (sec75-2 as (more...)

ORA-14452: attempt to create, alter or drop an index on temporary table already in use

I wanted to begin all my GoldenGate configurations as new setup. So I have disabled ddl support and removed marker. Then I have dropped all GG schema tables but one table named GGS_STICK is returned error “ERROR at line 1:
ORA-14452: attempt to create, alter or drop an index on temporary table already in use

SQL> drop user gg cascade;
drop user gg cascade
*
ERROR at line 1:
ORA-00604: error occurred at  (more...)

Goldengate 12.3 Automatic CDR

Automatic Conflict Detection and Resolution

Requirements: GoldenGate 12c (12.3.0.1) and Oracle Database 12c Release 2 (12.2) and later.

Automatic conflict detection and resolution does not require application changes for the following reasons:

  • Oracle Database automatically creates and maintains invisible timestamp columns.
  • Inserts, updates, and deletes use the delete tombstone log table to determine if a row was deleted.
  • LOB column conflicts can be detected.
  • Oracle Database automatically configures supplemental logging on required (more...)

CRS-2674: Start of dbfs_mount failed

$ crsctl start resource dbfs_mount
CRS-2672: Attempting to start ‘dbfs_mount’ on ‘node2’
CRS-2672: Attempting to start ‘dbfs_mount’ on ‘node1’
CRS-2674: Start of ‘dbfs_mount’ on ‘node1’ failed
CRS-2679: Attempting to clean ‘dbfs_mount’ on ‘node1’
CRS-2674: Start of ‘dbfs_mount’ on ‘node2’ failed
CRS-2679: Attempting to clean ‘dbfs_mount’ on ‘node2’
CRS-2681: Clean of ‘dbfs_mount’ on ‘node1’ succeeded
CRS-2681: Clean of ‘dbfs_mount’ on ‘node2’ succeeded
CRS-4000: Command Start failed, or completed with errors.

Check to make sure DBFS_USER password is (more...)

OGG-00868/ORA-01291 – Missing log files with Integrated Extract

Oracle GoldenGate is reliant on the Oracle Redo Logs and Archive Logs when capturing transactions. Since I do a lot of testing on VMs (limited space) and in the cloud (limited space … don’t want to burn to much $), I often delete my archive logs. Normally this is not a problem; however, every once-in-awhile I delete more archivelogs than I should. This throws the IE into a state where it will not start because (more...)

#GoldenGate Microservices (3 of 5) … Distribution Service

This is post 3 of a 5 part post related to Oracle GoldenGate 12.3 Microservices. This series of posts will provide some details over the new graphical user interface (GUI) that has been built into Oracle GoldenGate 12.3.

The third part of setting up the replication enviornment with Microservices is to understand what the Distributuion Server is. The component is the replacement for the Data Pump Extract in classic architecture. Distribution Server does (more...)

#GoldenGate sessions at #OOW17

We are a little over a week out from Oracle Open World 2017; hopefully you are filling out your schedules! This year there is a lot of items going on; so I figured I would help you out and point out where you can find the Oracle GoldenGate sessions this year! With the release of Oracle GoldenGate 12.3, there is a lot of new features and updates. So check them out (in no particular (more...)

Managing the WINDOW_ID in Goldengate V11.2.1.0.33

When we import data into the landing schema on a Dat Warehouse via Goldengate, we add 3 fields to each record detailing when and how the record got loaded. This can be found in the *.inc files under $GG_HOME/dirinc on the target GG installation. An example of this is:
map xxx.DBA_GGCUTOVER_TEST, TARGET YYY.DBA_GGCUTOVER_TEST,  INSERTALLRECORDS, IGNOREDELETES
COLMAP (
USEDEFAULTS,
WINDOW_ID = @STRCAT(@GETENV(“RECORD”, “FILESEQNO”), @STRNUM(@GETENV(“RECORD”, “FILERBA”), RIGHTZERO, 10)),
OPER_TYPE = @GETENV (“GGHEADER”, “OPTYPE”),
CDC_LOAD_TIMESTAMP= (more...)

GoldenGate – Restarting a replicat with the command filterduptransactions

If a Goldengate replicat process fails then occasionally on the restart it skips the correct RBA and ‘loses it’s position’. The relative byte address (RBA) is the location within the trail file to indicate the current transaction.

The old school method was to calculate which RBA was the correct one and then restart the replicat. However there is a new command on the block now (pun intended) and I will demonstrate how the two methods (more...)

Troubleshoot Oracle GoldenGate Using Exception Handler

By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism. When this happens you need to troubleshoot the issue and correct it before the Replicat process can proceed. But this wouldn’t be easy, as sometimes it can take […]

The post Troubleshoot Oracle GoldenGate Using Exception Handler appeared first on VitalSoftTech.

OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract

When creating the GoldenGate Integrated Extract why do I get the message "ENABLE_GOLDENGATE_REPLICATION is not set to true"?

The post OGG-02060: ENABLE_GOLDENGATE_REPLICATION is not set to true for Integrated Extract appeared first on VitalSoftTech.

OGG-02060 The Oracle Mining Database is not Configured Properly to Support Integrated Capture.

When creating the GoldenGate Integrated Extract I get the OGG-02060 error. How do I resolve it?

The post OGG-02060 The Oracle Mining Database is not Configured Properly to Support Integrated Capture. appeared first on VitalSoftTech.

Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue!

Use DBMS_PARALLEL_EXECUTE to divide one huge task into multiple small tasks that can be executed at the same time. See how many ways are there to divide.

The post Want to SPEED Up Your Database Tasks? DBMS_PARALLEL_EXECUTE to the rescue! appeared first on VitalSoftTech.

GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function

In most environments one set of GoldenGate process (1 Extract & 1 Replicat process) is sufficient for change data synchronization. But if your source database generates a huge volume of data then a single process may not be sufficient to handle the data volume. In such a scenario there may be need to split the […]

The post GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function appeared first on VitalSoftTech.

GoldenGate Active-Active Database Replication with Conflict Detection and Resolution

Bi-Directional Replication also known as Active-Active Replication, is a configuration where both databases are used as an active site and applications perform DML/DDL activities on both Databases. The OGG processes is configured to replicate the transaction data of both the source databases back and forth to each other. 1. Advantages Bi-directional GoldenGate Replication can be […]

The post GoldenGate Active-Active Database Replication with Conflict Detection and Resolution appeared first on VitalSoftTech.

Oracle GoldenGate Data Transformation

Oracle GoldenGate supports data mapping and manipulation. It is done by using options of Table (Extract) and Map (Replicat) parameters. By default OGG assumes that SOURCE and TARGET table definitions are same that part of replication.

The post Oracle GoldenGate Data Transformation appeared first on VitalSoftTech.

Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox

If you have your Oracle VM VirtualBox setup and running there is a possibility that you may need to setup the network for the Virtual Machine to make it accessible from the host machine (Desktop or Laptop). This may be needed when you want to connect your local applications to the database running on the VM VirtualBox.

The post Oracle VM VirtualBox Tutorial: Connecting Applications from your Desktop to a database on VirtualBox appeared first (more...)

How to Provision Oracle VM VirtualBox using Pre-Built Developer VMs

The post How to Provision Oracle VM VirtualBox using Pre-Built Developer VMs appeared first on VitalSoftTech.

Learn GoldenGate – The Index

Learn about GoldenGate Extract, Pump, Replicat, GGSCI, Logdump, Troubleshooting and Upgrade.

The post Learn GoldenGate – The Index appeared first on VitalSoftTech.

Oracle GoldenGate 11gr2 Upgrade

This article demonstrates the steps to perform an in-place Oracle GoldenGate 11gr2 Upgrade (11.2.0.2). Expectations and Requirements There should be NO DATA LOSS. There should be NO database downtime. Oracle GoldenGate processes names will remain unchanged. Oracle GoldenGate replication will be DOWN for the period of OGG upgrade activity. Upgrade Oracle GoldenGate binaries Source and […]

The post Oracle GoldenGate 11gr2 Upgrade appeared first on VitalSoftTech.