CREATE ORACLE 12c PLUGGABLE DATABASE MANUALLY In this article, we will learn how to create oracle 12c pluggable database (SHOPDB1) from seed pluggable database (PDB$SEED) in the same container database (SHOCDB1) using the manual command 👇👇👇👇 Please check the below link for the… Read More
CREATE & DROP ORACLE 12c PLUGGABLE DATABASE WITH DBCA In this article, we will learn how to create and drop oracle 12c pluggable database PDB (SHOPDB1) from seed pluggable database PDB (PDB$SEED) in the same container database (SHOCDB1) with oracle database configuration assistant… Read More
12c NON-CONTAINER DATABASE TO 19c PLUGGABLE DATABASE CLONE→UPGRADE→CONVERT In this article, we are converting a 12c non-container oracle database to 19c container database using cloning a REMOTE NONCDB. With this there is an oracle version change from 12c to 19c, so we will upgrade the… Read More
WHAT YOU NEED TO ACHIEVE A JOB? 👉Getting a job as a fresher or experienced seems extremely daunting post-COVID crisis. There is cutthroat competition in the job market, and freshers are always disadvantaged due to this. 👉Nevertheless, landing a job is far from impossible if… Read More
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
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 |
#!/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 |
Script execution : Syntax : ./running_process.sh <PROCESS_NAME> <WARNING> <CRITICAL> Here I… Read More
PostgreSQL Interview Q&A Part-3 Before going into the article, please check our previous article on PostgreSQL Q&A Part-2 1. Can we have different data directories for PostgreSQL Cluster? Under One PostgreSQL installation, you can create multiple Clusters. Each Cluster will have its own data directory. One… Read More
PostgreSQL Interview Q&A Part-2 Before going into the article, please check our previous article on PostgreSQL Q&A Part-1 1. What are template0 & template1 databases? As the name suggests, these are template databases that come by default with the Installation. In a fresh installation, both… Read More
WAL Internals in PostgreSQL Write-Ahead Log (WAL) is a very important term in transaction processing. In PostgreSQL, it is also known as a transaction log. A log is a record of all the events or changes and WAL data is just a description of changes… Read More
Ask Doubts & Learn! (Oracle Snapshot Standby Database) In the below article, you can find all questions and answers regarding our upcoming session Oracle Snapshot Standby Database on (🕘28th Nov 2021 09:00 PM IST / 07:30 AM PST). Note: New Q&A will be updated… Read More
Replication to GCP PostgreSQL Using Oracle GoldenGate Use Case: Real-time replication of transactional data from an on-premises database to GCP Managed PostgreSQL instance using GoldenGate. Architecture: Source Database (Source Database can be any GoldenGate supported databases) Oracle GoldenGate (OGG) 19c/18c/12c for extraction from Source DB… Read More
