Re: Oracle archive logging over a Windows NT share - does it work?

drak0nian_at_yahoo.com (Paul Drake) wrote in message

Paul

 Thanks for the comparison of NT4 and W2k! Nothing dramatic on that list, and still W2k is a far cry from being as manageable as a *nix box. Is there any good reason for an upgrade that brings in only marginal benefits? The reward/effort ratio is sort of too low.

 I'll check out the book and mentioned tools.

 Thanks again!

 Konstantin

> (#1 there is the SMT in the P IV CPUs that one must disable on W2K).
>
> Ok, this is far from complete, but I'm not going to spend alot of time
> on it.
> Off the top of my head ...
>
> NTFS
> W2K:
> - 8k blocksize matches my db_block_size volumes for datafiles
> - 64k blocksize nice for archived redo logs, staging areas for backups
> - dynamic partitions - can be resized, mirrored, striped.
> NT4:
> - 4k max blocksize for filesystem
>
> either way - I still wouldn't use software raid. but it is nice to be
> able to add space to a volume.
>
> services:
> W2K:
> - assiging a user account to a service easier
> - automatically grants the system privilege "log on as service" to the
> user
> - services can be restarted automatically
> - can set dependencies
> - can generate event on service failure
>
> scheduled tasks:
> W2K:
> - assigning a user account or group to a scheduled job
> - advanced properties very nice, can start a job and have it run
> numerous times for a time interval and terminate (such as movement of
> archived redo logs)
> - can set start date/end date for a scheduled task
> - gui in control panel not from NT3.51 (resource kit).
> NT4:
> - sucks
> - resource kit required, whereby your crease a service for the task.
> (this is NT 3.51 stuff re-used).
> - soon.exe (RK) command could reschedule the task, but not terminate.
>
> event logging/mmc
> W2K:
> - the microsoft management console used for computer management
> doesn't suck.
> - you can create your own custom mmc windows
> - integration with Oracle administrative assistance, performance
> monitor.
> - lvm used for disk management is decent, Dell ships boxes with the
> enhanced Veritas LVM for windows 2000 - which is very nice.
>
> NT4:
> -sucks.
>
> I'd highly recommend the book:
> "Oracle 9i for Windows 2000 Tips and Techniques"
> by Jesse, Hart and Sale ISBN 0-07-219462-2
> most of their material works for Oracle 8.1.7 on W2K.
>
> and download every free tool you see up on
> http://www.sysinternals.com.
> You're going to want a copy of pskill.exe for sure.
>
> I can't argue against this being easier to do on Linux.
>
> Have you downloaded Cygwin yet?
> http://sources.redhat.com/cygwin/
>
> Paul
Received on Thu Feb 06 2003 - 15:06:01 CST