My Journey in ODevC Yatra - 2018, Part 1, Chennai & Bengaluru

My Journey in ODevC Yatra - 2018, Part 1, Chennai and Bengaluru

ODevC Yatra (formally known as OTN Yathra) is one of the biggest event of AIOUG. Oracle ACE /ACE Directors/Oracle Gurus/ Oracle User Group Evangelists in the region are organizing this event.
This Yatra/Tour is a series of seven events across seven major cities in a time period of 9 days.

It was the first time, I was part of the ODevC Yatra - 2018  in five major cities i.e. Chennai, Bengaluru, Ahmedabad, Pune and Mumbai.

I have delivered session on “Query Optimization, who influence and how it works” in Chennai & Bengaluru. I have covered all internal things about optimizer and explain how it works and who influences optimizer chooses good plan or bad plan. Also explain capabilities of optimizer and new optimizer techniques which helps to improve query performances.

It was a privilege to share the stage with the Oracle Experts/Gurus; Sandesh Rao, Gurmeet Goindi, Basheer Khan, Raj Rathee, Sai Penumuru, Bjoern Rost, Chetan Vithlani, Kamran Aghayev,  Hariharaputran, Pradeep Vattem, Veera Sridhar in Chennai and Bengaluru, addressing the audience about the Oracle ACE program and importance of the User group.

Here are my memories with speakers and audience in Chennai and Bengaluru

...Chennai Memories...

Sandesh Rao, Gurmeet Goindi, Basheer Khan, Raj Rathee, Sai Penumuru, Bjoern Rost, Chetan Vithlani, Kamran Aghayev,  Hariharaputran, Pradeep Vattem, Veera Sridhar

It was my privilege to share stage with Oracle Gurus

Live Demo on Autonomous Database

Live Demo on Cloud

Presenting my session on "Query Optimizer"

Thank you Chennai for attending my session

Little relax time in Chennai Event

Closing Event Group Photo

We all were ready to go our next destination Bengaluru

...Bengaluru Memories...

Presenting my session on "Query Optimizer"

Thank you Bengaluru for attending my session

First time in ODevC Yatra, AIOUG has organized Kidtronics for participant's children

Children and Speakers; closing event moments

Selfie time and Group Photo

Thanks & Regards,

Chandan Tanwani

Oracle Performance Tuning Certified Expert

Oracle Database Installation 18c, On-Premise

Oracle Database Installation 18c, On-Premise

Finally wait is over. Oracle has launched Oracle Database 18c, On-Premise.

Oracle has simplified database Installation task. It is now easy to install binaries in few steps and ready to create database.

The beauty of this release; It's simple, Unzip the download, Re-link binaries and Ready to Go...

You have three options to install database; Starting with Oracle Database 18c release.
1) Image-based Oracle Database Installation
2) RPM-Based Oracle Database Installation
3) Read-Only Oracle Home

According to me, these are very much simplest method to install database till now,
Let's understand how these different options help us,

1) Image-based Oracle Database Installation (new in Oracle 18c, on-premise)
Image-based Installation enables you to download zip file and extract the image software into your Oracle Home directory and run Installer script to start database installation.
Unzip the download and Re-link binaries...that's it.

2) RPM-Based Oracle Database Installation
Here, using RPM-based Database Installation (RDI), use rpm -ivh command to install database installation, which performs pre-validations, extract packages assigns ownership, oracle inventory, users and groups, and executes all other scripts and root operations to complete database software installation.

3) Read-Only Oracle Home (new in Oracle 18c, on-premise)
In this option, you are privileged to make your Oracle Home in read-only mode. Database tools and processes writes under ORACLE_BASE path rather ORACLE_HOME directory.
This helps to do version control and patching oracle home. Oracle has include built-in tool, called "rhpctl", that enables you to switch from the current Oracle Database home to a patched Oracle Database home.

Check out Database Installation steps here,
I am using Image-based Oracle Database Installation

Download Oracle Dabase 18c from this link.
https://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Unzip the installer.
$ unzip -d LINUX.X64_180000_db_home.zip /u01/DB18c

Till this point your database binaries are installed. Now you can use dbca to configure database.
Below screenshots helps you to create and configure single instance database.

Here, we are done. Our database is installed and ready to use.

Thanks & Regards,

Chandan Tanwani

Oracle Performance Tuning Certified Expert