| ORA 03113 [message #398637] |
Fri, 17 April 2009 01:01  |
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 #398648 is a reply to message #398637] |
Fri, 17 April 2009 01:21  |
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 |
 |
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
