10g: Beware Killing session with Immediate Option

Hi Everyone!!

We had recently one of the weird problem in our PROD RAC system. One of our DB RAC instance crashed. After reviewing we found the alert log error .

ORA-07445: exception encountered: core dump [kghlkremf()+56] [SIGSEGV] [Address not mapped to object]
[0x4501000000000000] [] []

After pursuing SR with Oracle found that its a bug with 10.2.0.3 where the possibility of instance might crash while using an alter system kill session with IMMEDIATE argument.

Avoiding Crash:

It was suggested in the SR not to use argument "IMMEDIATE" on 10.2.0.3 environment while killing sessions. Looks Oracle has given fix patch in 10.2.0.4!!

So beware killing oracle session using "alter system kill session '123,10202' immediate;" in 10.2.0.3 environments. (Say big no to immediate!!)

Happy Sharing!!

2 comments:

Nabeel said...

Hie Suresh,
How are you. its very impressive i am new to Oracle Apps DBA.
I wanted to add you on my gmail can i please so i can get tips from you if possible please let me know

Thanks
Nabeel

Suresh Lakshmanan said...

Sure Nabeel.