Re: Oracle 9i on Win 2K

"Bob Bain" <bob.bain_at_markelintl.com> wrote in message news:<kO4M8.4$Jg.145_at_news.uk.colt.net>...
> OK,
>
> I am looking for information about installing Oracle 9i databases under a
> Win2K environment, we are currently in the planning stage of a Data
> Warehouse and estimate that it will start around the 80G mark and grow to
> beyond 160G.
>
> What we are after really is :-
>
> - If anyone has run into or encountered any problems with databases of this
> size on a Win2K platform
> - Has anyone had problems with installing and running 9i on Win2K
> - Anything else we should be wary of.
>
> Your response and help is much appreciated.
>
> Thanks

Talk with your hardware vendors - server and storage.

Most likely, you are going to use a storage system other than attached SCSI.
That storage vendor should have some test cases with which to give you a baseline with which to compare.

If you're a Compaq/HP shop - they have several proof-of-concept centers available where you should be able to test a similar configuration. If not, talk with the sales dept and get the issue escalated to Technical Sales Support.

Currently, memory is limited to 3 GB for the oracle.exe process (with 4GT, Advanced Server)
You can also cache blocks in memory above 4 GB with PAE, but it comes with increased overhead. If you do not anticipate needing larger than 3 GB of memory total, you may get by running on W2K Server.

If your storage system is cross-platform - you could always nuke the MS OS and use a supported version of Linux (RH Enterprise, SuSE Enterprise).

hth,

Paul Received on Sun Jun 09 2002 - 17:49:15 CDT