“Wait for a undo record” OR “Wait for stopper event to be increased” database wait events

We faced a scenario in our database where users were complaining about database performance. Database seems to be hanging and queries were either stuck or not running at all. It was also seen that UNDO tablespace consumption was increasing. [Post Views: 10]

Read more

The Applications File Server could not open the file for read in Oracle EBS

One of our EBS R12 instance was giving below kind of errors when users were trying to open the log and out files of Concurrent requests from EBS front end. “The Applications File Server could not open the file /fs01/logs/appl/conc/log/l106163221.req for ...

Read more

Oracle GoldenGate 12c New Features Overview

GoldenGate 12c version  has many great features as compared to older versions. Below are some of the key new features of Oracle GoldenGate 12c that are worth mentioning [Post Views: 18]

Read more

GoldenGate Initial Troubleshooting Tips for Begineers

When we face issues in GoldenGate extract or replicat setup, we follow some of the tried and tested initial troubleshooting steps mentioned below that helps us in pointing out the exact case of the issue. To start with, GGSCI commands which are useful for Gath...

Read more

Oracle ASM – ORA-19504: failed to create file – SVR4 Error: 13: Permission denied

During one of our 11gR2 database restore activity we found below error message in the RMAN “duplicate database command” channel aux4: ORA-19870: error while restoring backup piece /oraclone/ORCL/rman_clone/ORCL_F_20170605_c1s60alv_1_1 ORA-19504: fa...

Read more

GoldenGate Downstream deployment – Basics

GoldenGate Downstream deployment allows you to offload the source database extract load to intermediate or target server. The source database ships its redo logs to a downstream database, and Extract uses the logmining server at the downstream database to mine...

Read more

Frequently Used GoldenGate Commands

Below are some of the GoldenGate commands that we use frequently. We work on GoldenGate 12c version but almost all commands work in same manner in 11g and 12c. MANAGER RELATED COMMANDS COMMAND DESCRIPTION INFO MANAGER or INFO MGR or STATUS MANAGER Displays the...

Read more

Performance Tuning Tips for GoldenGate

There are a number of factors that we need to keep in mind to be able to successfully tune a GoldenGate Setup. If you carefully design your system keeping in mind the end goal and apply some proven performance tuning measures you should be able to get real tim...

Read more

GoldenGate Subdirectories Brief Details

After successfully installing Oracle GoldenGate 12c, it will create a lot of sub-directories structure which will be used by the different components of Oracle GoldenGate. There are so many directories that new user will get confused what to look where.The dir...

Read more

Oracle Golden Gate Interview Questions

Q 1: What is Oracle GoldenGate? A 1: Oracle GoldenGate 12c is a fancy name for a piece of software which enables the continuous, real-time capture, routing, transformation, and delivery of transactional data across heterogeneous environments. So it transfers c...

Read more
1 2 3 13