| ORA-12805: parallel query server died unexpectedly [message #415573] |
Tue, 28 July 2009 05:00  |
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 #420538 is a reply to message #415573] |
Mon, 31 August 2009 03:46  |
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...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
