 | | | -none- | -none- 2007-10-01 - By Crisler, Jon
Back
1) Make sure that the network interconnect is negotiating at
1gigabit full duplex. Don't accept the answer that 'the hardware
supports it' but VERIFY that it is negotiating at that speed.
2) Ora-4031 (See http://Ora-4031.ora-code.com) - not enough memory in shared pool.
3) Global cache issues: again, network issues can affect this.
Make sure all sequences have cache values, as this can hurt performance
and is often overlooked.
__ ____ ____ ____ ____ ____ ____
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] On Behalf Of sam roberts
Sent: Saturday, September 29, 2007 11:10 PM
To: oracle-l
Subject: Fwd: RAC on windows 2003 - 32-bit - nightmare
I have just inherited a RAC 2 node database: Using DELL Poweredge 2950
Servers with 16GB RAM and DELL power vault MD3000 SAS Storage:
I have previously absolutely no experience on Windows, as Im UNIX and
LINUX and as I mentioned I inherited this built.
The problem is that when both Nodes are up and running there are many
problems:
1)running a 5 minute export takes 5 hours and times out - session_wait
says busy_buffer
2)ora600 and ora-04031 (See http://ora-04031.ora-code.com) errors on client and eventually cant log in
3)tns12170 errors intermittently when logging in
4) lots off warnings of global_cacahe_wait excessive:
When we switch one node of the performance and everything runs normally.
I have been told this is the 3rd build of this system and it happened
everytime.
I am suspecting the network right config right now.
Please any suggestions from you guys would be highly appreciative.
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft
-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http:
//www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@(protected)
{font-family:Tahoma;
panose-1 (See http://ose-1.ora-code.com):2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@(protected) Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
/* List Definitions */
@(protected) l0
{mso-list-id:554438027;
mso-list-type:hybrid;
mso-list-template-ids:-1770075636 -1798823698 67698713 67698715 67698703
67698713 67698715 67698703 67698713 67698715;}
@(protected) l0:level1
{mso-level-text:"%1\)";
mso-level-tab-stop:.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0
level1 lfo1'><![if !supportLists]><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><span style='mso-list:Ignore'>1)<font size=1 face="Times New Roman"
><span
style='font:7.0pt "Times New Roman"'> <
/span></font></span></span></font><![endif]><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Make sure that the network interconnect is negotiating at 1gigabit
full
duplex. Don’t accept the answer that ‘the hardware supports
it’
but VERIFY that it is negotiating at that speed.<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0
level1 lfo1'><![if !supportLists]><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><span style='mso-list:Ignore'>2)<font size=1 face="Times New Roman"
><span
style='font:7.0pt "Times New Roman"'> <
/span></font></span></span></font><![endif]><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Ora-4031 (See http://Ora-4031.ora-code.com) – not enough memory in shared pool.<o:p></o:p></span
></font></p>
<p class=MsoNormal style='margin-left:.5in;text-indent:-.25in;mso-list:l0
level1 lfo1'><![if !supportLists]><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'><span style='mso-list:Ignore'>3)<font size=1 face="Times New Roman"
><span
style='font:7.0pt "Times New Roman"'> <
/span></font></span></span></font><![endif]><font
size=2 color=navy face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:navy'>Global cache issues: again, network issues can affect this.
Make
sure all sequences have cache values, as this can hurt performance and is often
overlooked. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'>
oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] <b><span
style='font-weight:bold'>On Behalf Of </span></b>sam roberts<br>
<b><span style='font-weight:bold'>Sent:</span></b> Saturday, September 29, 2007
11:10 PM<br>
<b><span style='font-weight:bold'>To:</span></b> oracle-l<br>
<b><span style='font-weight:bold'>Subject:</span></b> Fwd: RAC on windows 2003
- 32-bit - nightmare</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I have just inherited a RAC 2 node database: Using DELL Poweredge 2950
Servers with 16GB RAM and DELL power vault MD3000 SAS Storage:<o:p></o:p></span
></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I have previously absolutely no experience on Windows, as Im UNIX and
LINUX and as I mentioned I inherited this built.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>The problem is that when both Nodes are up and running there are many
problems:<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>1)running a 5 minute export takes 5 hours and times out - session_wait
says busy_buffer<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>2)ora600 and ora-04031 (See http://ora-04031.ora-code.com) errors on client and eventually cant log in<o:p>
</o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>3)tns12170 errors intermittently when logging in<o:p></o:p></span><
/font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>4) lots off warnings of global_cacahe_wait excessive:<o:p></o:p></span>
</font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>When we switch one node of the performance and everything runs
normally. I have been told this is the 3rd build of this system and it happened
everytime.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>I am suspecting the network right config right now.<o:p></o:p></span><
/font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Please any suggestions from you guys would be highly appreciative.<o:p>
</o:p></span></font></p>
</div>
</div>
</body>
</html>
|
|
|