Step By Step Streaming Replication In PostgreSQL 12 In this demonstration,We’ll see how to setup a Streaming Replication in PostgreSQL 12 running on Oracle Linux 6.8 Here, I assume that you have two servers (Primary/Master & Standby/Slave) having PostgreSQL 12 installed. And Database cluster is initialized using initdb on both the servers. If not, you might want to see Installation of PostgreSQL here. Note that you don’t have to start the database server, just follow till initdb from this article. […]

Creating Database on Oracle Database 18cR1 using DBCA Gui & then Silent. Sounds tricky?, yes it is bit tricky. To create Database in Oracle Database 18cR1, we’ll need to use both dbca utility GUI as well as Silent. However it would not take a long time here. We’ll going to do it very quickly. If you haven’t installed 18c yet you may follow this guide for step by step installation. Let’s Start. 1. Check if your .bash_profile is pointing to

Creating Database on Oracle Database 18cR1 using DBCA Gui and then SilentRead More »

Installation of Oracle Database 18cR1 & Oracle Grid Infrastructure 18cR1 on Oracle Linux 6.7(Not an Exadata). I’ve already covered a topic on 18c in my previous post which is on Upgrading Grid Infrastructure from 12cR2 to 18cR1. And the complete step-by-step guide on how you can download¬†Oracle Grid Infrastructure 18c on your On-Premises system, though it is only available for Exadata machines. So from the same post you can get insight on how to download Oracle Database 18c on Non-Exadata

Installation of Oracle Database 18cR1 & Oracle Grid Infrastructure 18cR1 on Oracle Linux 6.7 (without GUI)Read More »

Upgrading Oracle Grid Infrastructure 12cR2 to Oracle Grid Infrastructure 18cR1 – With Little Hack (Including how you can get it). Though 18c is not yet officially available for On-Premises except for Exadata, we will going to do it with little hack, and let’s see if it works. 1. Download Oracle Grid Infrastructure 18c setup from Oracle e-Delivery. Visit Oracle Software Delivery Cloud and click on Sign In. Enter your credentials and Sign In or Create an Account if you don’t have

Upgrading Oracle Grid Infrastructure 12cR2 to Oracle Grid Infrastructure 18cR1 – With Little Hack (Including how you can get it).Read More »

Setting Up VNC Server On Oracle Enterprise Linux 6.7 VNC stands for Virtual Network Computing, which allows us to access GUI of our server remotely. Though we DBA does our every task by connecting to our server via SSH-TTY tunnel. However in some cases we need to have GUI access of the server to perform certain tasks, which needs a Display. We’ll just need to have VNC Client Application to access it. So in this post we’ll see how to

Setting Up VNC Server On Oracle Enterprise Linux 6.7Read More »

Installing Oracle Enterprise Linux 6.7 on Physical Standalone Server (Customized Storage Design). Being an Oracle DBA, we all must have had to install Linux in our machines to work with the Database. However most of the time we do install it in a Virtual Machine which would have been a completely different approach when coming to install it on Physical Server. And especially when it is for dedicated Database server. Here we’ll see how to install OEL on physical standalone

Installing Oracle Enterprise Linux 6.7 on Physical Standalone Server (Customized Storage)Read More »

Installation of Oracle Database 12cR2 and Oracle Grid Infrastructure 12cR2 on Oracle Enterprise Linux 6.7 (Physical Server – Not a VM). Every DBA Trainee or a Jr DBA must need to perform installation of Oracle Database on their home / test machines for practicing their DBA activities. However installation of Oracle Database is not a rocket science and pretty easy. You will find many blogs across the internet for step by step installation guide in which the demonstration will be

Oracle Database 12cR2 with ASM on Oracle Linux 6.7Read More »