Your Doorstep to the Temple of Oracle

Oracle EBS

10g: Beware Killing session with Immediate Option

Posted by appsdba11i on April 29, 2011

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

Thanx Suresh For sharing …

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s