Jaffar's Oracle blog

An easy way to obtain 10053 trace

2012-01-21T03:41:00.000-08:00

I have just learnt a couple of new methods to obtain an Optimizer (10053) trace for any sql statement that is already in the cache, without actually executing it and also enabling 'events infrastructure'. With 11gR2 onwards, you can either use the DBMS_SQLDIAG.DUMP_TRACE package procedure or use new diagnostic events infrastructure to obtain the 10053 trace for a given sql_id. Demonstration 1:

Advt: Sangam11 - All India Oracle User's Group annual conference

2011-11-05T02:24:00.000-07:00

Sangam11, AIOUG's annual conference kicks off on 9th December 2011 for two days, a very good opportunity not to miss if you around in India! Third time in a row AIOUG is conducting the annual conference SANGAM with several world's best known Oracle speakers. Last year, it was Jonathan Lewis and this year it is going to be world renowned Expert Arup Nanda who will be the Key presenter and

Topic for RAC cookbook

2011-11-03T14:19:00.000-07:00

Hi everyone, Perhaps, I could be the first person(please excuse me if I am wrong in my perspective) who would ask the readers about what contents/topic they would like to foresee in a RAC cookbook. Well, I am planning to co-author a new RAC book, tentatively titled 'Oracle 11gR2 cookbook' and I would like you (my readers) to help me and yourself putting forward your inputs/views about the

Wishing everyone a very happy and prosperous Eid Al-Adha

2011-11-02T11:07:00.000-07:00

First and foremost, a very happy and prosperous Eid al-Adha to everyone around the world in advance. Our eid holidays starts off from tomorrow till 11 September 2011, 9 days in total. Believe me, I was desperately looking forward for this break as I really got too busy with 8 node cluster upgrade and DR setup righter after I came back from my OOW conference and trip. I am not gonna enjoy the

Back home safely from OOW

2011-10-19T13:58:00.000-07:00

Hi everyone, I am back home safely after attending my ever first Oracle Open World and followed by a 7 day California trip to Las Vegas, Las Angeles, Universal Studio, Disneyland and other great places. It was an honor and my privilege to meet other fellow Oracle ACE Directors and very famous Oracle gurus at OOW. I really had a good time at OOW and my family did enjoy the California trip.

Advt.: Win one of FIVE Packt Oracle Book subscriptions worth $120

2011-09-22T14:13:00.000-07:00

Hi everyone, here is your chance to win one of FIVE Packt Oracle Book subscriptions worth of $120 by answering a very simple question. Packt Publishing develops Oracle books and eBooks that cover a massive range of Oracle technologies including the Oracle Database, Oracle Middleware, Oracle Applications, Oracle Servers and more. Now, all these books can be accessed from Packt's very own cloud

Technologist of the year, DBA (2011) accolade

2011-09-08T13:57:00.000-07:00

Hello everyone, I totally agree that I was a bit off-colored at my blog of late which is largely due to various factors, like, I was busy attending training, writing exams (mostly ITIL) and kept myself super cool during the entire holy month of Ramadan.Now, I am back on track, expect a lot of buzz and noise from me. Well, I have got a piece of good news to share with you all on my blog. I am

Join the IOUG Virtualization Group on LinkedIn and attend an Expert Webinar Series on Oracle-centric Virtualization!

2011-07-26T01:42:00.000-07:00

Join some of the world's most respected & renowned experts as they talk about Oracle-Centric Virtualization in a series of 3 experts webinars at IOUG: the premier provider of expert independent content related to Oracle: http://linkd.in/mQbAzm Webinar 1 - Jul 27, 2011 - 1pm - 2pm EDT (UTC-4) Everything to know about Virtualization for Oracle DBAs To find out more & Enroll4Free

Advt. Packt Publishing celebrates 50th Oracle book publication - offers a great discount

2011-07-18T23:15:00.000-07:00

Since 2006 Packt has published a number of Oracle best-sellers such as Getting Started With Oracle SOA Suite 11g R1 – A Hands-On Tutorial, Oracle Coherence 3.5, Oracle Fusion Middleware Patterns and many more. To celebrate the publication of its 50th Oracle book, Packt is offering a series of attractive discounts on all Oracle books. Buy any Oracle print book and get 20% off Buy any Oracle

