Free OCI Learnings/Certifications From Oracle along with Enroll steps for Certification Here is an exciting opportunity from Oracle to get certified at zero cost. Oracle has announced it will offer Oracle Cloud Infrastructure (OCI) training and OCI certification testing for free worldwide. The new program includes Oracle’s entire range of expert-created OCI learning curriculum for
Step by Step Migrate Database from Non-ASM to ASM in Oracle This article is a continuation of a recent article where we have demonstrated Offline Restore or Clone Database on the same server or rename database in Oracle click here to go through it. In this article, we will perform a Step by Step Migrate
Remove Old Unused Kernels in Unix In this article, we are going to demonstrate How to Remove Old Unused Kernels in Unix. The kernel is part of an operating system that stores in a small partition of OS called /boot. Whenever we update/upgrade a system, it will install all required updates along with the kernel
KVM failed to start after ODA upgrade from 18.8 to 19.6 Recent we had patched our ODA X7-2M (Baremetal) machine from 18.8 to 19.6 click here to read more about same both OS and Server patch was successful, But after ODA Server patched when tired to start KVM machine encounter below errors: error: Failed to
Setup Logical replication using pglogical in PostgreSQL In the recent two blogs, we discuss built-in options like Streaming replication Click here to read more and Logical replication Click here to read more. In this blog, we will use pglogical extension to setup logical streaming replication for PostgreSQL. The pglogical extension provides logical streaming replication for PostgreSQL, using
Basics Of User Management in Oracle When a user logs on to the database, they connect to a user account by specifying an account name followed by an authentication method. Every user account must have a default tablespace. This is the tablespace where any schema objects created by the user will be stored. Permanent objects(
Configure PgBouncer for PostgreSQL PostgreSQL has a heavyweight connection handling architecture. For each incoming connection, the postmaster forks out a new process called as backend process to handle it. While this design provides better stability and isolation, it does not make it particularly efficient at handling short-lived connections. A new Postgres client connection involves TCP
Backups from the Standby Server using pgBackRest in PostgreSQL  In the previous blog, we have configured Streaming Replication Cluster using pgBackRest Click here to read more. We will use the same PostgreSQL cluster to show How we can take a backup from Standby Cluster using pgBackRest. Below are the high-level steps which we will
Setup Streaming Replication with pgBackRest PostgreSQL In the recent two blogs, we discuss How to set up Streaming Replication Click here to read more and Configure pgbackrest on Database Server – Local Click here to read more. In this blog, we will demonstrate How to Setup Streaming Replication with pgBackRest in PostgreSQL. Below are the high-level steps we
