PostgreSQL DBA part 3 :-How to start/stop postgresql database
A.Stopping postgresql database pg_ctl can be used to stop a database cluster •pg_ctl supports three modes of shutdown −smart quit […]
PostgreSQL
PostgreSQL
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
Docker
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
General Performance tuning
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
Docker
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
Docker
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
PostgreSQL
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
Oracle DBAAS 1z0-160
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
Linux, Technology
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
Oracle DBAAS 1z0-160
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