Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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