My sessions schedule for VirtaThon 2011

2011-07-15T12:55:00.000-07:00

As part of upcoming VirtaThon 2011 virtual conference for Oracle, MySql & Java domains, I will be presenting 3 individual sessions and two as a co-panel list. The following is the confirmed schedule for my sessions: Convert your single-instance databse to RAC database - tools, tips and techniques Presenter(s): Syed Jaffar Hussain Time slot: 17 July 11:00 - 11:55 Room: Virtual Room # 100

The Countdown begins - Attend4FREE: 6 Days of Expert+ Speakers & Sessions FOR Oracle, MySql and Java technologies

2011-07-14T08:56:00.000-07:00

Attend4FREE: 6 Days of Expert+ Speakers & Sessions! Jul 16 - 21, 2011 100% LIVE & Virtual - No Travel Required! Seats are LIMITED: Register4FREE NOW! With keynotes from Steven Feuerstein, Arup Nanda, Dr. Bert Scalzo, Eddie Awad, Lewis Cunningham, Tim Gorman, Jeremy Schneider, David Koelle, Guy Harrison, Tariq Farooq and a 4-hour Gold Star Deep-Dive session from Mike Ault, this a

Training and Upcoming Oracle Virtual conference

2011-07-11T11:47:00.000-07:00

Just a quick update about myself if you found why I am bit off colored these days at twitter and blog. Well, I am currently attending a 4 day ITIL training and two more days left for the training. Thereafter, I will be busy with the upcoming VirtaThon 2011 (July 16-21) web conference for Oracle, MySql and Java Domains. For entire VirtaThon conference schedule, visit here. Catch you at the

RMAN best practices for RAC presentation

2011-07-09T04:40:00.000-07:00

As part of BrainSurface's VirtaThon Road tour, I made a 30 minutes presentation (webinar) 'RMAN best practices for RAC' for Massachusetts Institute of Technology (MIT). Since the manageability of RMAN backup, restore and recovery operations are nearly identical in non-clustered and clustered databases, the objective of the presentation was to summarize the options using which an RMAN can be best

RMAN Snapshot Controlfile for RAC database in 11gR2

2011-07-03T09:53:00.000-07:00

