ORACLE DATABASE

Database Migration in Oracle: Best Choice

If you are interested in database migration in Oracle, then the best options await you. Not only are the options of migrating becoming easier, in addition, the entire process has now been established in order for professional services to complete the migration without any complications. Why Database Migration in...

Read More

DATA MIGRATION

4 Reasons for Data Migration

The growth of technology has encourgaed businesses to use new strategies to handle the big data of their companies. One of the strategies is data migration. This method of transferring data moves the less valuable data out of the production system while keeping the sensitive data under the authoritative access. There...

Read More

ORACLE GOLDENGATE

What You Need to Set Up Oracle Goldengate

In order to set up or shift to the Goldengate, a company needs to create the necessary environment to favor this type of database system. There are many ways to cultivate the favorable environments, which can be understood through the assistance of Goldengate migration experts. However, there are some basic...

Read More

ORACLE MIGRATION

Seeking Fundamentals of Oracle Migration

It is quite known to the common public that Oracle is known for a provision of a wide range of “relative migration services” that necessarily transcends the transfer of data across different platforms to Oracle. In order to be acquainted with the use of Oracle technology at its fundamental...

Read More

Oracle Goldengate – unable to start integrated replicat – OGG-00446

For one of our projects, we upgraded Goldengate version to 12.2.0.1. After upgrading to newer version, I am able to successfully add new replicats. But when I tried starting the replicat, I encountered the following error: 2016-09-04 11:50:58 ERROR OGG-00446 Supplemental checkpoint table does not exist. Create a supplemental...

Read More

ORACLE GOLDENGATE

Goldengate – Integrated Capture fails with OGG-02912

Here is one of my recent experiences running Oracle Goldegange 12.2.0.1 against Oracle 11.2.0.4 database. I was able to add Goldengate Extract Integrated process successfully without any issues. But when I tried starting the extract process, extract failed with the following error: 2016-09-04 23:49:30 ERROR OGG-02912 Patch 17030189 is...

Read More

GOLDENGATE MIGRATION

Goldengate Integrated Extract – Identifying and resolving extract process hang issue

Goldengate extract process can hang for various reasons. It is very important to have a process in place to monitor goldengate process and detect hanging issues. I recently encountered Goldengate Extract Hang issue. Below is how I resolved this issue: Copy the following SQL and save to file – dba_capture_info.sql:...

Read More