Binnary Ajay Kumar – KTEXPERTS

Shell script to alert us when specified background process exceeds limit

3 years ago by Binnary Ajay KumarOracle Production Support Scripts

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

#!/bin/bash
# Syntax to run this script
# ./running_process.sh oracle 100 170
# ./running_process.sh PROCESS_NAME WARNING CRITICAL
export MAILIST='ajaykumar@ktexperts.com,
process_name=$1
_limit1=$2
_limit2=$3
_proc=`ps -ef | grep $process_name | wc -l`
if [ "$_proc" -ge "$_limit2" ]
 then
echo "Current Running $process_name Proccess is running too high $_proc " > /tmp/proc.log
cat /tmp/proc.log
cat /tmp/proc.log | mailx -s "${TODAY} - Current Running $process_name Proccess is running too high/Critical $_proc " ${MAILIST}
else
if [ "$_proc" -ge "$_limit1" ]
 then
echo "Current Running $process_name Proccess is running more than expected $_proc " > /tmp/proc.log
cat /tmp/proc.log
cat /tmp/proc.log | mailx -s "${TODAY} - Current Running $process_name Proccess is running more than expected $_proc  " ${MAILIST}
fi
fi

#!/bin/bash

# Syntax to run this script

# ./running_process.sh oracle 100 170

# ./running_process.sh PROCESS_NAME WARNING CRITICAL

export MAILIST='ajaykumar@ktexperts.com,

process_name=$1

_limit1=$2

_limit2=$3

_proc=`ps -ef | grep $process_name | wc -l`

if [ "$_proc" -ge "$_limit2" ]

then

echo "Current Running $process_name Proccess is running too high $_proc " > /tmp/proc.log

cat /tmp/proc.log

cat /tmp/proc.log | mailx -s "${TODAY} - Current Running $process_name Proccess is running too high/Critical $_proc " ${MAILIST}

else

if [ "$_proc" -ge "$_limit1" ]

then

echo "Current Running $process_name Proccess is running more than expected $_proc " > /tmp/proc.log

cat /tmp/proc.log

cat /tmp/proc.log | mailx -s "${TODAY} - Current Running $process_name Proccess is running more than expected $_proc " ${MAILIST}

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

Basic commands in PostgreSQL

3 years ago by Binnary Ajay KumarPostgreSQL

Hello Everyone, This article will help you learning basic commands in postgreSQL. Psql is an interactive terminal to work with the PostgreSQL database. It is used to retrieve data from the PostgreSQL database server faster and more effectively. The below commands are very helpful for… Read More

How to change remote trail file location in Oracle GoldenGate.

3 years ago by Binnary Ajay KumarGolden Gate

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 :

GGSCI (gg.oracle.com) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPAWSP1 00:00:00 00:00:06
EXTRACT RUNNING EXAWSP1 00:00:03 00:00:05

GGSCI (gg.oracle.com) 2> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPAWSP1 00:00:00 00:00:06

EXTRACT RUNNING EXAWSP1 00:00:03 00:00:05

Target :

