Re: Oracle on NT vs Unix

Neilc wrote:
>
> hi,
>
> I have quite a bit of experience installing and administering databases
> on unix, but I am now being asked to install and configure databases on
> NT.
> What I would like to know is this :-
>
> On unix, you typically create an account (e.g. oracle) and a group (e.g.
> dba) and use that account to install the software, create the database
> and often administer the database afterwards.
>
> Do you do the same sort of approach on NT ? Would you create a group (is
> there the same concept ?) and an account to install the software ?
> what privileges / permissions should the account have ?
> Can you create the database using scripts, or is there a wizard of some
> kind ?
>
> This will be version 7.34 and 8.0.5 initially, and then version 8.1.5
> Running on a NT4 server (probably compaq)

Follow the same procedures for creating the Oracle user and group on NT as you do in Unix (use user manager to create them) and go about installing oracle as per Unix. As for wizards, there is dbassist on 8i (this applies to all versions, not just the NT version) that will allow you to easily create databases. As for previous versions, just issue the usual create database command and you will be fine.

One quick addendum - if you are using NT as a db server, make sure that the database is the only thing running on it. NT can be stable, if you know how to admin it, and if you don't run *anything* but the intended application on it.

Cheers,
GC

Cheers,
GC Received on Mon Feb 21 2000 - 19:07:32 CST