Home » Other » General » ORA-03113: end-of-file on communication channel (10.2.0.3)
icon8.gif  ORA-03113: end-of-file on communication channel [message #337316] Wed, 30 July 2008 09:45 Go to next message
princeva
Messages: 4
Registered: July 2008
Location: United States
Junior Member
Database is not coming after rebooting the box.

SQL> alter database open ;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

this is 10.2.0.3 on solaris 5.8.
Re: ORA-03113: end-of-file on communication channel [message #337331 is a reply to message #337316] Wed, 30 July 2008 10:16 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

what is in the alert_SID.log file; specifically what is in last trace file noted in alert_SID.log file?

[Updated on: Wed, 30 July 2008 10:17] by Moderator

Report message to a moderator

Re: ORA-03113: end-of-file on communication channel [message #337334 is a reply to message #337316] Wed, 30 July 2008 10:19 Go to previous messageGo to next message
princeva
Messages: 4
Registered: July 2008
Location: United States
Junior Member
It says pmon and smon both the processes terminated.

ORA-07445: exception encountered: core dump [kcbsacc()+4716] [SIGSEGV] [Address not mapped to object] [0x000000008] [] []
replication_dependency_tracking turned off (no async multimaster replication found)
Wed Jul 30 14:39:26 2008
Errors in file /opt/oracle/app/oracle/admin/ipremqa/bdump/ipremqa_pmon_11698.trc:
ORA-00474: SMON process terminated with error
Wed Jul 30 14:39:26 2008
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 11698

Re: ORA-03113: end-of-file on communication channel [message #337335 is a reply to message #337316] Wed, 30 July 2008 10:23 Go to previous messageGo to next message
princeva
Messages: 4
Registered: July 2008
Location: United States
Junior Member
ipremqa_pmon_18489.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /opt/oracle/app/oracle/product/10.2
System name: SunOS
Node name: omzintq02
Release: 5.8
Version: Generic_117350-44
Machine: sun4u
Instance name: ipremqa
Redo thread mounted by this instance: 1
Oracle process number: 2
Unix process pid: 18489, image: oracle@omzintq02 (PMON)

*** 2008-07-30 15:15:29.286
*** SERVICE NAME:(SYS$BACKGROUND) 2008-07-30 15:15:29.283
*** SESSION ID:(555.1) 2008-07-30 15:15:29.283
wsd 3c1233d60, sbuf 382bf78a8, setid 21, op 1
lcuridx 19, lasz 381ff7c10
Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x10, PC: [0x101603d8c, kcbsslc()+268]
*** 2008-07-30 15:15:29.303
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [kcbsslc()+268] [SIGSEGV] [Address not mapped to object] [0x000000010] [] []
Re: ORA-03113: end-of-file on communication channel [message #337336 is a reply to message #337316] Wed, 30 July 2008 10:25 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
File a Service Request with Oracle.
You have a fatal bug.
Re: ORA-03113: end-of-file on communication channel [message #337345 is a reply to message #337336] Wed, 30 July 2008 10:56 Go to previous message
princeva
Messages: 4
Registered: July 2008
Location: United States
Junior Member
Sure. Thanx.
Previous Topic: BLOB to Filesystem Clarification
Next Topic: regarding grid computing
Goto Forum:
  


Current Time: Thu Mar 28 08:25:31 CDT 2024