Just thought of quickly updating the change made in RMAN Snapshot Controlfile behavior for RAC database with Oracle 11gR2 and later. Well, if you are wondering why post 11gR2 upgrade the RMAN Snapshot Controlfile backup for your RAC database is failing with 'ORA-00245: control file backup operation failed', here is the reason plus a workaround to tackle the issue. According to MOS [ID

1-Day Expert Conference for Oracle professionals

2011-06-30T00:36:00.000-07:00

1-Day Expert Oracle-Centric Conference at Massachusetts Institute of Technology (MIT) - VirtaThon Road Tour @BrainSurface Thursday, 07 July 2011, 09:00am - 05:00pm 1-Day Expert Conference for Oracle professionalsMassachusetts Institute of Technology (MIT) - Stratton Student Center (W20)VirtaThon Road Tour @BrainSurface BrainSurface The Collaborative ConnectSpace for Oracle, Java & MySQL

Book Review by Aman Sharma

2011-06-29T10:22:00.000-07:00

A very positive and elaborated review by Aman Sharma for our Oracle 11g R1/R2 Real Application Clusters Essentials book. Book Review. A big thank you to Aman for his wonderful and very honest review. Enjoy reading, Jaffar

ASM instance in INTERMEDIATE state + CHECK TIMED OUT state_details

2011-06-28T04:17:00.000-07:00

Yet another clash with ASM 11gR2 BUG during a new database creation under a 6 node development RAC environment. Got a requirement to create a new database, thereby, created a new ASM diskgroup manually and began creating the database with DBCA tool. However, ran over the following error when the newly created ASM diskgroup was selected to host the data files of the database: After getting the

11gR2 upgrade aftermath - impdp failed with ORA-29913+ ORA-31011+ ORA-19202 + LPX-00217

2011-06-25T10:20:00.000-07:00

It has been almost close to 3 months since we had a successful Oracle 10gR2 (10.2.0.4) clusterware upgrade with nearly 100 database to Oracle 11gR2 (11.2.0.2) at our site. However, our association with an unforeseen bugs and adjusting our application code (a very minimal) to confront the significant changes in the behavior with11gR2 functionality is yet to come to a happy ending . I wanna share

Jonathan Lewis's video presentation about tuning a two-table join

2011-06-23T05:39:00.000-07:00

Its indeed quite amazing to know how one could talk about tuning a simple two-table join query for about an hour or more. For sure, it might not be possible other than Jonathan Lewis. Here is a video presentation URL that was done very recently by JL for Turkish Oracle Users' Group conference. http://jonathanlewis.wordpress.com/2011/06/23/video/ Hats off to master Jonathan Lewis! Enjoy

Less than a day now to vote your favorite OOW2011 sessions

2011-06-19T08:56:00.000-07:00

Ya, I knew it gonna be a very lazy Sunday for most of us and dislike to have any buzz plus doesn't want to spend a single moment on the computer. However, please make an exception just for today to break the habit and spend a few moments of your time to cast your valuable votes to ensure the sessions that you liked the most are top the table and eventually picked for Oracle Open World.The time

1 more day left to VOTE your favorite Oracle OpenWorld 2011 suggest-a-session

2011-06-12T03:54:00.000-07:00

Just only 1 day left to vote your favorite OOW2011 suggest-a-session @ Oracle Mix. Vote now! Oracle 11gR2 Cluster upgrade success story- A complete life cycleManaging & Troubleshooting Clusterware - Best Practices Oracle RAC Interview Q/A Interactive Competition If you are a BrainSurface fan, do not forget to cast your vote to the following proposed sessions: Database Performance Tuning:

I am Oracle ACE Director NOW

2011-06-07T05:11:00.000-07:00

Hello everyone, Very quickly, I just would like to share yet another happiest moment of my life with everyone out there. I am now honored with Oracle ACE Director and glad to join the elite panel of Oracle ACE Directors. I am indeed thankful to all my friends, fellow Oracle experts, in particular, who have nominated me for this award. With this honor, I felt like my contribution and

Oracle Open World 2011 Registration opens now - get 500$ off

2011-06-06T04:29:00.000-07:00

Registration for the upcoming Oracle Open World 2011 events is open now. Register now for OOW 2011 event to get absolutely 500$ off for the event. http://www.oracle.com/openworld/register/additional-packages/index.html Looking forward to meet you all in San Francisco.

Time runing away - VOTE NOW your favorite sessions for OpenWorld 2011

2011-06-03T13:08:00.000-07:00

The time is running away for Oracle OpenWorld 2011 suggest-a-session as the voting is through June 19 only. Vote your favorite sessions before the voting lines get closed. On the same flow, please do vote for my sessions, listed below: Single instance database conversion to RAC - tips and techniques Oracle 11gR2 Cluster upgrade success story- A complete life cycle Managing & Troubleshooting

Series: Oracle Exadata Command Reference by Arup Nanda

2011-06-02T14:12:00.000-07:00

A very famous and world known Oracle expert Mr. Arup Nanda has written a four series article about Oracle Exadata technologies. The four-part series contains the following: Part 1: Jumpstarting on Exadata – a quick primer on Exadata, its components and inner workings. If you are new to Exadata, this installment is definitely for you. Part 2: Command Categories, Configuration, and Basic Commands

My sessions @ VirtaThon virtual web conference for MySql, Java and Oracle Technologies

2011-06-01T15:00:00.000-07:00

I am fortunate enough to have all my proposed Oracle sessions for the upcoming VirtaThon virtual web conference for Oracle, Java and MySql technologies have been accepted. Though I have seven accepted sessions, it is unlikely that I would present all of them. Therefore, I request you to select the best sessions by rating and picking them from the following list: To know more about the event,

Yet another Oracle 11g upgrade aftermath - ORA-07445: exception encountered: core dump [evaopn3()]

2011-05-30T03:47:00.000-07:00

Apparently, the Oracle 11gR2 aftermath stories is like never ending story from my part. Yet another aftermath fairy tale for you. It was brought to our notice a couple of days ago that one of the application query failed to execute of late (perhaps after 11gR2 upgrade) and the following error has been logged in the application log file: