Re: Oracle 7.3.2 Architecture

1.) They all seem like more or less similar transaction oriented applications and since they need to share data, one instance seems appropriate. I would advise 4K block size, more spindles in more mirrored sets and to keep redo log files separate from all other I/O activtity. You definetely want to operate in archive log mode.

2.) I probably shouldn't ask "why" you want to change the SID. If it's just for show then use a sql*net alias to call it whatever you want. I wouldn't use the default database ORCL, create your own using the instance manager with a customized init.ora to build the database the way you want it.

3.) I haven't encountered any Oracle server book written specifically for NT. Oracle's Release 7.3 for Windows NT Getting Started #A48503-1 has most of the OS specific info that you would need. Combine this manual with Kevin Loney's DBA Handbook and Velpuri's Backup and Recovery Handbook and you'll cover just about everything. Oracle Troubleshooting also by Velpuri, and Adkoli has a small, relatively useless (if you already have the above books) chapter devoted to Preventive Maintenance on NT.

Craig M. Wall

Michael Reeves wrote in message <6em6q6$5mt_at_news9.noc.netcom.net>...
>I have 2 questions dealing with the design and layout of an Oracle 7.3.2
>database. If I could get some direction from anyone, it would be greatly
>appreciated.
>
>Environment:
>Windows NT 4.0 with Service Pack 3.
>Oracle WorkGroup Server Version 7.3.2.3.1 for Windows NT
>Micron Dual (300mhz chip) machine with 512 mg RAM &
>5 Mirrored disks sets (10 disks total with a hardware RAID mirroring disks)
>
>1:) We will have a number of applications accessing our database. We will
>have an accounting, a help desk, a reservation system, and a sales
>application running together. What is the easiest layout. Do we need to
 have
>multiple instances, each running their own application or should we just
>have one instance. The traffic should not be very heavy, (6 people in
>accounting, 10 people in the help desk app., 12 people in reservations, and
>12 people in the sales app.) and all of the applications will need to share
>data.
>
>2:) I have loaded Oracle onto our server. I have run the following scripts:
>catalog.sql, catproc.sql, smpupg01.sql, and cre.sql. When I attempt to
>change the SID, I can not connect to the database again. I get the
 following
>error: ORA-09352: Windows 32-bit Two-Task driver unable to spawn new Oracle
>task. I am attempting to change the SID via the registry editor from:
>HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE, ORACLE_SID:REG_EXPAND-SZ:ORCL to the
>following: HKEY_LOCAL_MACHINE, SOFTWARE, ORACLE,
>ORACLE_SID:REG_EXPAND-SZ:CA. Am I missing a fundamental step or do I need
 to
>leave the SID as ORCL?
>
>3:) Does anyone know of a good Oracle Server book specifically written for
>Windows NT?
>
>I really appreciate anyone's response.
>
>Gratefully
>Michael Reeves
>mreeves_at_yourcall.com
>
>
>
>
Received on Tue Mar 17 1998 - 00:00:00 CST