An Initiative-AIOUG North India Chapter….

At times, just a little idea and support can do just wonders for a very large community. And that’s the same happened this year when I was talking to Murali Vallath about the user-groups and participation of Oracle professionals in India in Oracle related events organized in India by All India Oracle Users Group(AIOUG) (formed and managed by Murali only). As India is such a large country, it’s not possible for everyone to come from they are residing or working for attending some Oracle conferences happening at a city very far from them. So Murali mentioned that how he started organizing a local user event at Charlotte with just very few people showing up for it initially. But with constant efforts, finally he was able to make the event a success and continued arranging it on Charlotte on monthly basis. And on the same thought, he suggested to start of a chapter representing North India and initiating an Oracle related event for it on monthly basis. That was just a superb idea and needless to say, I immediately started to work upon it and I called my friend Navneet to talk about the same.

Me and Navneet had few initial talks about the event, number of talks etc. Since he is based out of Chandigarh and it’s being the twin-capital for two states, Punjab and Haryana and even being very near by from Delhi, we decided to host the 1st ever meet-up at there. We decided for two talks, both given by us thinking that this should get the ball rolling. Navneet found a venue and also spread the news in his circle about the event. We decided to host the meet-up on monthly basis, on every last Saturday of the month from 10am onwards. The day is picked thinking that it’s going to be a weekend so it would be easy for most to attend the meet-up. So finally, we were all set for the event and eventually, the day of the event also did come up. Fortunately, we had a very good number of the attendees, even when it was just the 1st ever meet-up of it’s own kind at Chandigarh. We planned for about 3 hours for the talks but we ended up doing it for about 5 hours, thanks to the enthusiasm of the attendees. And not only this but we got really very positive feedback from the attendees and they were very excited already for  the next month’s meet-up-which would be now this month, April! Great isn’t it!

This month’s meet-up is scheduled for 26th April. For making sure that we have one stop-location for the latest updates, we have made(without any surprise), a Facebook page AIOUG-North-India-Chapter and you are most welcome to like it :=) .  We are also on Twitter. We shall be using these social sites for announcing updates related to the event and also about anything that’s worth sharing with the Oracle community.

Before I sum up this post, my heartiest thanks to Murali for giving his complete support and guidance for this initiative. Not only for this, he also helped so much to include Jallandhar this year as one of the venues for OTNYathra and even better, let that Yathra(journey) started from Jallandhar itself. Also, a big thanks to Navneet, Deepak, Gaurav for helping so much for the meet-up. Without their support, the meet-up wouldn’t had got such a great start.

ORA.GSD Offline In 11.2 RAC….

Not a new thing right now since 11.2 is out from some time already.A very common question that I get is that GSD (Group Service Daemon) is offline in 11.2 RAC. That’s not something to be worried about as it’s officially documented in MOS doc# 429966.1. Only if you have 9i database, it would be available but the point is why in 2014, you are still planning to run a 9i database on a 11.2 cluster ;>) ?

Packt’s 2000th Title Campaign….

I received an email from Packt Publication that they are celebrating the release of their 2000th publication. And to include everyone in this celebration, Packt Publication would be giving an awesome offer to the readers to buy one (any from their catalogue) and get along with it one book, FREE!!!! Now, how cool is that, isn’t it? So if you are willing to buy a book from Packt Publication, no time can be better than this – from 18th March to 26th March 2014. So I shall say that go ahead and use this opportunity to buy the book co-authored by Francisco Alvarez and me, 12c Backup and Recovery Survival Guide and you would get one book along with this purchase free!

You can have a look at the entire campaign from this link,

http://www.packtpub.com/?utm_source=referral&utm_medium=marketingPR&utm_campaign=2000thTitle

 

Happy shopping and heartiest congratulations to Packt for achieving this big mark of 2000 titles and I hope the number goes to 200,000 soon :=) .

EM Express 12c Failing With Error: QERVW*

It’s been a while that I am using Oracle database’s latest release 12c. It’s a very different release from the past versions and IMO, if you are going to delay in learning it thinking that you would do when your company/client/<put-whatever-reason-here> would make you to do so, it would be too late. There are a LOT of new features (~500) with the biggest change in the architecture which came due to the concept of Multitenant databases. So there is a lot that you are required to catch up and delaying it would just make things more and more tough.

