About hiteshgondalia

Database Technology evangelist

OCM 12c Preparation

Oracle OCM 12c Certification Study project.

Oracle Database 12c Certified Master Exam | 12cOCM

Exam Environment
  • Oracle Linux Release 6.5 64 bit
  • Mozilla Browser, Text (emacs, gedit) and vi editors
  • Shell environment: bash, csh
  • Use either CLI or GUI environment and tools when available
  • Oracle Database 12c Enterprise Edition Release  64 bit
  • Oracle Grid Infrastructure 12Release 1 (
  • Oracle Enterprise Manager Cloud Control 12c Rel 4
Notes about t he exam
  • Exam participants work through eight skillsets that are based on the exam objectives.
  • Tasks can be performed using CLI or GUI environment and tools when available

Minimum Skill-set wise Passing Scores:

Skillset1: Create Database and Network Configurations : 60.29%

Skillset2: Managing Database Availability : 46.93%

Skillset3: Data Warehouse Management : 34.14%

Skillset4: Data Management : 33.92%

Skillset5: Performance Management : 39.13%

Skillset6: Data Guard : 43.39%

Skillset7: Grid Infrastructure : 53.84%

Skillset8: Real Application Cluster Database : 37.83%


General Database and Network Administration

Manage Database Availability

Data Management

Data Warehouse Management

Performance Management

Data Guard

  • Administer a Data Guard environment
  • Create a physical standby database
  • Configure a standby database for testing
  • Configure a standby database to apply redo
  • Configure a standby database to use for reporting
  • Configure fast start failover
  • Manage DDL in a Data Guard environment

Grid Infrastructure

  • Install Oracle Grid Infrastructure
  • Create ASM Disk Groups
  • Create and manage ASM instances
  • Configure ASM Cloud File System (ACFS)
  • Administer Oracle Clusterware
  • Manage Flex Clusters and Flex ASM

Real Application Cluster Database

  • Install Oracle Database software
  • Create a Real Application Clusters (RAC) database
  • Configure Database Services
  • Administer Oracle RAC databases on one or more cluster nodes

OTNYathra2017 @Mumbai


I have provided enough information about the OTN Yathra, In my previous artical “about-otnyatha”

In this artical I have decided to sharing my experiences about the sessions which i have been attended.

I have choose the Mumbai location because it is near to Ahmedabad.

I had attended below sessions at OTN Yathra 2017 @Mumbai organized by AIOUG / OUAG

1.)  “High Performance Database in Oracle Bare Metal Cloud Services” by Vivek Sharma

This session was mainly focus on Oracle Bare Metal Cloud Services offering and options by Oracle.

2.)   “Oracle and Docker – Everything you want to know to run your workload in docker container” by Umesh Tanna

I was really impress by Umesh, the way he is explaining the docker and oracle offering was quite good.

3.)  Oracle GoldenGate – IRCTC by Veeratteshwaran

This session has change my perception about the replication technology.

4.)  Building Private Cloud with Open Infrastructure by Nitin Gupta

This is the best session that actually I’m interested to know what is offering and differce option of oracle in Open Infrastructure.

5.)  12 things DBA’s will love about 12.2 by Connor McDonald

I’m feeling lucky that i choose this session because Connor is great presentation skills and sharing his experience with different examples

These all sessions were really helpful and it’s help me lots to to fill with new angle of thinking amount the upcoming technologies

I’m really greatfull to all the volunteers of AIOUG and specific to Mumbai Local Chepter volunteers who had nicely organized this event.

I’m also thankful to all the sponsors.

If you have any quesions or queries please comment here, I’m happy to share my own views and experiences about these new technologies.

Happy Learning …

About OTNYathra

OTNYathra is one day event which is organized by AIOUG / Oracle Community ACE / ACE Directors / OUG Evangelists on every year.

This is series of six conferences across six major cities (Chennai,Bangalore,Hyderabad,Pune,Mumbai,Gurgaon)

Mostly there are three parallel classroom sessions are going on so you can decide and seat in your interested session.

This is not a commercial event, They are collecting Rs. 500 as registration fee to cover the Lunch/Tee/Coffee/Snacks and other logistics to host the event.

I’m regularly attend this event since 2014.

As per my opinion this is the best technical one day event that i recommended to attend to all the DBA and Developers.

AIOUG also started local chapter in all above region.

I hope that AIOUG Gujarat Chapter will start officially very soon.

You can check latest information on my OTN Blog

Website: http://otnyathra.in

