Oracle DBaaS 1z0-160 part 1:-Oracle DBaaS cloud services overview

Oracle DBaaS cloud services overview A.Oracle DBaaS cloud services level A.1 The Oracle Database Cloud Service – Virtual Image —You have to install this software yourself, and you are responsible for all maintenance operations for this software. You have root privilege, so you can load and run software in the compute environment. You have full administrative privileges for the Oracle […]

KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud

KBHS-00712: ORA-29024 received from local HTTP service during backup in RAC Oracle cloud The backup of Oracle RAC DBaaS may fail during manual as well automatic backup. If you manually invoke following command,The backup may not get successful. Login to opc. [opc@pocracdemo1 ~]$ raccli describe job 17 {   “requestStatus” : “SUCCESS”,   “jobStatus” : “FAILURE”,   “message” : “Failed […]

DOCKER CONCEPT FOR DBA -PART 3 device mapper for Dcoker

DOCKER Use the Device Mapper storage driver Device Mapper is a kernel-based framework that underpins many advanced volume management technologies on Linux. Docker’s devicemapper storage driver leverages the thin provisioning and snapshot capabilities of this framework for image and container management. This article refers to the Device Mapper storage driver as devicemapper, and the kernel framework as Device Mapper. For the systems where it […]

docker concept for DBA-part-2 Run docker for non-privileged user (Other than root)

You need to change group to docker for user (non-privileged user) otherwise you get following error:- [user@debasiseric1 ~]$ docker images Got permission denied while trying to connect to the Docker daemon socket at unix:///var/run/docker.sock: Get http://%2Fvar%2Frun%2Fdocker.sock/v1.37/images/json: dial unix /var/run/docker.sock: connect: permission denied Now I will login to root sudo su – cd /var/run [root@debasiseric1 run]# ls -al docker.sock srw-rw—- 1 […]

Docker concept -part 1-Concept and Installation of docker in CentOS

A. Basic Concept of docker   Docker is a platform for developers and sysadmins to develop, deploy, and run applications with containers. The use of Linux containers to deploy applications is called containerization. Containers are not new, but their use for easily deploying applications is. Containerization is increasingly popular because containers are: Flexible: Even the most complex applications can be containerized. Lightweight: Containers […]

STEP BY STEP PROCEDURE OF GI UPGRADE FROM 11.2.0.3 TO 11.2.0.4 USING CLI OR SILENT MODE

Step by step procedure of GI upgrade from 11.2.0.3 to 11.2.0.4 using CLI or SILENT mODE   In this section we will guide you how to upgrade the GI using cli. Step 1: Before upgrade the ‘HAS’ shows version 11.2.0.3 for release and software version. $ crsctl query has releaseversion Oracle High Availability Services release version on the local node […]

Performance monitoring or tuning tool for SQL query taking long time using various tools like explain plan,sql monitor,awrsqrpt,sqlhc

Performance monitoring or tuning tool for SQL query taking long time using various tools   In that post,I will explain using various method or tool to investigate performance problem of particular sql query. Let me create a test case first   create table test_c(id number,name char(100),address char(100),create_date date); create table test_p(id number,name char(100)); declare v_m number; begin for i in […]

AWR setup and configuration

1.General Information Memory versions of statistics regularly transferred to disk by MMON. AWR stores base statistics:-counters and value statistics. ASH data is firstly captured first to memory in 1 second interval for active sessions only.ASH data is reduced by 10 times sample in memory data.ASH data is used by ADDM. The advisor report produced by  ADDM reports are used by […]