Lorem Ipsum has been the industry's standard dummy
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 local connection.This pg_hba.conf file is under /opt/edb/as9.6/data.Please make sure last parameter should be md5 not peer. The below content is for example what should be in pg_hba.conf # “local” is for Unix domain socket connections only local all all md5 # […]
This document explains how to secure private repository using openssl key Before we can use a private repository, we will need to secure it and offer user authentication. Let’s create a self-signed certificate, use the ‘registry’ container by Docker to create basic user authentication, and then copy the files where they need to go on the hosting server. root@deb-VirtualBox:~# mkdir […]
The tool was devised by Craig from ORAPUB which is excellent to monitor what happens in session real time. 1.First I need to down OSM tool kit from ORAPUB. First we need to run the following scripts to create some pre-requisite tables under sys/system schema. a)osmprep.sql — ****************************************************** — * Copyright Notice : (c)1998-2014,2015 OraPub, Inc. — * Filename : […]
1.Creating docker tar file from docker image.We can transfer that tar file and import to another docker instance. root@deb-VirtualBox:~# docker image save mywebserver:v1>mywebserver.tar root@deb-VirtualBox:~# ls -ltr mywebserver.tar -rw-r–r– 1 root root 330399232 May 2 19:53 mywebserver.tar 2.Remove the existing docker image root@deb-VirtualBox:~# docker rmi -f mywebserver:v1 Untagged: mywebserver:v1 3.Please note the image is deleted root@deb-VirtualBox:~# docker images 4.Now we can […]
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 image . -t option is used […]
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 and 7.x CentOS 6.x and 7.x […]
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 Database home using the apply patch subcommand with […]
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 I will go to File->Preferences and […]
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 Step 2:-Create a directory object in […]
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 your file_id and block_id to locate […]