Oracle EXPDP/IMPDP (DATAPUMP) Monitoring Scripts

Usually we monitor the EXPDP/IMPDP jobs by monitoring the log files generated by expdp/impdp process.  Also we monitor alert log too just in case some error pops up. This helps most of the time. If you have a long running expdp/impdp sessions as you are expor...

Read more

EBS Database Parameter Settings Analyzer

All Oracle Apps DBA must have referred below Note id at least once in their career. Most of us refer it  during installation and upgrade of Oracle EBS application to verify if we have right set if database parameters defined for the optimum performance of EBS...

Read more

Connecting Oracle Database and SQL Server – Basic Concepts

It is required sometime to connect oracle database to SQL Server database using uni-direction or bi-direction methods. Since these are two different database so something as simple as direct DBLINK will not work here. Below are the basic concepts of making con...

Read more

“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: 58]

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: 39]

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
1 2 3 13