Shell script to alert us when specified background process exceeds limit

Hello Everyone, The below script will help us to find number of processes runs in the background and send us alerts based on warning and critical thresholds. Script : # ]$ cat /home/oracle/DBA/bin/running_process.sh

Script execution : Syntax : ./running_process.sh <PROCESS_NAME> <WARNING> <CRITICAL> Here I… Read More

How to change remote trail file location in Oracle GoldenGate.

Hello Everyone, This article will teach you how to change remote trail file location in Oracle GoldenGate. Current location :  /u01/GG_AWS_P1/GG_trails/aws_trails/ New Location :  /dbbackup/GG_trails/aws_trails GG Process Details :  Source :

Target : 

Check Replicat trail file location

Remote trail file location… Read More

Oracle : Adding new table to existing GoldenGate Replication without downtime

Adding new table to existing GoldenGate Replication In this article, we will add a new table in existing GG replication setup without downtime using filter (@GETENV (‘TRANSACTION’,’CSN’) > scn number); Source : GG11 Target : GG12 Source :  Connect and Login to the ggsci 

Read More

Oracle 19c Software Installation On Linux 7.6

In this article, we will see Oracle 19c (19.3) Software Installation On Linux 7.6 Click here to Download Oracle 19c Software from Oracle Support. Create a directory for ORACLE_HOME

Unzip the oracle 19c software

Goto Oracle home location and run the ./runinstaller

Start… Read More