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
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 #!/bin/bash # Syntax to run this script # ./running_process.sh oracle 100 170… Read More
PostgreSQL Articles Dear Readers, Please check the below list of PostgreSQL Articles SNo Description Link 1 Installation of PostgreSQL 11.4 On Windows Platform https://www.ktexperts.com/installation-of-postgresql-11-4-on-windows-platform/ 2 How to Download and Install the pgAdmin 4 https://www.ktexperts.com/how-to-download-and-install-the-pgadmin-4/ 3 Installation of PostgreSQL 11.4 in Linux Platform. https://www.ktexperts.com/installation-of-postgresql-11-4-in-linux-platform/ 4 Install… 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
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
Tablespace Administration in Postgres – Q&A 1. What is tablespace in Postgres? A. It specifies in which location contents of the tables should be stored. We can’t use a database without tablespace Default tablespace is pg_default Users while creating objects can specify on which tablespace… 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
PostgreSQL Interview Q&A Part -1 PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance. The frequently asked questions from PostgreSQL database are given below. 1.Difference between Alert log in Oracle and Error log in PostgreSQL? Error log to PostgreSQL is… Read More
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… 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
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
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
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. [oracle@nposqa1 ~]$ cat /home/oracle/DBA/bin/crontab_compare.bash #!/bin/bash # set -x # Get the current crontab entries… Read More
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 crsctl query css votedisk ## STATE File Universal Id File Name Disk group — —– —————– ——— ——— 1.… Read More
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… Read More
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
