Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: *nix vs MS

RE: *nix vs MS

From: Johnson, George <GJohnson_at_GAM.COM>
Date: Fri, 7 Oct 2005 08:10:23 +0100
Message-ID: <>

        Just giving my tuppence worth, so take it with a pinch of salt...

        I prefer *nix or Windows systems, as the inbuilt support for third-party scripting is usually slightly better, alright so you get Perl and Java on MS, but you need to learn a language to get something done. Most admins don't want to learn another language syntax just get capture a few backups and run a few simple maintenance jobs. The O/S design on *nix tends to be able to support minor changes and patches without the need to reboot, for want of a better description, the OS file locking on *nix is less restrictive than MS, so being cheeky, you can almost pull everything out bar the kernel, and the system will keep running, but on the other hand pulling running components out of Windows is a lot harder, so it's slightly safer. Swings and roundabouts.

        Of course from a management point of view, hiring a good MS admin over a *nix admin is usually cheaper. The percentage of good admins in both OS types seems to be about the same, but I suppose because the MS OS is so prevalent and so easy to work with on a basic level, there are more MS admins about, but there does appear to be far too many people who helped fixed their cousin's PC and now think they are qualified to run a 16 node MS cluster running a 750Gb Oracle DB! MS make some very good solid software most of the time, lots of people get to use computers now, who never would have should a chance years ago, but just because it can run server type apps, doesn't mean it should be used for mission critical ones.

        Let's face it, when the big DB makers come to start work on their new shiny version of the product, it's usually *nix that gets the test bed. It's easier to get underneath it and find out exactly what is going on in memory, when that complex sorting algorithm or disk writer keeps failing. Plus how many of the huge companies, run their multi-terabyte warehouses on MS? Maybe a handful, but not that many I can imagine.

        Of course the one thing that does always get me is, the MS admins thinks nothing of rebooting to fix a simple problem, the users just accept it, like they do on their PCs. The Unix admin always considers the reboot the very final, last straw after trying everything else and you ask the users if you can reboot the main *nix DB server and it's "Can't it wait until after hours?" or "Why now? This is just not acceptable.".


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

From: Robyn [] Sent: 06 Oct 2005 22:59
To: Oracle-L_at_Freelists. Org (E-mail)
Subject: *nix vs MS


We have a fairly large, truly mission critical database (Oracle at a remote site that is currently running on Microsoft. In the past, others have tried to convince mgmt that the system would be more reliable on a unix os, but no one has ever been successful in obtaining a project to make the change.

To my way of thinking, the strongest case for moving this database to unix is the track record of this application; it has had far more than it's share of issues (bad backups, system crashes, corrupt blocks, hung processes, cpu spikes and so on) even though it already gets more care and feeding than other databases. (majority of our databases are *nix) This is one aspect of what will be presented.

That being said, for those of you who prefer unix, what are your best arguments for choosing unix for an Oracle database? What are the drawbacks? We'd like to make sure we uncover all the pros and cons.

Any input is appreciated,



Robyn Anderson Sands

This message contains confidential information and is intended only for the individual or entity named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as an invitation or offer to buy or sell any securities or related financial instruments.
GAM operates in many jurisdictions and is regulated or licensed in those jurisdictions as required.

-- Received on Fri Oct 07 2005 - 02:14:02 CDT

Original text of this message