Home » RDBMS Server » Server Administration » ORA-03113: end-of-file on communication channel (merged)
ORA-03113: end-of-file on communication channel (merged) [message #418421] Sat, 15 August 2009 00:09 Go to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member
Dear Friends,
Facing a problem couple of days but havn't reached to any solution.
Try all the possible way found in net. Like
http://www.idevelopment.info/data/Oracle/DBA_tips/Linux/LINUX_4.shtml
http://dbaspot.com/ora-03113-end-of-file-on-communication-channel.html
etc.
When I tried to startup the database which is in idle instance this error shows every time. I have tried with identifying pfile but the result is same.

SQL*Plus: Release 9.2.0.7.0 - Production on Sat Aug 15 11:56:34 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup
ORA-03113: end-of-file on communication channel




The last few lines of my alertlog is like below

 tail -100 alert_EBISARC.log |more
  user_dump_dest           = /oradata2/EBISARC/admin/udump
  core_dump_dest           = /oradata2/EBISARC/admin/cdump
  sort_area_size           = 524288
  db_name                  = EBISARC
  open_cursors             = 300
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 25165824
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Tue Aug  4 16:01:35 2009
ALTER DATABASE   MOUNT
Tue Aug  4 16:01:39 2009
Successful mount of redo thread 1, with mount id 2515093407
Tue Aug  4 16:01:39 2009
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE   MOUNT
Tue Aug  4 16:01:39 2009
ALTER DATABASE OPEN
Tue Aug  4 16:01:39 2009
Thread 1 opened at log sequence 7
  Current log# 1 seq# 7 mem# 0: /oradata2/EBISARC/oradata/REDO/redo01.log
Successful open of redo thread 1
Tue Aug  4 16:01:39 2009
SMON: enabling cache recovery
Tue Aug  4 16:01:40 2009
Successfully onlined Undo Tablespace 1.
Tue Aug  4 16:01:40 2009
SMON: enabling tx recovery
Tue Aug  4 16:01:40 2009
Database Characterset is WE8ISO8859P1
.........
Tue Aug 11 18:25:33 2009
Shutting down instance: further logons disabled
Shutting down instance (immediate)
License high water mark = 3
Tue Aug 11 18:25:34 2009
ALTER DATABASE CLOSE NORMAL
Tue Aug 11 18:25:35 2009
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Aug 11 18:25:35 2009
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Thread 1 closed at log sequence 7
Successful close of redo thread 1
Tue Aug 11 18:25:35 2009
Completed: ALTER DATABASE CLOSE NORMAL
Tue Aug 11 18:25:35 2009
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


I need your precious suggestion to overcome this sort of problem.
Thanks in advance.
Re: ORA-03113: end-of-file on communication channel [message #418423 is a reply to message #418421] Sat, 15 August 2009 00:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Have a look at udump directory (see user_dump_dest parameter) there should be a trace file for your session.

Regards
Michel
Re: ORA-03113: end-of-file on communication channel [message #418427 is a reply to message #418421] Sat, 15 August 2009 00:52 Go to previous messageGo to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member
Unfortunately I have no user id for metalink.
I found that this is a common problem. So what the measures the victims have taken? Clearly it is not said in each reference of the mail. Seems nothing to do Sad
Re: ORA-03113: end-of-file on communication channel [message #418428 is a reply to message #418427] Sat, 15 August 2009 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is a generic error number so it is meaningless without the associated trace file.

Regards
Michel
Re: ORA-03113: end-of-file on communication channel [message #418430 is a reply to message #418421] Sat, 15 August 2009 03:16 Go to previous messageGo to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member
The database was up till 11th aug. At 12th it shows the ora-03113 error. the OS has been rebooted in 12th Aug but still the problem persists.
In udump the latest trace file generated in 4th Aug contains the below information
Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.7.0 - Production
ORACLE_HOME = /oradata1/app/oracle/product/9.2.0
System name:    Linux
Node name:      ebis1.tmib.net.bd
Release:        2.4.21-40.ELsmp
Version:        #1 SMP Thu Feb 2 22:22:39 EST 2006
Machine:        i686
Instance name: EBISARC
Redo thread mounted by this instance: 1
Oracle process number: 8
Unix process pid: 29946, image: oracle@ebis1.tmib.net.bd (TNS V1-V3)

*** SESSION ID:(7.3) 2009-08-04 09:18:27.218
Thread checkpoint rba:0x000006.0000f446.0010 scn:0x02c4.44e3ab56
On-disk rba:0x000006.00018b37.0000 scn:0x02c4.6aa0d545
Use incremental checkpoint cache-low RBA
Thread 1 recovery from rba:0x000006.00018b2f.0000 scn:0x0000.00000000
----- Redo read statistics for thread 1 -----
Read rate (ASYNC): 4Kb in 0.20s => 0.00 Mb/sec
Longest record: 0Kb, moves: 0/9 (0%)
Change moves: 0/1 (0%), moved: 0Mb
----------------------------------------------
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 7/7 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 9/20 = 0.5
----------------------------------------------
*** 2009-08-04 09:18:27.509
KCRA: start recovery claims for 7 data blocks
*** 2009-08-04 09:18:27.533
KCRA: buffers claimed = 7/7, eliminated = 0
*** 2009-08-04 09:18:27.533
Recovery of Online Redo Log: Thread 1 Group 3 Seq 6 Reading mem 0
----- Recovery Hash Table Statistics ---------
Hash table buckets = 32768
Longest hash chain = 1
Average hash chain = 7/7 = 1.0
Max compares per lookup = 1
Avg compares per lookup = 16/16 = 1.0
----------------------------------------------



From this si any clue found?
Re: ORA-03113: end-of-file on communication channel [message #418448 is a reply to message #418421] Sat, 15 August 2009 10:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Forgive me, but what you have posted makes no sense to me.
Both alert_SID.log & *trc file are from 4 Aug; while startup failure happened today.
It is as if you have multiple instances on this system.

CUT the following lines

env
sqlplus
/ as sysdba
shutdown abort
startup
exit

PASTE into command/terminal window as OS user oracle

CUT commands & results & PASTE back here

Re: ORA-03113: end-of-file on communication channel [message #418470 is a reply to message #418421] Sat, 15 August 2009 21:14 Go to previous messageGo to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member
@BlackSwan,
Please go through the alert log as there are some entries for 11th Aug there. Particularly which parameter you wanted to see from env.
The output of your query

SQL*Plus: Release 9.2.0.7.0 - Production on Sun Aug 16 09:08:16 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup 
ORA-03113: end-of-file on communication channel

Re: ORA-03113: end-of-file on communication channel [message #418471 is a reply to message #418421] Sat, 15 August 2009 21:17 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
>Particularly which parameter you wanted to see from env.
ALL, the whole output from

env | sort

If you do not comply, then I'll stop trying to assist.
Re: ORA-03113: end-of-file on communication channel [message #418474 is a reply to message #418421] Sun, 16 August 2009 00:27 Go to previous messageGo to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member
Hi BlackSwan, for your suggestion find your query

$ env|sort
_=/bin/env
CLASSPATH=/oradata1/app/oracle/product/9.2.0/JRE:/oradata1/app/oracle/product/9.2.0/jlib:/oradata1/app/oracle/product/9.2.0/rdbms/jlib:/oradata1/app/oracle/product/9.2.0/network/jlib
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/home/oracle
INPUTRC=/etc/inputrc
LAMHELPFILE=/etc/lam/lam-helpfile
LANG=en_US.UTF-8
LD_ASSUME_KERNEL=2.4.1
LD_LIBRARY_PATH=/oradata1/app/oracle/product/9.2.0/lib:/lib:/usr/lib:/usr/local/lib
LESSOPEN=|/usr/bin/lesspipe.sh %s
LOGNAME=oracle
LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;
32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.sh=01;32:*.csh=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;
31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.cpio=01;31:*.jpg=01;35:*.gif=01;
35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:
MAIL=/var/spool/mail/oracle
NLS_LANG=AMERICAN
OLDPWD=/oradata2/EBISARC/admin/cdump
ORACLE_BASE=/oradata1/app/oracle
ORACLE_HOME=/oradata1/app/oracle/product/9.2.0
ORACLE_SID=EBISARC
ORACLE_TERM=xterm
ORA_NLS33=/oradata1/app/oracle/product/9.2.0/ocommon/nls/admin/data
PATH=/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/oradata1/app/oracle/product/9.2.0/bin
PWD=/oradata2/EBISARC/admin/udump
QTDIR=/usr/lib/qt-3.1
SHELL=/bin/bash
SHLVL=1
SSH_ASKPASS=/usr/libexec/openssh/gnome-ssh-askpass
SSH_TTY=/dev/pts/2
TERM=vt100
USER=oracle


[Updated on: Mon, 17 August 2009 00:44] by Moderator

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #418489 is a reply to message #418421] Sun, 16 August 2009 09:09 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
ls -lart /oradata2/EBISARC/admin/udump | tail -40

ls -lart /oradata2/EBISARC/admin/bdump | tail -40

issue the 2 commands above & post them & the results back here; inside <code tags> as you did most recent post
Re: ORA-03113: end-of-file on communication channel [message #418512 is a reply to message #418421] Sun, 16 August 2009 21:14 Go to previous messageGo to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member

$ ls -lart /oradata2/EBISARC/admin/udump | tail -40
total 116
drwxr-xr-x    6 oracle   oinstall     4096 Jun  4  2008 ..
-rw-r-----    1 oracle   oinstall      984 Jun  4  2008 ebisarc_ora_16052.trc
-rw-r-----    1 oracle   oinstall      943 Jul 23  2008 ebisarc_ora_30005.trc
-rw-r-----    1 oracle   oinstall    20616 Sep 30  2008 ebisarc_ora_17087.trc
-rw-r-----    1 oracle   oinstall    23388 Dec 15  2008 ebisarc_ora_30074.trc
-rw-r-----    1 oracle   oinstall     1755 Mar 26 13:39 ebisarc_ora_29568.trc
-rw-r-----    1 oracle   oinstall      661 Apr 22 16:27 ebisarc_ora_9021.trc
-rw-r-----    1 oracle   oinstall     1329 May  7 13:56 ebisarc_ora_12126.trc
-rw-r-----    1 oracle   oinstall     1329 May  7 13:56 ebisarc_ora_14345.trc
-rw-r-----    1 oracle   oinstall    27599 May  7 14:07 ebisarc_ora_14666.trc
-rw-r-----    1 oracle   oinstall      989 Aug  3 19:14 ebisarc_ora_16557.trc
-rw-r-----    1 oracle   oinstall     1756 Aug  4 09:18 ebisarc_ora_29946.trc



$ ls -lart /oradata2/EBISARC/admin/bdump | tail -40
total 8848
drwxr-xr-x    6 oracle   oinstall     4096 Jun  4  2008 ..
-rw-r-----    1 oracle   oinstall      636 Jun  4  2008 ebisarc_lgwr_16045.trc
-rw-r-----    1 oracle   oinstall      636 Jul 24  2008 ebisarc_lgwr_16127.trc
-rw-r-----    1 oracle   oinstall      664 Sep 28  2008 ebisarc_lgwr_18235.trc
-rw-r-----    1 oracle   oinstall    19508 Sep 29  2008 ebisarc_dbw0_25616.trc
-rw-r-----    1 oracle   oinstall      664 Sep 29  2008 ebisarc_lgwr_25618.trc
-rw-r-----    1 oracle   oinstall    10076 Sep 30  2008 ebisarc_dbw0_21193.trc
-rw-r-----    1 oracle   oinstall      664 Sep 30  2008 ebisarc_lgwr_21195.trc
-rw-r-----    1 oracle   oinstall    64440 Sep 30  2008 ebisarc_dbw0_16907.trc
-rw-r-----    1 oracle   oinstall      636 Oct  8  2008 ebisarc_lgwr_16909.trc
-rw-r-----    1 oracle   oinstall      636 Oct 12  2008 ebisarc_lgwr_26527.trc
-rw-r-----    1 oracle   oinstall      636 Nov 11  2008 ebisarc_lgwr_26456.trc
-rw-r-----    1 oracle   oinstall      636 Dec 28  2008 ebisarc_lgwr_28027.trc
-rw-r-----    1 oracle   oinstall      636 Jan 13  2009 ebisarc_lgwr_29019.trc
-rw-r-----    1 oracle   oinstall      636 Jan 28  2009 ebisarc_lgwr_25379.trc
-rw-r-----    1 oracle   oinstall      636 Mar 26 13:40 ebisarc_lgwr_29558.trc
-rw-r-----    1 oracle   oinstall    11054 Apr 22 16:30 ebisarc_lgwr_2134.trc
-rw-r-----    1 oracle   oinstall  3815114 Apr 25 00:42 ebisarc_smon_2138.trc
-rw-r-----    1 oracle   oinstall    25789 May  7 12:30 ebisarc_dbw0_10108.trc
-rw-r-----    1 oracle   oinstall      664 May  7 12:38 ebisarc_lgwr_10110.trc
-rw-r-----    1 oracle   oinstall    52969 May  7 14:01 ebisarc_dbw0_12117.trc
-rw-r-----    1 oracle   oinstall      636 May  7 14:07 ebisarc_lgwr_12119.trc
-rw-r-----    1 oracle   oinstall      636 May 13 19:31 ebisarc_lgwr_14682.trc
-rw-r-----    1 oracle   oinstall      636 May 16 02:20 ebisarc_lgwr_29275.trc
-rw-r-----    1 oracle   oinstall      636 Jun 19 23:00 ebisarc_lgwr_31633.trc
-rw-r-----    1 oracle   oinstall      636 Aug  4 09:26 ebisarc_lgwr_29938.trc
-rw-r-----    1 oracle   oinstall      634 Aug 11 18:25 ebisarc_lgwr_5861.trc
drwxr-xr-x    2 oracle   oinstall     4096 Aug 11 18:25 .
-rw-r--r--    1 oracle   oinstall  4939319 Aug 11 18:25 alert_EBISARC.log
Re: ORA-03113: end-of-file on communication channel [message #418513 is a reply to message #418421] Sun, 16 August 2009 21:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Here is my problem

Nothing in udump or bdump as shown above

reflect the commands issued in

[message #418470 is a reply to message #418421

issue the command below. it will take many minutes to complete

find / -name alert_EBISARC.log -ls


PASTE results from above back here with <code tags>

Re: ORA-03113: end-of-file on communication channel [message #418523 is a reply to message #418421] Mon, 17 August 2009 00:38 Go to previous messageGo to next message
saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka
Junior Member
Its very amazing that two alert logs persist in my database.

575179    8 -rw-r--r--   1 oracle   oinstall     6079 Aug 16 15:10 /oradata1/app/oracle/product/9.2.0/rdbms/log/alert_EBISARC.log

 98306 4836 -rw-r--r--   1 oracle   oinstall  4939319 Aug 11 18:25 /oradata2/EBISARC/admin/bdump/alert_EBISARC.log


Here I have attached the last 100 lines of above alert log

]$ tail -300 /oradata1/app/oracle/product/9.2.0/rdbms/log/alert_EBISARC.log|more
Tue Aug 11 18:25:42 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_14438.trc:
ORA-07445: exception encountered: core dump [skgfrvldtrq()+72] [SIGSEGV] [Address not mapped to object] [0xBF5FFFE4] [] []
Tue Aug 11 18:49:57 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15164.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFDEC] [] []
Tue Aug 11 18:50:50 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15228.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFD8C] [] []
Tue Aug 11 18:51:56 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15284.trc:
ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFFD8] [] []
Tue Aug 11 18:59:15 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15463.trc:
ORA-07445: exception encountered: core dump [slnrm()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFED8] [] []
Tue Aug 11 19:02:23 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15607.trc:
ORA-07445: exception encountered: core dump [slnrm()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFEA8] [] []
Tue Aug 11 19:10:16 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15652.trc:
ORA-07445: exception encountered: core dump [ksfd_allfib()+398] [SIGSEGV] [Address not mapped to object] [0x108] [] []
Wed Aug 12 15:06:32 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15408.trc:
ORA-07445: exception encountered: core dump [sslpathi()+42] [SIGSEGV] [Address not mapped to object] [0xBF5FFE7C] [] []
Wed Aug 12 15:07:54 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15426.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFE5C] [] []
Wed Aug 12 15:14:05 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_15597.trc:
ORA-07445: exception encountered: core dump [sslpathi()+42] [SIGSEGV] [Address not mapped to object] [0xBF5FFFA0] [] []
Wed Aug 12 15:31:13 2009
Shutting down instance (abort)
Wed Aug 12 15:33:12 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_16121.trc:
ORA-07445: exception encountered: core dump [slnrm()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFE98] [] []
Wed Aug 12 15:46:40 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_16626.trc:
ORA-07445: exception encountered: core dump [skgfqio()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFFC4] [] []
Wed Aug 12 16:10:08 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_17417.trc:
ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+27] [SIGSEGV] [Address not mapped to object] [0xBF5FFF94] [] []
Wed Aug 12 17:28:44 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_19972.trc:
ORA-07445: exception encountered: core dump [sslpathi()+42] [SIGSEGV] [Address not mapped to object] [0xBF5FFFFC] [] []
Wed Aug 12 17:33:21 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_20117.trc:
ORA-07445: exception encountered: core dump [sltln()+6] [SIGSEGV] [Address not mapped to object] [0xBF5FFFD4] [] []
Wed Aug 12 17:50:19 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_29251.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFF9C] [] []
Wed Aug 12 17:51:20 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_29300.trc:
ORA-07445: exception encountered: core dump [__GI___errno_location()+4] [SIGSEGV] [Address not mapped to object] [0xBF5FFFFC] [] []
Wed Aug 12 19:10:05 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_31875.trc:
ORA-07445: exception encountered: core dump [sslpathi()+42] [SIGSEGV] [Address not mapped to object] [0xBF5FFFBC] [] []
Thu Aug 13 20:50:22 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_13249.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFE6C] [] []
Sat Aug 15 11:01:39 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_11274.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFF9C] [] []
Sat Aug 15 11:10:59 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_11608.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFE5C] [] []
Sat Aug 15 11:14:25 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_11735.trc:
ORA-07445: exception encountered: core dump [slnrm()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFECC] [] []
Sat Aug 15 11:24:10 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_12088.trc:
ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+27] [SIGSEGV] [Address not mapped to object] [0xBF5FFF94] [] []
Sat Aug 15 11:56:40 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_13101.trc:
ORA-07445: exception encountered: core dump [skgfifi()+44] [SIGSEGV] [Address not mapped to object] [0xBF5FFECC] [] []
Sun Aug 16 09:08:23 2009
Shutting down instance (abort)
Sun Aug 16 09:08:36 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_5215.trc:
ORA-07445: exception encountered: core dump [sslpath()+42] [SIGSEGV] [Address not mapped to object] [0xBF5FFFFC] [] []
Sun Aug 16 15:10:02 2009
Errors in file /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_16304.trc:
ORA-07445: exception encountered: core dump [_IO_vfprintf_internal()+39] [SIGSEGV] [Address not mapped to object] [0xBF5FFE98] [] []


Re: ORA-03113: end-of-file on communication channel [message #418524 is a reply to message #418523] Mon, 17 August 2009 00:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Back to my first answer:
Michel Cadot wrote on Sat, 15 August 2009 07:16
ORA-00600/ORA-07445/ORA-03113 = Oracle bug => search on Metalink and/or call Oracle support

Have a look at udump directory (see user_dump_dest parameter) there should be a trace file for your session.

Regards
Michel


Re: ORA-03113: end-of-file on communication channel [message #418591 is a reply to message #418421] Mon, 17 August 2009 09:46 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
What clues exist within /oradata1/app/oracle/product/9.2.0/rdbms/log/ebisarc_ora_5215.trc
Re: ORA-03113: end-of-file on communication channel [message #418917 is a reply to message #418591] Wed, 19 August 2009 03:06 Go to previous message
ch_byf
Messages: 1
Registered: August 2009
Junior Member
in sqlplus run command:show parameter sga
And in os run command:ipcs -a
Previous Topic: ORA-01499
Next Topic: Error in Alert Log
Goto Forum:
  


Current Time: Fri Dec 09 17:09:20 CST 2016

Total time taken to generate the page: 0.46177 seconds