- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORA errors
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 03:44 AM
тАО12-19-2007 03:44 AM
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 03:54 AM
тАО12-19-2007 03:54 AM
Re: ORA errors
Looks more like a Windows setup to me
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 04:28 AM
тАО12-19-2007 04:28 AM
Re: ORA errors
Check the swap space:
#swapinfo -tm
Best Regards,
Eric
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-19-2007 04:31 AM
тАО12-19-2007 04:31 AM
Re: ORA errors
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';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-20-2007 09:43 AM
тАО12-20-2007 09:43 AM
Re: ORA errors
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-20-2007 12:29 PM
тАО12-20-2007 12:29 PM
Re: ORA errors
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-20-2007 12:44 PM
тАО12-20-2007 12:44 PM
SolutionFrom 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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-21-2007 01:01 AM
тАО12-21-2007 01:01 AM
Re: ORA errors
To bad nobody was listening neither assigning points...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-21-2007 01:02 AM
тАО12-21-2007 01:02 AM
Re: ORA errors
To bad the question's author wasn't listening neither assigning points...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО12-24-2007 04:44 AM
тАО12-24-2007 04:44 AM
Re: ORA errors
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