Oracle : Shell script for Crontab Monitoring alert

Hi Readers, In this article, we will see the Oracle : Shell script for Crontab Monitoring alert THIS SCRIPT WILL IDENTIFY changes with the crontab file made comparing with original file.

Config file :

Create original crontab file :

Add below… Read More

Oracle : RAC Important Commands (SecureCRT)

RAC Important Commands (SecureCRT) Dear Readers, In this article, we will see the Oracle : Important Commands for RAC (SecureCRT) Menu Bar : RAC Button : VD_Location

Button : ocrcheck

Button : ConfigDB

Button : config service

Button… 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 : Shell Script to Send email if RAC services not running

Dear Readers, In this article, we wrote an automation job for  Shell Script to Send email if RAC services not running The below script will be sending an email if any services are stopped on RAC Nodes.

Script : 

–> It ignores some… Read More

Autonomous Transaction Processing

Autonomous Transaction Processing In this article, we will know about “ATP”   Oracle Autonomous Transaction Processing delivers a self-driving, self-securing, self-repairing database service that can instantly scale to meet the demands of a variety of applications: mission-critical transaction processing, mixed transactions and analytics, IoT, JSON… Read More