GGSCI (gg2.oracle.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
REPLICAT RUNNING REPAWSP1 00:00:08 00:00:04

GGSCI (gg2.oracle.com) 6> info all

Program Status Group Lag at Chkpt Time Since Chkpt

REPLICAT RUNNING REPAWSP1 00:00:08 00:00:04

Check Replicat trail file location

GGSCI (gg2.oracle.com) 2> info REPAWSP1 detail 

REPLICAT   REPAWSP1  Last Started 2021-12-10 01:01   Status RUNNING
INTEGRATED
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Process ID           45824
Log Read Checkpoint  File /u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321
                     2022-01-22 06:44:24.997155  RBA 202887709
INTEGRATED Replicat
No DBLOGIN Provided, constructed inbound server name is OGG$REPAWSP1
Current Log BSN value: (requires database login)
Low Watermark CSN value: (requires database login)
High Watermark CSN value: (requires database login)
  Extract Source                          Begin             End             
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321  2021-12-10 00:38  2022-01-22 06:44
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658  2021-12-10 00:14  2021-12-10 00:38
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658  2021-11-12 04:02  2021-12-10 00:14
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000000000  * Initialized *   First Record    
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000000000  * Initialized *   First Record    
Current directory    /u01/app/oracle/product/ogg_src
Report file          /u01/app/oracle/product/ogg_src/dirrpt/REPAWSP1.rpt
Parameter file       /u01/app/oracle/product/ogg_src/dirprm/REPAWSP1.prm
Checkpoint file      /u01/app/oracle/product/ogg_src/dirchk/REPAWSP1.cpr
Process file         
Error log            /u01/app/oracle/product/ogg_src/ggserr.log

GGSCI (gg2.oracle.com) 2> info REPAWSP1 detail

REPLICAT REPAWSP1 Last Started 2021-12-10 01:01 Status RUNNING

INTEGRATED

Checkpoint Lag 00:00:00 (updated 00:00:07 ago)

Process ID 45824

Log Read Checkpoint File /u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321

2022-01-22 06:44:24.997155 RBA 202887709

INTEGRATED Replicat

No DBLOGIN Provided, constructed inbound server name is OGG$REPAWSP1

Current Log BSN value: (requires database login)

Low Watermark CSN value: (requires database login)

High Watermark CSN value: (requires database login)

Extract Source Begin End

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321 2021-12-10 00:38 2022-01-22 06:44

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658 2021-12-10 00:14 2021-12-10 00:38

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658 2021-11-12 04:02 2021-12-10 00:14

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000000000 * Initialized * First Record

Current directory /u01/app/oracle/product/ogg_src

Report file /u01/app/oracle/product/ogg_src/dirrpt/REPAWSP1.rpt

Parameter file /u01/app/oracle/product/ogg_src/dirprm/REPAWSP1.prm

Checkpoint file /u01/app/oracle/product/ogg_src/dirchk/REPAWSP1.cpr

Process file

Error log /u01/app/oracle/product/ogg_src/ggserr.log

Remote trail file location… Read More

OGG-08223 Error when registering Extract for a container database.

3 years ago by Binnary Ajay KumarGolden Gate

OGG-08223 Error when registering Extract for a container database. Hi Experts. In this article, we will see the OGG-08223 Error when registering Extract for a container database. I do have a plans to setup replication between the pluggable database in different containers. When registering… Read More

Oracle : Adding new table to existing GoldenGate Replication without downtime

3 years ago by Binnary Ajay KumarAdd new table to existing GoldenGate Replication

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

[oracle@GG11 19c12]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

[oracle@GG11 19c12]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO

Operating system character set identified as UTF-8.

Oracle : Shell script for RMAN backup of Standby Database

3 years ago by Binnary Ajay KumarOracle DB Admin

Oracle : Shell script for RMAN backup of Standby Database In this article, we wrote an automation job for Shell script for RMAN backup of Standby Database The below script will be initiating the RMAN backup on the standby database: RMAN Script : [oracle@tewnposqa1 scripts]$… Read More

How to drop a Oracle RAC database manually

3 years ago by Binnary Ajay KumarOracle Architecture

How to drop a two-node Oracle RAC database database manually. In this article, we wrote an Clear steps for dropping a two node oracle database with Pre-requisite steps. Server: sewnpossqa01/02 Database : npossqa1 DB Unique name: sewnpossqa1 Step 1: Take consistent export of NPOSSQA1 database… Read More

How to add Container database to Existing RMAN Recovery catalog

4 years ago by Binnary Ajay KumarOracle DB Admin

Hello Readers, In this article ,we will see how to a container database to the existing RMAN recovery catalog. Please check below article before adding container database to RMAN Catalog. How to Create an RMAN Recovery Catalog Target Database : … Read More

How to Create an RMAN Recovery Catalog

4 years ago by Binnary Ajay KumarOracle DB Admin

Hello Readers, In this article, we will see Creation of RMAN Recovery Catalog. Target Database : Catalog Database: Name : AVPROD … Read More

Oracle 19c Software Installation On Linux 7.6

4 years ago by Binnary Ajay KumarOracle 19c

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

[oracle@oracle19c ~]$ mkdir -p /oracle/app/product/19.3.0/dbhome_1

1	[oracle@oracle19c ~]$ mkdir -p /oracle/app/product/19.3.0/dbhome_1

Unzip the oracle 19c software

[oracle@oracle19c ~]$ unzip -d /oracle/app/product/19.3.0/dbhome_1/LINUX.X64_193000_db_home.zip

1	[oracle@oracle19c ~]$ unzip -d /oracle/app/product/19.3.0/dbhome_1/LINUX.X64_193000_db_home.zip

Goto Oracle home location and run the ./runinstaller

[oracle@oracle19c dbhome_1]$ ./runInstaller 
Launching Oracle Database Setup Wizard...

1 2	[oracle@oracle19c dbhome_1]$ ./runInstaller Launching Oracle Database Setup Wizard...

Start… Read More