RAC databases and&nbsp…
来源:互联网 发布:java 方法重写 编辑:程序博客网 时间:2024/06/07 04:57
RAC databases and ORA-1652: Unable ToExtend Temp Segment By %s In Tablespace TEMP [ID258941.1]
转到底部
修改时间:2012-2-7类型:PROBLEM状态:MODERATED优先级:3
注释 (0)
In thisDocument
Symptoms
Changes
Cause
Solution
References
This document is being delivered toyou via Oracle Support's Rapid Visibility (RaV) process andtherefore has not been subject to an independent technicalreview.
Applies to:
Oracle Server - Enterprise Edition -Version: 9.2.0.1 to 10.2.0.1 - Release: 9.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 06-Feb-2012***
Symptoms
Scripts may fail due to ORA-1652"unable to extend temp segment by %s in
tablespace TEMP"
although free space exists in TEMP tablespace in a RAC databaseconfiguration.
Also scripts may not fail you may find error messages(ORA-1652)
inside the alert.log of some of the instances.
Changes
Migrate to RAC configuration.
Use Default Temporary Tablespace feature.
Cause
We have 2 separate bugshere:
bug2934117 : ORA-1652:CAN'T ACQUIRE FREE EXTENTSOWNED BY OTHER NODE
for when scripts fail and also
bug2858082 : EVEN IF THE FREE EXTENTS AREAVAILABLE, ORA-1652 OCCURS IN ALERT.
LOG ON RAC
when scripts do not fail but errors appear inside alert.log of RACinstances.
Solution
1st Case bug 2934117
====================
Due to bug 2934117 we should NOT use a DEFAULT TEMPORARYTABLESPACE
for RAC database configuration, otherwise scripts could fail withORA-1652 as a RAC node
cannot acquire free extents that are owned by another RAC instancealthough they are free.
bug2934117 is fixed in 9205 and all versions ofOracle 10. Therefore, the best solution is to apply the latestpatch set or to upgrade to a supported version of Oracle.
Another solution is to apply the following workaround:
Workaround
------------------
step 1: Create new normal temp tablespace with minimum size (forexample TEMPRAC )
step 2: Set as default temp tablespace TEMPRAC
alter database default temporary tablespace TEMPRAC;
This commands changes all database users temporary tablespace toTEMPRAC
Now previous default temporary tablespace TEMP is a normaltemporary tablespace.
step 3: For all database users change back temporary tablespace toTEMP:
alter user default tempory teblespace TEMP;
step 4: shutdown immediate all instances
step 5: startup all instance
Unfortunatelly this TEMPRAC Default Temporary Tablespace cannot bedropped
completely.
We should keep it with small size.
In case new Database users are created, and temporary tablespace isnot defined
at creation time, these would
have as temporary tablespace TEMPRAC, so every new user aftercreation we have
to specify:
alter user temporary tablespace TEMP;
-> in order to change their temporary tablespace to TEMP whichis a normal
temporary tablespace.
2nd case bug 2858082
==================
The 2nd issue is caused due to the bug 2858082 "EVEN IF THE FREE EXTENTS ARE
AVAILABLE, ORA-1652 OCCURS IN ALERT.LOG ON RAC "
In this bug although scripts that need Temp tablespace space due toSort
Operations (order by, group by, join, etc)
are successfull we may see this error message inside alert.log ofRAC instances.
When a RAC instance fills its own sort pool of extents, instead ofallocation
new extents it may ask for free temp extents
from the other RAC instances. During this operation the ORA-1652may appear
inside the alert.log although the operation has succeeded.
This bug would only be solved in subsequent releases as it hasbeen
characterised as a low priority issue from development as onlydis-affect is that alert.log
may contain such messages but process do not fail.
You can ignore these error messages.
bug2858082 is now fixed in 9207 10104 and10201.
Therefore, the best option is to apply the latest patchset.
References
BUG:2934117 - ORA-1652:CAN'T ACQUIRE FREE EXTENTSOWNED BY OTHER NODE
相关内容
…
产品
…
- Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition > Real Application Cluster > RAC Administrative Issues
错误
…
ORA-1652
返回页首
窗体底端
确定
确定取消
- RAC databases and&nbsp…
- COMMIT WORK AND&…
- Debug Android and&nbsp…
- Debug Android and&nbsp…
- Oracle RAC 11.2.0.2&nb…
- weibo 登录&nbsp…
- Android edittext&nbsp…
- !!! FAILED BINDER&nbsp…
- SecureFile LOBs and&nb…
- ORA-4031 and Shared&nb…
- OGNL & ValueStack&…
- LA 5713 Qin&nbsp…
- Convex Hull Algorithms & general…
- Javascript_DOMContentLoaded&nbsp…
- ApplicationEventMulticaster&nbsp…
- PROCESS J000 And …
- google desktop search&…
- Running Health Checks&…
- 一则controlfile丢失,或损坏的恢…
- VIP 原理和特点
- 札记:study from master
- 快速解决问题 - 最优实践
- Oracle online doc&nbsp…
- RAC databases and&nbsp…
- Statistics Package (ST…
- Statistics Package (ST…
- Cache buffers chains&n…
- iphone 查激活时间
- ora-01102问题的解决
- 【STARTUP】Oracle数据库启动过程…
- 恢复删除的数据文件案例《from&nbs…
- ORA-1652: Unable To&nb…