cancel
Showing results for 
Search instead for 
Did you mean: 

ORA errors

SOLVED
Go to solution
Nirmalkumar
Frequent Advisor

ORA errors

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.
9 REPLIES

Re: ORA errors

what version of HP-UX are you on ?
Looks more like a Windows setup to me
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
Eric Antunes
Honored Contributor

Re: ORA errors

Hi,

Check the swap space:

#swapinfo -tm

Best Regards,

Eric
Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: ORA errors

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';
Each and every day is a good day to learn.
Yogeeraj_1
Honored Contributor

Re: ORA errors

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
TwoProc
Honored Contributor

Re: ORA errors

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.
We are the people our parents warned us about --Jimmy Buffett
TwoProc
Honored Contributor
Solution

Re: ORA errors

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
We are the people our parents warned us about --Jimmy Buffett
Eric Antunes
Honored Contributor

Re: ORA errors

Thank you TwoProc,

To bad nobody was listening neither assigning points...

Each and every day is a good day to learn.
Eric Antunes
Honored Contributor

Re: ORA errors

Thank you TwoProc,

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

Each and every day is a good day to learn.
Nirmalkumar
Frequent Advisor

Re: ORA errors

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