oracle rac bug
上一篇 /
下一篇 2008-06-30 20:16:12
/ 个人分类:oracle
RAC突然不能负载均衡
环境:Oracle RAC(版本10.2.0.3)和WebSphere cluster,操作系统都是AIX5.3
应用程序通过OCI方式连接数据库.
现在问题:现在应用程序指连启动的一台数据库。实现不了负载均衡。
从客户端连没有应用连接的可以连进去。lsnrctl status 两个instance都是ready的
临时解决方法:重新启动了oracle服务。
从日志看是突然就没有session连接到其中的节点,通过v$session查看,链接只有oracle的进程,由于oralce中没有600的错误,不好确定是否为oracle的bug,咨询oracle工程师,工程师初步判断
1.服务器端保留了连接的信息。
2.bug
由于客户买了oracle的服务,不用白不用,请了oracle的过来检查,工程师定位为oracle的bug。建议安装patch set 10.2.0.4,或者补丁7003518.
| Subject: | Bug 6083037 - Server side load balancing does not work |
| | Doc ID: | Note:6083037.8 | Type: | PATCH |
| | Last Revision Date: | 09-MAY-2008 | Status: | PUBLISHED |
function getdoc2(docstr,mlstr) { pos=docstr.indexOf(':'); docid=docstr.substring(pos+1,docstr.length); tgt="_blank"; if ( location.href.slice(7,12) == "webiv" || location.href.slice(7,11) == "rmsu" ) { loc="Get?WwwID=note:" + docid; } else { if ( location.href.slice(7,12) == "metal" || location.href.slice(7,12) == "suppo" ) { loc=mlstr + docid; } else { loc="http://metalink.oracle.com/metalink/plsql/"+mlstr+docid; } } window.open(loc,tgt); return; } function getdoc(docstr) { getdoc2(docstr,"showdoc?db=NOT&id="); } function taghelp(str) { getdoc2('NOTE:245840.1#'+str,"ml2_documents.showNOT?p_id="); } Clickherefor details of sections in this note.Bug 6083037 Server side load balancing does not work
This note gives a brief overview of bug 6083037.
Affects:
| Product (Component) | Oracle Server (Rdbms) |
| Range of versionsbelievedto be affected | Versions < 11.2 |
| Versionsconfirmedas being affected | |
| Platforms affected | Generic (all / most platforms affected) |
Fixed:
| This issue is fixed in | - 11.1.0.7 (Server Patch Set)
|
Symptoms: | Related To: |
| - RAC (Real Application Clusters) / OPS
- Network
|
Description
With server-side load balancing configured, the listeners might route
all requests to the busiest node(s).
Workaround:
Restart the listener on the lightly loaded node(s) but that may
not fix the problem for very long.
from metalinkhttps://metalink.oracle.com/metalink/plsql/f?p=130:14:8091473448553480007::::p14_database_id,p14_docid,p14_show_header,p14_show_help,p14_black_frame,p14_font:NOT,6083037.8,1,0,1,helvetica
相关阅读:
- 当安装失败时如何彻底删除10gRAC (lcx_315, 2008-2-18)
- 恢复10G RAC+ASM 到单机 (xhailiang, 2008-2-20)
- 终于可以连接到ISCSI了。。。 (lhb_apple, 2008-2-27)
- 服务器出了些状况 (testmvb, 2008-3-14)
- 连接RAC时的ORA-12545问题 (byfree, 2008-4-28)
- VMware上安装Oracle 10g RAC for RHEL4 (byfree, 2008-5-16)
- 适合规模很小的团队的缺陷管理流程 (ddeef, 2008-5-19)
- 【流云】Qlogic Infiniband RDS高速互联驱动程序安装及配置 (idba, 2008-6-07)
- 【江枫】Oracle10.2.0.4 Linux64版本监听存在多个子进程 (idba, 2008-6-07)
- 手把手教你用VMware在linux下安装oracle10g RAC(1) (junsansi, 2008-6-12)
导入论坛
引用链接
收藏
分享给好友
推荐到圈子
管理
举报
TAG:
bug
rac