You can check session information using this link(http://otnyathra.in/{name of city}/)

Link to register in event

Disabling Transparent HugePages in RHEL7.x

[root@lab-12cr2 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux Server release 7.0 (Maipo)

Runtime Disable THP
Append below lines in /etc/rc.local
if test -f /sys/kernel/mm/transparent_hugepage/enabled; then
echo never > /sys/kernel/mm/transparent_hugepage/enabled
if test -f /sys/kernel/mm/transparent_hugepage/defrag; then
echo never > /sys/kernel/mm/transparent_hugepage/defrag
Make sure that rc.local is running on reboot
chmod +x /etc/rc.d/rc.local
systemctl enable rc-local
systemctl status rc-local

Check the behavior on post reboot the operating system

[root@lab-12cr2 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
[root@lab-12cr2 ~]#
[root@lab-12cr2 ~]# cat /sys/kernel/mm/transparent_hugepage/defrag
always madvise [never]
[root@lab-12cr2 ~]#
[root@lab-12cr2 ~]# grep -i HugePages_Total /proc/meminfo
HugePages_Total: 0
[root@lab-12cr2 ~]# cat /proc/sys/vm/nr_hugepages
[root@lab-12cr2 ~]# grep -i AnonHugePages /proc/meminfo
AnonHugePages: 2048 kB

Permanent Disable THP
Oracle Linux 7 is similar, but uses GRUB2 so you need to edit the “/boot/grub2/grub.cfg” file using the grubby command.
[root@lab-12cr2 ~]# grubby –default-kernel
[root@lab-12cr2 ~]# grubby –args=”transparent_hugepage=never” –update-kernel /boot/vmlinuz-3.10.0-123.el7.x86_64
[root@lab-12cr2 ~]# grubby –info /boot/vmlinuz-3.10.0-123.el7.x86_64
args=”ro rd.lvm.lv=rhel/root crashkernel=auto rd.lvm.lv=rhel/swap vconsole.font=latarcyrheb-sun16 vconsole.keymap=us rhgb quiet LANG=en_US.UTF-8 transparent_hugepage=never”
title=Red Hat Enterprise Linux Server, with Linux 3.10.0-123.el7.x86_64
[root@lab-12cr2 ~]#

[root@lab-12cr2 ~]# grep -i “transparent_hugepage=never” /boot/grub2/grub.cfg
linux16 /vmlinuz-3.10.0-123.el7.x86_64 root=UUID=8190d97a-a2e9-44cd-9810-804def1d6f89 ro rd.lvm.lv=rhel/root crashkernel=auto rd.lvm.lv=rhel/swap vconsole.font=latarcyrheb-sun16 vconsole.keymap=us rhgb quiet LANG=en_US.UTF-8 transparent_hugepage=never
[root@lab-12cr2 ~]# grep -i AnonHugePages /proc/meminfo
AnonHugePages: 0 kB
[root@lab-12cr2 ~]#
[root@lab-12cr2 ~]# grep -i HugePages_Total /proc/meminfo
HugePages_Total: 0
[root@lab-12cr2 ~]# cat /proc/sys/vm/nr_hugepages

Oracle MetaLink ALERT: Disable Transparent HugePages on SLES11, RHEL6, RHEL7, OL6, OL7 and UEK2 Kernels (Doc ID 1557478.1)



Behavior Changes of RHEL 7.x Operating System

RHEL 7.x had taken lots of changes by default …

1.) Default file system changes: XFS
In RHEL7 /CentOS 7 and Oracle Linux have adopted XFS as their default file system.
Apart of these there are other numerous changes that you could find from faq forum like http://simplylinuxfaq.blogspot.in/p/major-difference-between-rhel-7-and-6.html

Some of them i found to be mandatory change before use it for Database Server in Production.
2.) Default HugePages is On On
Oracle recommends that you disable Transparent HugePages before you start installation.

3.) Default Setting RemoveIPC=yes
Setting RemoveIPC=yes on Redhat 7.2 Crashes ASM and Database Instances as Well as Any Application That Uses a Shared Memory Segment (SHM) or Semaphores (SEM)

Recommended to follow below steps
1. Set RemoveIPC=no in /etc/systemd/logind.conf
2. Reboot the server or restart systemd-logind as follows:
# systemctl daemon-reload
# systemctl restart systemd-logind

RHEL7: rc.local service not starting

Found this on some Red Hat blog:

“Systemd is a system and service manager for Linux operating systems. It is designed to be backwards compatible with SysV init scripts, and provides a number of features such as parallel startup of system services at boot time, on-demand activation of daemons, support for system state snapshots, or dependency-based service control logic. In Red Hat Enterprise Linux 7, systemd replaces Upstart as the default init system.”

chmod +x /etc/rc.d/rc.local
systemctl enable rc-local
systemctl status rc-local