PostgreSQL DBA part2 :-How to connect postgresql database
A.Connecting postgresql locally using port Please identify port in postgresql.conf under /opt/edb/as9.6/data and connect using psql There are pre-requisites for allowing…
7 years ago
DOCKER CONCEPT FOR DBA– PART 10 : How to secure docker private repository using openssl certificate key
This document explains how to secure private repository using openssl key Before we can use a private repository, we will…
7 years ago
Monitor real time active session statistics by ORAPUB tool
The tool was devised by Craig from ORAPUB which is excellent to monitor what happens in session real time. 1.First…
7 years ago
DOCKER CONCEPT FOR DBA– PART 9 : How to use docker tar command in docker to re-instantiate new docker
1.Creating docker tar file from docker image.We can transfer that tar file and import to another docker instance. root@deb-VirtualBox:~# docker…
7 years ago
DOCKER CONCEPT FOR DBA – PART 8 How to build docker image from docker file
1.You need to create docker file first.Below is example of small test docker file. root@deb-VirtualBox:~# cat test_docker.file FROM centos:latest RUN…
7 years ago
PostgreSQL DBA part1 :-Installation of PostgreSQL 9.6 in Linux
I will show how you can install PostgreSQL 9.6 in Linux 7.This document is based on guidance provided by EDB…
7 years ago
Oracle DBaaS 1z0-160 part 33 :-Patching in Oracle cloud RAC database
Step 1:-Please check available patch and run precheck Step 2:-Pre-check results failed with below message Step 3:-Update RDK using below…
7 years ago
Oracle Virtual Box VM:-How to create network setting and interface in Oracle Virtual Box to connect internet as well as connect from host
This note will describe the process to connect Oracle Virtual box VM directly from your host using ssh as well…
7 years ago
Oracle DBaaS 1z0-160 part 32 :-On-premise database migration to oracle cloud using data pump conventional Export/Import
On-premise database migration to oracle cloud using data pump conventional Export/Import This is simplest migration if you prefer to migrate…
7 years ago
Cache buffer chain CBC latch simple query to investigate
For deep understanding on CBC,please refer to below links:- //www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB. I am just going to…
7 years ago