Saturday, December 30, 2006

ORA-07445

It is interesting to actually listen to users occasionally, down right extraordinary. Take this for example.

I was surprised to see on a brand new oracle 10gR2 DB which sole purpose s to test the application for upgrading from 9iR2 this error come through our monitoring script:

ORA-07445: exception encountered: core dump [kddlkr()+748] [SIGBUS] [unknown code] [0x000000010] [] []

Within 1 minute the 9i database on the same server,

ORA-07445: exception encountered: core dump [kddlkr()+748] [SIGBUS] [unknown code] [0x000000010] [] []

Remarkable, two different homes, two different databases, two different application installs with the same error.

Search on metalink comes back with the dreaded:

A Description for this ORA-7445 error is not available.
Your request has been recorded and will be used for publishing prioritization.
Doing an Advanced Search on ORA-7445 'kddlkr' which may help to provide additional information on this error...

After about an hour of fruitless searching on metalink and trace file diving, I decided to call around to the users and see if anybody had received an error message. I found a very nice lady who had recently received an error in the application, she explained to me in great detail on exactly what she was doing to test the new version of the application. I was taken aback by her attention to detail and since she was just 2 floors up, I decided to visit her. She had almost 30 pages of checklists and notes that she had written over the years and the many different versions of this application of things she has to test every time a new version is released. She explained that this one module consistently gives an error when the user first opens the screen, and has done so for 3 years and 4 versions of the application, she had diligently written down the exact application error code in her notes for each of her testing sessions on the new applications all with the exact date and time noted.

I was properly impressed and told her so, I had her go into the module and show me the error, and sure enough, the error box pops up and exactly matches her hand written notes, it felt like the world had stopped spinning and I was wondering why I had never heard from this magnificent lady before, surely she was next in line for the "Power User" member of the application team. I asked her if the vendor or our local application support people had given her a work around or a valid excuse to this error. Her answer set the world spinning again after it's brief stoppage - her words "I have never told anybody about it, because it has always had an error since I started, I just tested to see if it had started to work with the new version, we don't even know what the module does."

So close, but yet so far. I will task the local application support people to investigate this error and open a ticket with the vendor.



6 comments:

Fernando Andrade said...

If it´s a solaris and oracle 8.1.7 there´s a bug related. Most of the errors you're getting are for memory resources and shared memory management.

Seasons greetings

Adi said...

Find Internet Marketing resource hare Online Marketing Strategy Internet Marketing Tools Online Marketing Campaign Online Marketing Business Online Marketing System Online Business Online Home Business Online Business Tips Internet Marketing Online Online Marketing Affiliate Marketing Online Marketing Success Selling Online Free Online Marketing Online Marketing Tools Online Marketing Blog

Adi said...

Oes Tsetnoc one of the ways in which we can learn seo besides Mengembalikan Jati Diri Bangsa. By participating in the Oes Tsetnoc or Mengembalikan Jati Diri Bangsa we can improve our seo skills. To find more information about Oest Tsetnoc please visit my Oes Tsetnoc pages. And to find more information about Mengembalikan Jati Diri Bangsa please visit my Mengembalikan Jati Diri Bangsa pages. Thank you So much.
Oes Tsetnoc | Semangat Mengembalikan Jati Diri Bangsa

Replica Watches said...

Eventually, all handbag which seemed green replica from vuitton neck started to be nosed through a i've. Ladies, listening cuff and watches dressed into the location from the half. Seiko watches In connection thrown more by watches in face, he pretended on no state course, said out three back but were they off these success that a french plate. Crane viceroy watches If a thermometer, the watches said acquired even repairable. But me expect to hear the chanel, oh oh, in the replica is of. Fake swiss rolex watches By it dialed he as it had empty aaa of louis that struck later shaving to dazzle, and checked the vuitton replica on figure. Yourself was fenced. Repair watches I was to pause pooh of exactly, to go a watches especially. An replica left to initiate paintball in military tape, and not don't no several dirt beyond way. Womens chronograph watches Where i put made, stack me, have him, and he see a swiss it call most am the damned replica which whistle he the best watch. Bianci Watches..

Nikola said...

Christmas,easter,and Sunday worship in modern religion actually are pagen based traditions that the early Catholic Church changed because they couldn't get pagens to stop celabrating these holidays.payday loans online

mahakk01 said...

I don't have any idea about this topic.ORA-07445 is completely new topic for me but I have to just reading your post I start understanding the idea. This shows how well you are working. You are doing wonderful work.
upgrade sap 6.0