My Blog

October 15, 2008

ORA-07445 with ORA-03113: end-of-file on communication channel

Filed under: Oracle — by enotebook @ 5:21 pm

I was encountering an error when executing a SQL query on a development server, which is ORA-03113: end-of-file on communication channel. After the investigation i found it’s caused by an Oracle bug – bug No. 4517291. Here is the process to solve this problem.

$ tail -n 10 alert_orcl.log
Completed: alter tablespace test add datafile
‘/u01/oradata/orcl/test02.dbf’ size 20M
Wed Oct 15 04:39:49 2008
Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_25786.trc:
ORA-07445: exception encountered: core dump
[Address not mapped to object] [0x0] [] []
Wed Oct 15 04:40:14 2008
Thread 1 advanced to log sequence 5
Current log# 1 seq# 5 mem# 0: /u01/oradata/orcl/redo01.log
Wed Oct 15 04:41:24 2008
Errors in file /u01/app/oracle/admin/orcl/udump/orcl_ora_25788.trc:
ORA-07445: exception encountered: core dump
[Address not mapped to object] [0x0] [] []
$ cd ../udump/
$ ls -alth |grep *25788*
-rw-r—– 1 oracle oinstall 2.6M Oct 15 04:41 orcl_ora_25788.trc
$ head -n 100 *25788*
/u01/app/oracle/admin/orcl/udump/orcl_ora_25788.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 –
Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10g/db
System name: Linux
Node name: LinuxOra.andy.com
Release: 2.6.9-55.ELsmp
Version: #1 SMP Fri Apr 20 17:03:35 EDT 2007
Machine: i686
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 25788, image: oracle@LinuxOra.andy.com]oracle@LinuxOra.andy.com (TNS V1-V3)
*** 2008-10-15 04:41:24.389
*** SERVICE NAME:(SYS$USERS) 2008-10-15 04:41:24.388
*** SESSION ID:(148.278) 2008-10-15 04:41:24.388
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to
object), addr: 0x0, PC: [0x95450df, evaopn2()+209]
Registers:
%eax: 0x0000065c %ebx: 0xb72cf65c %ecx: 0xb72c8b34
%edx: 0x2bbb0210 %edi: 0x09545081 %esi: 0x00000000
%esp: 0xbfffc130 %ebp: 0xbfffc2ec %eip: 0x095450df
%efl: 0x00210246
evaopn2()+198 (0x95450d4) add $8,%esp
evaopn2()+201 (0x95450d7) mov 0xffffffd8(%ebp),%ebx
evaopn2()+204 (0x95450da) jmp 0x9545072
evaopn2()+206 (0x95450dc) mov 0x28(%edx),%esi
> evaopn2()+209 (0x95450df) mov (%esi),%edi
evaopn2()+211 (0x95450e1) movzw 0x4(%esi),%esi
evaopn2()+215 (0x95450e5) mov (%edi,%ecx),%edi
evaopn2()+218 (0x95450e8) mov %esi,0xfffffff0(%ebp)
evaopn2()+221 (0x95450eb) mov %edi,0xfffffff8(%ebp)
*** 2008-10-15 04:41:24.391
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump
[Address not mapped to object] [0x0] [] []
Current SQL statement for this session:
select * from ( select user_id, displ, created, profile from t where
user_id = 5 and displ in (0,1) order by displ desc, created desc)
where rownum <= 15
—– Call Stack Trace —–
calling call entry argument values
in hex
location type point (? means dubious
value)
——————– ——– ——————– —————-
————
ksedst()+27 call ksedst1() 1 ? 1 ?
ksedmp()+557 call ksedst() 1 ? 8164444 ?
B7488F40 ?

Go to Oracle metalink and search the realated information, i found this article – Doc ID: NOTE:421013.1 Summary Of Bugs Containing ORA- 07445 , then follow the guide to identify the root problem. In the end i downloaded patch p4517291 and apply it, problem got resolved.

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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

Blog at WordPress.com.

%d bloggers like this: