RE: RAC on windows 2003 - 32-bit - nightmare

What versions of database, CRS, what is the network configuration like, how are the cards negotiating with the switches, etc.? We need more details before we can weigh in with anything useful.

Good luck,
Matt

--

Matthew Zito
Chief Scientist
GridApp Systems
P: 646-452-4090
mzito_at_gridapp.com
http://www.gridapp.com

-----Original Message-----

From: oracle-l-bounce_at_freelists.org on behalf of sam roberts Sent: Sat 9/29/2007 11:09 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 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.

--

http://www.freelists.org/webpage/oracle-l Received on Sun Sep 30 2007 - 17:11:47 CDT