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
CONVERT ORACLE 12c SINGLE NODE RAC DATABASE TO ORACLE 12c 2-NODE RAC DATABASE In the PHASE 1 we have seen how to convert the 12c single standalone database to RAC database. check below link for PHASE 1 article. https://www.ktexperts.com/convert-oracle-12c-standalone-database-to-oracle-12c-rac-database/ And now In PHASE 2… Read More
CONVERT ORACLE 12c STANDALONE DATABASE TO ORACLE 12c RAC DATABASE In this article we have Oracle 12c Single Standalone Database running on SERVER [SHOMAC1] and will be converted it into 2 Node 12c RAC Database running on SERVER [19cRACNODE1/2]. In our test environment, Oracle 12c… 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
Dear Readers, In this article, we will see the Upgradation Of The Oracle Database From 12c To 19c. Manual Command-Line Upgrade (DB UPGRADE) In this article, I have followed the steps to directly upgrade the non-container database from 12c to 19c because a direct upgrade… 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
Data Fragmentation in PostgreSQL PostgreSQL is a relational database management system with a client-server architecture. At the server-side, PostgreSQL’s processes and shared memory work together and build an instance, which handles the access to the data. Client programs connect to the instance and request read… 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
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
CONFIGURING Object Storage & Archive Storage In this article we will learn about “CONFIGURING Object Storage & Archive Storage” Object Storage provides unlimited, high-performance, durable, and secure data storage. Data is uploaded as objects that are stored in buckets. It can store an unlimited amount… Read More
