Re: Oracle on NT versious UNIX

On Thu, 23 Dec 1999 01:07:07 GMT, GC <johnn_sanga_at_hotmail.com> wrote:

>mayooran wrote:
>>
>> Hi Folks,
>>
>> I do not wish to start an NT versious UNIX war.
>>
>> What OS is best to run Oracle. Currently running on
>> an Ultra 4000 with Solaris 2.6. An NT consultant is saying
>> it is best to run Oracle on an NT platform. I am actually
>> looking for pros/cons of the 2 different platforms.
>
>Just my opinion based upon experience:
>
>NT: Pros: Easy to maintain the OS. Relatively stable (that is, if you
>can afford to schedule a reboot every once in a while) if you are not
>too demanding on the database. Sysadmin not necessary to keep database
>server running (although it is always a good idea to have your friendly,
>competant sysadmin set the OS up for the database (and only for the
>database - no other apps allowed!)

I would say NT is difficult to maintain. Based on that you have little nowledge abou what happens in system and limited to maintain the systm by putting package/patch unpon patch on NT - and installing things in right order.

Of course I can be wrong. Still that was my experience from the 80 NT Servers and 1800 NTWS.

> Cons: Not a good platform for mission critical databases, or for
>databases that cannot be brought down for a scheduled OS reboot. Rather
>constricted set of automation tools (few if any come with NT, although
>Perl has been ported). Scripting language is pretty much non-existant on
>NT (.bat files are about as good as it gets).

I did my scripting in Perl. I refuced to used bat (based on my vote in 1984 never to use goto anymore - and I have not!).

>Unix: Pros: Very flexible archicture, and very stable for any size
>database. Uptime of months/years without problems. Scripts can be
>created to automate many routine dba tasks, suitable OS for mission
>critical databases.
> Cons: Rather cryptic OS to learn on (i.e. steep learning curve if
>you are coming from a Windows background). Definite need for a sysadmin
>to set the box up (unless you yourself are fully qualified, and I don't
>mean "I've glanced once or twice at Linux, so I'm an admin).

But from what I have heard (and experienced) , one problem about NT is that the learning curve do get almost 90% when you go down into the system and not just the graphical interface. Unix - ... sigh .... - I''ve used so many flavour - by have to relearn the commands and parameters and sysadm tools each time I have to administrate a new one. Yes... I know it is horrible.

>Personally, I much prefer Unix over NT. I have come from a Windows
>background and find Unix infinitely more flexible to work in than
>windows. Others opinions will very.

I do agree.

>
>So the choice is yours. NT is usually easier to get the database started
>on, Unix will usually be more stable and robust once you get the OS and
>database setup.

When people buy Oracle, the price usually indicate that this is for mission critical purpose ? (just a general assumption). I will recommend Unix. Btw, Oracle do that too, so far I remember.

/Bent Received on Sun Dec 26 1999 - 16:56:03 CST