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.8Type:PATCH
 Last Revision Date:09-MAY-2008Status: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 affectedVersions < 11.2
Versionsconfirmedas being affected
  • 10.2.0.3
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in
  • 11.1.0.7 (Server Patch Set)

Symptoms:

Related To:

  • (None Specified)
  • 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

 


TAG: bug rac

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

日历

« 2008-11-23  
      1
2345678
9101112131415
16171819202122
23242526272829
30      

数据统计

  • 访问量: 2901
  • 日志数: 1038
  • 建立时间: 2008-03-30
  • 更新时间: 2008-11-04

RSS订阅

Open Toolbar