Looking for something? Try here..

Wednesday, April 27, 2016

It's the first time I'm attending the OTNYatra organised by All India Oracle User Group at Bangalore. I'm making my mind to attend the show as to get to know what happens in these sort of activities/programs conducted. I'm also planning to present papers on Oracle technology in the near future but for that I need to know what happens in there. So I booked myself/registered in the early bird offer.
As the day 24th April is nearing, I had some health issues that I was not feeling well and couldn't go to work from 2 days before the event and this bothered me a lot. I made myself prepared that in any case I shouldn't miss this event, the reason being it happens in a place where I currently reside (I don't have to travel long), I'm curious on what is happening in these events and important is to network with fellow Oracle enthusiasts/lovers.
I made it to the venue on the day, the 24th April just as the event starts.. (I'm 5 minutes late ;)). Registered myself and got a seat in the big auditorium so that I can see what's happening.

Experiences
There were a bunch of Oracle ACEs and Oracle technology geeks ready to give their presentations and once the initial formalities completed, the presentations began.
I have attended wonderful and excellent sessions of Riyaj Shamsudeen where he presented internals

Riyaj getting ready

of Cache fusion and performance tuning, neat and quick with the excellent demo which I loved. He is playing with data and servers as it seemed the servers loved him. They(the data) just obey him as he is "the master". Well everyone likes the data to obey those who dictates it. ;) Mind, he is doing live demo...
Next comes the session from Nilesh Agarwal, Consultant Technical Lead at Oracle in Enterprise Manager on how to make use of EM12c/EM13c for performance management which is of useful with crisp points.
We also had an electrifying and energetic presentation from Hariharaputhran Vaithinathan which is on SQL tuning proven methodologies.

Electrifying Hariharaputhran

Well the session is post lunch and guess what? Nobody slept in his session with the room fully packed. Hats off to the presentation style..
Another session from Nassyam Basha on GDS. This was one of the useful session again as it tells me we have something called GDS, what it's use, how to configure and how easily one can manage the services globally.

Nassyam with GDS

There were other sessions taking place in parallel on other rooms with Connor Mcdonald (the current AskTom), Biju Thomas, Saurabh Gupta, Pravin Takpire presenting their articles to name a few.
The expert panel where all the speakers on the day answers to the questions fired by the audience and yeah, this session is very informative as some of the experts are part of Oracle beta program so we can get the news from them in advance if any..

Informative chat with Connor

All the sessions I have attended gives me lot of ideas and courage and number of points to be noted on how to stage present and how to prepare slides if one wants to.. They becomes an starting point to observe when someone is in plan of participating in the future events. The networking here is good. It is nice to see the faces I saw on Facebook or Twitter in person and have chats and it gives more pleasure when we identify each other without introducing ourselves. There comes the joy in this event. The food provided is enjoyable and the tea breaks are well timed so that participants don't feel too much into technical where they can break out to fresh up for further sessions.. We also get a OTN Yatra T- Shirt, shouldn't forget to mention ;)

Suggestions
I can say I'm satisfied with the day, yes my day was totally productive but there are a few disappointments that I had.

As this event is for networking, I find less time to actually network with people. We had total

Networking Tea Break

of 2 tea breaks of 20 minutes and a hour time of lunch. One may feel this is a good time but as a personal opinion I felt this is really a very short time. It would have better we had a session by name such as "Know Others" or "Network fellows", etc.. where people can share on stage their current status and future plans with fun activities included..

The technical sessions are scheduled of 50 minutes each. Participants are expected to present themselves in 50 minutes duration. This is too short as one can only give a very high level "know what's?" and "know how's?" and if someone interrupts in between with doubts or clarifications, it's difficult for the presenter to manage time on what he has to present. We can reduce the number of sessions and increase the time to around 90 minutes per session or the best option is to conduct a 2 or 3 day program which can serve as Oracle festival for Oracle lovers as this is a one time event per year (I know the difficulties behind the logistics required and the organising efforts and with limited number of participants to the events this option is not much feasible, but a thought of mine :))

Overall I had a very productive and enjoyable day thanks to the organisers of the event and behind the scene members for such a wonderful day. I wish I attend these sort of forum activities and events as and when possible and not only participate as an audience but as a speaker as well in future.

A person with hard working ability, will power and passion to finish what he starts.
An Oracle database administrator trying to explore every nook and corner possible in Oracle technology. A blogger, a story and poem writer at leisure. A guy who maintain at most patience even when the whole world rejects him.

I said the issue as weird because as you can see I have not used "including current controlfile" in the backup statement or I have not changed the default setting for non-CDB database RMAN configuration for controlfile autobackup.
RMAN is trying to backup the controlfile with the same name specified in the format clause.

To resolve the issue for then, I tried configuring the autobackup to ON as below.

Ha... The setting resolved the issue but I'm confused. Why does my backup command reported error in the first case? Am I missing something or should I report a bug to Oracle??

Waiting for your inputs...

Happy confusion.. :)

Update 06-Apr-2016Solution:
I had this discussed in the LinkedIn "Oracle Senior DBA Group" group and found it is my mistake that I didn't realize that the control file will always be backed up automatically when datafile 1 is backed up even with the RMAN default setting of autobackup OFF.
I would have avoided this situation with a simple solution in my command as below.
Specify %U to the format clause in the backup command so that the controlfile would have created along with the database backup.

A person with hard working ability, will power and passion to finish what he starts.
An Oracle database administrator trying to explore every nook and corner possible in Oracle technology. A blogger, a story and poem writer at leisure. A guy who maintain at most patience even when the whole world rejects him.