This post is not about the new features of Oracle database 12c. I have written few posts already which you would find under the tag 12c. In this post I shall talk about the new Enterprise Manager of database 12c which is now called EM Express. This is a very different enterprise manager from the past versions of 10g, 11g as it is completely based on an awesome technology Application Express. Since APEX runs inside the database, this means that the new EM Express is fast and takes less amount of resources. You may not find it that much feature rich as it’s predecessor was but if you are not willing to use the full blown 12c Cloud Control, this is the free version that you can use now.

There is just a small issue, though!

The database version 12.1.0.1’s EM express crashes with this sort of error messages recorded in the alert log file.

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5] [PC:0xB71F161, qervwRowProcedure()+113] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_s000_2751.trc  (incident=12067):
ORA-07445: exception encountered: core dump [qervwRowProcedure()+113] [SIGSEGV] [ADDR:0x5] [PC:0xB71F161] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl/incident/incdir_12067/orcl_s000_2751_i12067.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sun Mar 23 21:06:27 2014
Dumping diagnostic data in directory=[cdmp_20140323210627], requested by (instance=1, osid=2751 (S000)), summary=[incident=12067].
Sun Mar 23 21:06:56 2014

Well, that doesn’t sound good! Let’s check the mentioned incident file and it’s contents.

Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing opt
ions
ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1
System name:    Linux
Node name:      arista.localdomain
Release:        3.8.13-16.2.1.el6uek.x86_64
Version:        #1 SMP Thu Nov 7 17:01:44 PST 2013
Machine:        x86_64
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 7
Unix process pid: 2751, image: oracle@arista.localdomain (S000)

*** 2014-03-23 21:06:23.277
*** SESSION ID:(19.35) 2014-03-23 21:06:23.277
*** CLIENT ID:() 2014-03-23 21:06:23.277
*** SERVICE NAME:(SYS$USERS) 2014-03-23 21:06:23.277
*** MODULE NAME:() 2014-03-23 21:06:23.277
*** ACTION NAME:() 2014-03-23 21:06:23.277
*** CONTAINER ID:(1) 2014-03-23 21:06:23.277

Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x5] [PC:0xB71F161
, qervwRowProcedure()+113] [flags: 0x0, count: 1]
Incident 12067 created, dump file: /u01/app/oracle/diag/rdbms/orcl/orcl/incident
/incdir_12067/orcl_s000_2751_i12067.trc
ORA-07445: exception encountered: core dump [qervwRowProcedure()+113] [SIGSEGV]
[ADDR:0x5] [PC:0xB71F161] [Address not mapped to object] []

ssexhd: crashing the process…
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory ‘/u01/app/oracle/product/12.1.0/dbhome_
1/dbs’

And in the meanwhile, EM Express already reported that “may be” that database is down so the EM is not functional( I didn’t capture the screenshot of it, sorry).

A quick search on https://support.oracle.com got me MOS#1604062.1(Troubleshooting EM Express) . Going through it I came to know about Bug 16527374 : [12100-LIN64-130318]CDB:ORA-07445:EM EXPRESS HOME GOT IO ERROR(unpublished) and to resolve it, the recommendation was to use the patch#16527374. Cool, let’s try it but before that, let’s check our database with OPatch.

