Posted by: baskardba | May 28, 2010

ORA-07445: exception encountered: core dump [kudmnli()+319] [SIGSEGV] [Address not mapped to object] [0x000000038] [] []

When i executed the below query in 10.2.0.4  i got the error as

SQL> select down_time
from (select text_line, lag(text_line) over(order by 1) down_time from log)
where text_line like ‘%Shutting down instance (immediate)%’  2    3
4  /
select down_time
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

And in the alert log it showed

Thu May 27 15:20:13 2010
Errors in file /orahome.11/oracle/product/STEELP/10203/admin/STEELP/udump/steelp1_ora_18859.trc:
ORA-07445: exception encountered: core dump [kudmnli()+319] [SIGSEGV] [Address not mapped to object] [0x000000038] [] []

After raising an SR with oracle and got a solution as to set the correct ORA_NLS10 setting for 10.2.0.4

First it was

[osteelp@jswbdbp16 bdump]$ echo $ORA_NLS10
/orahome.11/oracle/product/STEELP/10203/nls/data/9idata

and after changing the ORA_NLS10 to below setting

[osteelp@jswbdbp16 bdump]$ export ORA_NLS10=$ORACLE_HOME/nls/data
[osteelp@jswbdbp16 bdump]$ echo $ORA_NLS10
/orahome.11/oracle/product/STEELP/10203/nls/data

the script got executed..

SQL> select down_time
from (select text_line, lag(text_line) over(order by 1) down_time from log)
where text_line like ‘%Shutting down instance (immediate)%’  2    3  ;

DOWN_TIME
——————————————————————————–
Fri Apr 23 07:48:56 2010
Mon May  3 06:41:11 2010
Mon May  3 13:44:45 2010
Tue May  4 06:51:55 2010
Mon May 17 06:36:49 2010

happy learning,

baskar.l

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Categories

%d bloggers like this: