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 yum update -y Here please note that FROM clause denotes first we need to pull centos image and RUN clause will run yum update on top of it. 2.Now I will build the docker imageContinue reading DOCKER CONCEPT FOR DBA – PART 8 How to build docker image from docker file

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 (Enterprise distributor of PostgreSQL) Step 1:-First we need to check Supported platform as below The Advanced Server 9.6 RPM packages are supported on the following platforms: 64 bit Linux: Red Hat Enterprise Linux 6.x andContinue reading PostgreSQL DBA part1 :-Installation of PostgreSQL 9.6 in Linux

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 command to update cloud tool [opc@pocracdemo1 ~]$ raccli update rdk -tag latest {  “jobId” : “41”,  “requestStatus” : “SUCCESS” } Step 4:-Please apply patch now From command line Apply a patch to the Oracle DatabaseContinue reading Oracle DBaaS 1z0-160 part 33 :-Patching in Oracle cloud RAC database

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 as from VM to internet connection. I will use 2 types of VM interface. a)NAT network for internet connection from VM b)Host only adapter for ssh connection from host to the VM. Step 1:-First IContinue reading Oracle Virtual Box VM:-How to create network setting and interface in Oracle Virtual Box to connect internet as well as connect from host

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 one schema to oracle cloud. Source:-On-premise database(Hostname:-gnssrv01 ) Target:-Oracle cloud database (Hostname:-myclone) Step 1:-On the on-premises database host, create an operating system directory to use for the on-premises database export files. $ mkdir /u01/app/oracle/admin/orcl/dpdump/for_cloud StepContinue reading Oracle DBaaS 1z0-160 part 32 :-On-premise database migration to oracle cloud using data pump conventional Export/Import

Cache buffer chain CBC latch simple query to investigate

For deep understanding on CBC,please refer to below links:- http://www.proligence.com/pres/ioug14/2014_431_Nanda_ppr.pdf and Video tutorial from ORAPUB. I am just going to mention some useful queries to investigate or identify CBC latch Step 1:-You as user fire a sql query from client. select * from cbctest; Step 2:-Now oracle will search metadata and determine what is yourContinue reading Cache buffer chain CBC latch simple query to investigate

SSH connection from on-premise Linux or Unix host to Oracle cloud

Problem 1.First I copied the private key generated by puttygen (The public key was provided during DB creation in oracle cloud).After that I tried to connect cloud database using below command:- cd /home/oracle chown oracle:oinstall course_priv.ppk chmod 0600 course_priv.ppk [oracle@gnssrv01 ~]$ ssh -i course_priv.ppk opc@144.21.83.108 Enter passphrase for key ‘course_priv.ppk’: Enter passphrase for key ‘course_priv.ppk’: EnterContinue reading SSH connection from on-premise Linux or Unix host to Oracle cloud

TDE encryption setup for migrating on-premise backup to Oracle cloud using RMAN

This note describe how we can configure TDE encryption for RMAN backup in on-premise database to migrate to Oracle cloud. 1.First I need to update sqlnet.ora with proper location where my wallet will reside to enable TDE encryption. # sqlnet.ora Network Configuration File: /u01/app/oracle/product/12.2.0/dbhome_1/network/admin/sqlnet.ora # Generated by Oracle configuration tools. NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) ENCRYPTION_WALLET_LOCATION=Continue reading TDE encryption setup for migrating on-premise backup to Oracle cloud using RMAN

Backup on-premise database and restore to Oracle cloud database

My on-premise database hostname:-gnssrv01 Database name:-orcl12c Cloud database hostname:-myclone A.Backup of on-premise database to cloud container Please create the empty container for holding backup of on-premise database using following link https://clouddba.co/oracle-dbaas-1z0-160-part-24-backup-in-single-instance-oracle-cloud/ 1.First I need to install backup module for cloud in on-premise database You need to download opc.cert and opc_install.jar mentioned in above metalink noteContinue reading Backup on-premise database and restore to Oracle cloud database

Oracle DBaaS 1z0-160 part 31 :- Oracle cloud database security

Data security In Oracle Database Cloud Service databases, data security is provided for data in transit and data at  rest. Security of data in transit is achieved through network encryption. Data at rest security is achieved through encryption of data stored in database data files and backups.Data in Oracle Database files, including backups, is securedContinue reading Oracle DBaaS 1z0-160 part 31 :- Oracle cloud database security