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!!