Home » SQL & PL/SQL » SQL & PL/SQL » ORA-12805: parallel query server died unexpectedly (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0,linux)
ORA-12805: parallel query server died unexpectedly [message #415573] Tue, 28 July 2009 05:00 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,

I got the ORA-12805: parallel query server died unexpectedly error while executing the below query.


SELECT d.rate, d.total_demand_weight * d.rate, m.activity *d.rate
FROM mtdemand_results_v d INNER JOIN bid_fg_v b
ON d.booking_forecast_group_key = b.bfg_key
LEFT JOIN mtroute_seg_results_v m
ON d.daily_final_demand_key = m.daily_final_demand_key
AND d.scenario_key = m.scenario_key
AND d.booking_forecast_group_key = m.mtbooking_forecast_group_key;

I have searched the google and metalink.from that, i have found commands for this problem. they said,please upgrate the your oracle version.but my oracle version is 10.2.0.4.0. i have also checked the trace file.it shows a ORA-07445: exception encountered: core dump [evaopn2()+3509] [SIGSEGV] [Address not mapped to object] [0x0] [] []. i saw metalink commands from this problem, it noted "please upgrade the problem".

suddenly, i have rewrite the above query. the ANSI joins are converted into Oracle joins. It gives output without any error.

code :

SELECT d.rate, d.total_demand_weight * d.rate, m.activity *d.rate
FROM mtdemand_results_v d, bid_fg_v b, mtroute_seg_results_v m
WHERE d.booking_forecast_group_key = b.bfg_key
AND d.daily_final_demand_key = m.daily_final_demand_key(+)
AND d.scenario_key = m.scenario_key(+)
AND d.booking_forecast_group_key=m.mtbooking_forecast_group_ke(+).

please give the suggestions about this? i don't know why it's happening?
Re: ORA-12805: parallel query server died unexpectedly [message #415577 is a reply to message #415573] Tue, 28 July 2009 05:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Still not formatted.

Regards
Michel
Re: ORA-12805: parallel query server died unexpectedly [message #415586 is a reply to message #415573] Tue, 28 July 2009 05:32 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
don't except more format from any others. please give the solutions for it.

this mail is more readable. please read it and give solutions?
Re: ORA-12805: parallel query server died unexpectedly [message #415596 is a reply to message #415586] Tue, 28 July 2009 05:53 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Well, Oracle suggests
Quote:
Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services. See trace file for more details.

Lucky you, you have solved it by removing ANSI joins. Did you consider creating a SR at Metalink?

As of (un)formatted code: it is not that this simple query is not formatted, but the fact that code enclosed into [code] tags (i.e. the one that uses non-proportional font) is easier to read. How much would it cost if you, actually, used those tags?
Re: ORA-12805: parallel query server died unexpectedly [message #415605 is a reply to message #415586] Tue, 28 July 2009 06:10 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
holdingbe wrote on Tue, 28 July 2009 12:32
don't except more format from any others. please give the solutions for it.

this mail is more readable. please read it and give solutions?

I will help when you will follow the guide.
Here you failed in at least 2 points:
1/ you didn't format
2/ you didn't search before posting

Regards
Michel

Re: ORA-12805: parallel query server died unexpectedly [message #420538 is a reply to message #415573] Mon, 31 August 2009 03:46 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
After a long investigate, the oracle patch was upgraded into 10.2.4.0 from 10.2.3.0 versions in linux environments. the query works fine.

after that, i have upgraded 10.2.4.0 versions PRE_UAT machine in solaris environments. but the query gives the same error ORA-07445: exception encountered: core dump.

Please help me...


Re: ORA-12805: parallel query server died unexpectedly [message #420552 is a reply to message #420538] Mon, 31 August 2009 05:09 Go to previous message
Michel Cadot
Messages: 64145
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
Previous Topic: Oracle 10: PL SQL: Comparing records from two (ref) cursors
Next Topic: ORACLE 10G data insertion
Goto Forum:
  


Current Time: Fri Dec 09 11:52:58 CST 2016

Total time taken to generate the page: 0.10319 seconds