Re: newbie start from scratch

Hi Gijs,
On Oracle 7 for NT the only sensible way to create a database is to use the Oracle Instance Manager which exists both in a command line version and a 'graphical' version (means only a smarter way to enter parameters, no wizard stuff). Supposedly this tool still exists, and will be called oradim80.exe, and can be run both from a command prompt and from the desktop. There is one pitfall to remember: the init<sid>.ora should already exist in <oracle_home>\database, or it won't work. After that you will have specified a password and you should be able to use svrmgr80.

The hardware issue: depends on the type of database, but in a write intensive database RAID5 is generally spoken not recommended. My experience is write rate on NT with RAID5 is much lower compared to say VMS or AIX. This is of course because of the parity check and because of there is no way to tell where your data is located as all volumes usually are striped automatically. Oracle recommends using RAID0 or RAID0+1 instead.
If those clients fire 25 requests per minute, it completely depends upon the efficiency of the sql, and the number of rows returned. It looks like more or less read only, and from your post I can't gather whether those queries are random. If they aren't random, it is more an issue of sufficient cache/SGA than disk io.

Hth,
Sybrand Bakker, Oracle DBA
PS just to share with the group I didn't reply in dutch!

Gijs Wuyts wrote:

> hey,
>
> wanted to start from scracth, no example database, no wizard things,
> want to learn command line stuff first. Installation OK, Installed a
> small DB on a separate disk.
> OS=NT4SP3
> ORA: 8.04 enterprise edition
> Once installed, I started svrmgr80.exe and connected as internal, pw ?
> Oops, first thing. checked manuals, tried everything, from the usual
> to everthing I used at other sites (where everything was running ok
> before i arrived) but no succes. I guess i would have to start by
> creating tablespaces, or should I do something else ?
> I wanna start with command line stuff, GUI stuff is for later.
>
> A hardware question: I will be running my production on a NT4 with A
> Adaptec AAA133SA-RAID adapter and SCSI3 disks, 4.5 GB each. RAID 5.
> Anybody experience with this ?
> The goal is to have a DB backend with 4-5 webserver clients connecting
> to it, possibly with a collective 100 requests/minute. Is this
> performant enough ?
>
> Tnks in advance for any advice or links
>
> Gijs
Received on Tue Sep 22 1998 - 13:35:37 CDT