[oracle@arista OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/o
patch2014-03-23_21-21-42PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/12.1.0/dbhome_1/cfgto
ollogs/opatch/lsinv/lsinventory2014-03-23_21-21-42PM.txt

——————————————————————————–
Installed Top-level Products (1):

Oracle Database 12c                                                  12.1.0.1.0
There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

——————————————————————————–

OPatch succeeded.

That was expected. So after unzipping the patch file, I got started using the following command,

[oracle@arista 16527374]$ opatch apply -connectString orcl:sys:oracle

opatch error
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following executables are active :
/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle

 

Let’s find the process using this executable using the FUSER command and kill it,

[oracle@arista 16527374]$ fuser
/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle
/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle:  3620e
[oracle@arista 16527374]$ kill -9 3620
[oracle@arista 16527374]$ fuser
/u01/app/oracle/product/12.1.0/dbhome_1/bin/oracle
[oracle@arista 16527374]$

 

Let’s start again,

[oracle@arista 16527374]$ opatch apply -connectString orcl:sys:oracle
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16527374_Mar_23_2014_21_39_06/apply2014-03-23
_21-39-06PM_1.log

Applying interim patch ’16527374′ to OH
‘/u01/app/oracle/product/12.1.0/dbhome_1′
Verifying environment and performing prerequisite checks…
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local
system.
(Oracle Home = ‘/u01/app/oracle/product/12.1.0/dbhome_1′)

Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files…

Patching component oracle.rdbms, 12.1.0.1.0…

Verifying the update…
Patch 16527374 successfully applied
Log file location:
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/16527374_Mar_23_2014_21_39_06/apply2014-03-23
_21-39-06PM_1.log

OPatch succeeded.

 

Let’s check the status of the applied patches in our database again,

 

[oracle@arista 16527374]$ opatch lsinventory
Oracle Interim Patch Installer version 12.1.0.1.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/12.1.0/dbhome_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/12.1.0/dbhome_1/oraInst.loc
OPatch version    : 12.1.0.1.0
OUI version       : 12.1.0.1.0
Log file location :
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/opatch2014-03-23_21-41-00PM_1.log

Lsinventory Output file location :
/u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-03-23_21-41-00PM.txt

——————————————————————————–
Installed Top-level Products (1):

Oracle Database 12c
12.1.0.1.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch  16527374     : applied on Sun Mar 23 21:40:19 IST 2014
Unique Patch ID:  16551736
   Created on 12 Jul 2013, 13:23:36 hrs PST8PDT
   Bugs fixed:
     16527374

——————————————————————————–

OPatch succeeded.

 

After going for a reboot of the whole machine followed by the startup of the database and EM express, so far, EM has not crashed and I shall hope it would remain the same way.

Better Late Than Never, Happy 2014….

So I am probably very late in saying this but better later than never, right? And since it is still January of 2014, I believe it is okay to wish everyone a very happy 2014 still :=) .

A very happy and prosperous 2014 to you, the reader! May god makes this year a really good one for you and fill it with just joys, happiness, success and good health for you and for all of yours nears and dears. I hope the year has started of well for you. If for some reason, you think it didn’t, don’t worry, it’s just the starting of the year and I am sure, as the time would move on, things are going to get better!

Oh and before you are going to ask why I got so late, I am doing many things(writing this post sitting at Yangon(Myanmar) when the delegates are doing their hands-on lab) and despite that I wanted to write about many things, I just either forgot or thought to do so later. Hopefully, I shall be more active over my blog this year-at least that’s what is the plan!

I Am Speaking @ Sangam 2013, Will You Be Joining Me?

So it’s that time of the year again when the “meeting of the minds” is going to happen and this time, the location is at Hyderabad. Yes, this year, AIOUG is arranging it’s annual conference Sangam there and as like all the previous years, this year also, we are going to have the privilege to listen and learn from some of the biggest names in the Oracle database community-Arup Nanda , Gaja Krishna Vaidyanatha, Syed Jaffar Hussain, Murali Vallath and many many more. So I would say, it’s not a conference you would want to miss. And guess what, I am speaking there as well :-) . So if you want to know what’s new in RMAN in Oracle database version 12c, join me!

For the complete list of the speakers and the session’s information, visit the official website of Sangam 2013 at http://www.sangam13.info . If you are coming, make sure you do come and say hello :-) . See you there!

Oracle Backup & Recovery-Expert Secrets For Using RMAN & Data Pump, Avaialble Now….

Writing a book is a long, tiring and tough journey. The journey gets complete once you see that your work-the writing that you have spent so much and time effort upon, is now complete and is available for anyone. Three years ago, I was asked by my dear friend Kamran Agayev that whether I am interested to join him in writing a book. Though I was very reluctant but then finally, I decided to give it a go. We both spent more than a year writing our book. Fortunately, we also got two really good technical reviewers Sabdar Syed and Hemant K. Chitale. With their suggestions, comments and correction, Kamran and I,both tried to put in our best efforts and write a book which would prove to be useful to fellow Oracle database professionals.

I was asked by many people that when the book would be available. I am very very happy to announce today that finally, our book is out and is available on Amazon. Following is the link of it,

http://www.amazon.com/Oracle-Backup-Recovery-secrets-In-Focus/dp/0984428232/

So go ahead and make it a part of book shelf and if you would, do let us know your thoughts about it.

PS:Kamran has already talked about it here.