Re: Oracle RAC on Win vs. Oracle on Linux
Date: Wed, 24 Feb 2010 09:57:12 -0300
Well, RAC needs a lot of babysitting, be it on windows, linux or commercial unix (AIX/SunOS/HPUX). Windows adds a little bit more of haggle to the whole thing, being very complex at the core in order to 'protect' the OS.
Where I work we have about 50% of the databases on AIX and the rest on windows. Linux, SunOS and HP-UX have minor appearances.
The funny thing is this: Most of the problem on DBs on Unix, are related to either user error, an Oracle Bug, or a hardware failure. About 50% of the problems on DBs on Windows are OS related issues (OS users expiring, updates, reboots, antivirus issues, firewall issues, etc). THIS is why we are starting to move the most critical DBs to UNIX. VERY slowly, because we have to deal with a lot of customers that don't know Unix and 'rely' on Windows...
This gives us the added advantage that 'regular' users (customer side) would not access the DB directly, but will do so through the application. And they can hardly do anything to the DB without the proper authorizations. So we have better control on the DBs, which greatly reduces 'user error' scenarios.