6.03.2012

Advt: Oracle Enterprise Manager 12c Cloud Control: Managing Data Center Chaos

My friend and former ACE Director Porus Homi Havewala's new book on 
Enterprise Manager 12c Cloud Control, will be available in September 2012 
or earlier, perhaps the First EM 12c Cloud Control book in the world.
 
If you are interested in learning about the capabilities of Enterprise Manager 12c,
please have a look. The book can be pre-ordered in advance. Electronic copies 
will be available too on publication.
 
Oracle Enterprise Manager 12c Cloud Control: Managing Data Center Chaos
 
 
Happy reading

5.13.2012

Ad: Interesting webinars lined up at RedGate - dont miss it

Hi everyone,

In case if you haven't come across, here is a very quick update about some of the very interesting webinars lined-up at RedGate by world top most known Oracle gurus, such as (in no particular order), Jonathan Lewis,  Carry Milsap, Tom Kyte, Doug Burns, Ron Crisco and Randolf Geist.

The topics are listed hereunder:

24 May 2012     Agile Schema Design    by Ron Crisco, Method R Corporation
07 June 2012     Oracle Heap Tables or SQL Server Clustered Indexes? A Live Debate
                                                              by Jonathan Lewis (Oracle ACE Director, OakTable Member) and
                                                                  Grant Fritchey (Microsoft SQL Server MVP)
21 June 2012     Tom Kyte - subject TBC
03 July 2012      How I Learned to Love Pictures - OEM Performance Page Fundamentals 
                                                              by Doug Burns, Oracle ACE Director, OakTable Member
19 July 2012     Falling in Love All Over Again - OEM 12c Performance Page Enhancements  
                                                              by Doug Burns, Oracle ACE Director, OakTable Member
02 Aug 2012    Oracle Cost-Based Optimizer Advanced Session              
                                                              by Randolf Geist, Oracle ACE Director, OakTable Member

To register the webinars in the context and to view the past webinars, visit here.

Happy reading,

Jaffar

4.13.2012

Yet another Oracle SIG born - IOUG Virtualization SIG

Good news for those who are interested in Oracle and Virtualization technologies. Yet another Oracle SIG commenced to help the community.

Excerpt from IOUG Virtualization SIG page:


IOUG Virtualization SIG

Virtualization is the foundation stone in the Cloud Computing space and an integral part of the IT ecosystem. The IOUG Virtualization SIG is dedicated to communication and information around all areas of virtualization.

The IOUG Virtualization SIG was started at Oracle OpenWorld 2011.  The main purpose of the SIG is to discuss and share the key challenges, options, and best practices for virtualizing Oracle.  Topics will be discussed freely in this open forum and will touch on server virtualization, desktop virtualization, storage management, Oracle VM, VMware and EMC.  The SIG is led by the following thought leaders in the virtualization community. 

Virt_SIGVirt_SIGVirt-SIGVirt_SIGVirt_SIG
President and Website ChairTariq Farooq, BrainSurface and Oracle ACE DirectorVice PresidentGeorge Trujillo, VMware, Double Oracle ACEVendor Liaison ChairMichael Corey, NtiretyContent and Resource ChairDr. Bert Scalzo, Texas Publishing and Oracle ACEWeb Events ChairKai Yu, Dell and Oracle ACE Director 
Virt_SIGVirt_SIGVirt_SIGVirt_SIG 
Board LiaisonMaria Anderson, Encana

Member at LargeMichael Ault, Texas Memory Systems
Member at LargeCharles Kim, Viscosity Technology and Oracle ACE Director
Member at LargeSyed Jaffar Hussain, Alinma Bank and Oracle ACE Director


For registration, events and more details, click the following link:

3.24.2012

Upcoming Webinar - Migrate single instance database to RAC

Interested knowing about all existing methods to migrate your existing single instance database to RAC? Attend my upcoming webinar 'Migrate single instance database to RAC - 360 degrees' on 29/3/2012.
The webinar is sponsored and hosted by RedGate .

Register here

Abstract:

On Oracle Database administrators have to deal with numerous challenges whilst migrating an existing non-cluster environment to a cluster environment. Beyond any doubts, one of the most significant challenges a DBA faces is migrating an existing single instance database to RAC.
Although Oracle provides several easy methods to carry out the procedure,  it is important to every DBA to identify which method best fits to his/her needs and requirements.
The core objective of this presentation is to give you an overview about different methods for migrating an existing single instance database to RAC, and help you discover the most suitable one for your need. The session will also explain how to perform the migration procedure to minimize the downtime in order to improve (speed up) the duration whilst dealing with VLDB.
A live Q+A with Syed Jaffar Hussain will follow the presentation.
Syed Jaffar Hussain
Oracle ACE Director, Oracle Magazine Editor's choice award (2011) for 'Technologist of the year, DBA' Database Support Team Lead in Inma Bank, Oracle Certified Master (10g),Oracle RAC Certified Expert and OCP v8i, v9i, v10g and v11g. 17 years of Information Technology experience, including 9 years as an Oracle DBA. Expert on All Things Oracle.

3.12.2012

Oracle 11gR2 addNode.sh fail with SEVERE:Cannot perform add node proceduure

Since December 2011, we have been struggling with an issue whilst adding two new nodes to our existing Oracle 11gR2 cluster that is running over HPUX platform. Just for the records, this environment had been recently upgraded from 10gR2 to 11gR2 and successfully applied the PSU (11.2.0.2.4) in the recent past to over come from a significant number of Oracle bugs that we confronted.

We simple followed a very straight forward addNode.sh procedure to add two new nodes which unfortunately failed with the following error:

SEVERE:Cannot perform add node procedure as the value of CLUSTER_NEW_VIRTUAL_HOSTNAMES or CLUSTER_NEW_NODES or both could not be obtained from the command line or response file(s). Silent install cannot continue.

We gave up eventually after having several unsuccessfully attempts to fix the issue and finally opened a TAR with Oracle support to seek their assistance over the issue. Unfortunately, all workarounds suggested by the Oracle Support team doesn't yield any fruitful results, therefore, they have requested their development team to register a new bug for the issue. A new BUG 13555953 has been registered for the problem and still the development team is working over the issue. The problem with the development team is that they are unable to reproduce or simulate the bug at their premises.

However, last week we thought of giving a try adding a node at a time, rather than going with two nodes together. Bingo, the approach worked big time and we were able to add the node with small scale of hiccups.
The problem we got was resolved by applying the solution mentioned in the MOS [ID 1085893.1].

Though we have managed to add two nodes individually, the problem whilst attempting to add two nodes together is still persists. The Oracle development team is still working over the issue and they are yet give us the the root cause and a fix for the issue. We are having a migration project in the pipe line where we would be migrating our existing servers from HPUX SD1 to SD2. If the only workaround is to add a node at a given time, then, it gonna consume a significant time for us to complete the migration project.

I am very optimistic about getting a fix for the bug from Oracle and I shall keep posted the development on my blog.

Happy reading,

Jaffar