topic Re: ORA errors in Operating System - HP-UX

ORA errors

Nirmalkumar — Wed, 19 Dec 2007 11:44:04 GMT

Hi,

iam getting the below errors frequently in my database.My database running in multimaster replication env.

Oracle version : 10.2.0.3.0

---------------------------------------------
Wed Dec 19 03:13:53 2007
Errors in file j:\oracle\admin\svdl\bdump\svdl_j000_3232.trc:
ORA-00600: internal error code, arguments: [15709], [1], [1], [65535], [], [], [], []
ORA-12805: parallel query server died unexpectedly
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1716
ORA-06512: at "SYS.DBMS_DEFER_SYS", line 1804
ORA-06512: at line 1

Wed Dec 19 03:21:47 2007
Errors in file j:\oracle\admin\svdl\bdump\svdl_j000_6788.trc:
ORA-00600: internal error code, arguments: [15709], [1], [1], [65535], [], [], [], []
ORA-12805: parallel query server died unexpectedly
---------------------------------------------

Please help me to resolve the issue.

Thanks
Nirmal.

Re: ORA errors

melvyn burnard — Wed, 19 Dec 2007 11:54:54 GMT

what version of HP-UX are you on ?
Looks more like a Windows setup to me

Re: ORA errors

Eric Antunes — Wed, 19 Dec 2007 12:28:37 GMT

Hi,

Check the swap space:

#swapinfo -tm

Best Regards,

Eric

Re: ORA errors

Eric Antunes — Wed, 19 Dec 2007 12:31:30 GMT

Hi,

It can also be a sub dimensioned shared pool. Check if you have the minimum size or at least a size close to this:

select to_number(value) shared_pool_size,
sum_obj_size,
sum_sql_size,
sum_user_size,
(sum_obj_size + sum_sql_size+sum_user_size)* 1.3 min_shared_pool
from (select sum(sharable_mem) sum_obj_size
from v$db_object_cache where type <> 'CURSOR'),
(select sum(sharable_mem) sum_sql_size
from v$sqlarea),
(select sum(250 * users_opening) sum_user_size
from v$sqlarea), v$parameter
where name = 'shared_pool_size';

Re: ORA errors

Yogeeraj_1 — Thu, 20 Dec 2007 17:43:10 GMT

Hi,

You are definitely facing an abnormal condition - ORA-600. If you have metalink access, you can upload the trace in the lookup utility to get more information on the right problem.

Note 153788.1 : Troubleshoot an ORA-600 or ORA-7445 Error Using the Error Lookup Tool

hope this helps!
kind regards
yogeeraj

Re: ORA errors

TwoProc — Thu, 20 Dec 2007 20:29:13 GMT

Good diagnostic post Eric.

I've tuned my shared pool through trial and error (just by watching the events of the day),and my pool size is within .0025 % of what your script says it should be.

Nice post.

Re: ORA errors

TwoProc — Thu, 20 Dec 2007 20:44:50 GMT

Good news, that error is NOT going to corrupt your database.

From Oracle's tool as mentioned by Yogeeraj:

This error is raised when there are problems with parallel query
processing while creating and shutting down query slave (server)
processes.

IMPACT:
PROCESS FAILURE
NON CORRUPTIVE - No underlying data corruption.

SUGGESTIONS:
Increase the parallel_max_servers parameter in init.ora
and retry the operation.

Known Issues:
Bug# 3256025 See Note 3256025.8
OERI[15709] cleaning up dead PQ slaves
Fixed: 9.2.0.5, 10.1.0.2

Bug# 2362461 See Note 2362461.8
OERI:[15709] possible due to PQ slave cleanup race condition
Fixed: 9.2.0.2, 10.1.0.2

Bug# 1615171 See Note 1615171.8
OERI:15709 possible on rollback of PDML which takes > 32 minutes
Fixed: 8.1.7.3, 9.0.1.0

Re: ORA errors

Eric Antunes — Fri, 21 Dec 2007 09:01:09 GMT

Thank you TwoProc,

To bad nobody was listening neither assigning points...

Re: ORA errors

Eric Antunes — Fri, 21 Dec 2007 09:02:00 GMT

Thank you TwoProc,

To bad the question's author wasn't listening neither assigning points...

Re: ORA errors

Nirmalkumar — Mon, 24 Dec 2007 12:44:36 GMT

Hi all,

Thanks for your response .

sorry,iam unable to reponse early becoz i returned back to work after 5 days leave.

i uploaded the oraerrors to metalink and waiting for response.

Thanks
Nirmal