Home » Other » General » ORA 03113 (Oracle 9i, 9.2.0.1.0, RHEL 2.1 AS)
ORA 03113 [message #398637] Fri, 17 April 2009 01:01 Go to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Freinds,

i am facing quite serious problem,when i try to query from sql*plus client.i got the ORA 03113 error.I found that this error raised in alert lot before 15 days back ,but for last few days the error comes now and then.My main problem is it happens on my live prod db.so please suggest me some thing quickly.my alert file size is 3mb and trace file generated from that error was 8.6mb. so i think i don't upload that file right now.

SQL> /
Select InvoiceId,sum(FinalChest) FinalChest from Bld.Clstock;
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

This is what i get in alert.log
Fri Apr 17 10:56:19 2009
Errors in file /ora9isoft/odb/OH1/admin/wbdata/udump/wbdata_ora_5044.trc:
ORA-07445: exception encountered: core dump [evaopn2()+312] [SIGSEGV] [Address not mapped to object] [0x0] [] []
Fri Apr 17 10:58:24 2009
Errors in file /ora9isoft/odb/OH1/admin/wbdata/udump/wbdata_ora_7070.trc:
ORA-07445: exception encountered: core dump [evaopn2()+312] [SIGSEGV] [Address not mapped to object] [0x0] [] []


Some more information, we are not registered with oracle support and company don't want to pay for metalink support. so please friends help me out of this.trace file and log file uploaded/mailed if any one required.
Re: ORA 03113 [message #398644 is a reply to message #398637] Fri, 17 April 2009 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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

Regards
Michel
Re: ORA 03113 [message #398648 is a reply to message #398637] Fri, 17 April 2009 01:21 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

it is not possible for me to contact support or paid metalink support,bcause company is not ready to pay for that,if export the full database then create new database on same machine and import the exported data, will it work for me.please suggest me any other solutions if available.

Regards

Jimit
Re: ORA 03113 [message #398652 is a reply to message #398648] Fri, 17 April 2009 01:36 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
if export the full database then create new database on same machine and import the exported data, will it work for me.please suggest me any other solutions if available.

Maybe yes, maybe no, it depends on the root of the bug.
We can't use our company's contract (and money) to help you, this would be a violation of this contract.
If your company don't want to pay for support, it cannot have more than the free available support.

Regards
Michel
Previous Topic: License Oracle Database
Next Topic: Mismatch in data length of columns involved in referential integrity constraint
Goto Forum:
  


Current Time: Fri Mar 29 07:33:55 CDT 2024