Re: Architecture Question

From: Dave <dave_at_foobar.com>
Date: Mon, 05 Jul 1999 01:14:52 GMT
Message-ID: <378004e9.432670597@news.mindspring.com>

Paul,
Here's one option:

Install a separate development server with enough horsepower to serve your developers which shouldn't require as much as the production server will eventually require. Each developer can have a .profile to the box with his/her ORACLE_SID. They'll have access to svrmgrl, all of the PL/SQL packages, etc. Each should be able to create his/her test database, start/stop the database, etc. from their desktop workstations. Notice, this wouldn't require any installations on their local boxes.

Another (less attractive) option:
Configure each workstation for dual boot with Win NT. Install Oracle for NT on each box and let them play, design, reboot, etc. to their hearts' content.

Personally, I'd go for the formal dev. server. If you got an E4500 (say) for your production OLTP app, consider scaling back to an E450 for your dev/test box. If you go with a separate development box, memory (RAM) and cpu number will be important to keep your developers happy. Also, with Oracle, it is better to use many smaller drives than a single great-big-drive. And NEVER use Sun's Software RAID for an OLTP app! Learn about OFA (Optimal Flexible Architecture).

Good luck,
Dave

On Sun, 4 Jul 1999 07:59:09 +0100, "Paul" <vmayada_at_ibm.net> wrote:

> I'm designing an architecture for my software team. The application is a
> high throughput OLTP internet database. I have chosen to run Oracle 8i
> running on a Sun Sparc Server with Solaris for the database server.
>
> However, I wish to stick with Intel hardware running Solaris for the
> developer's workstations. The development environment will therefore
> consist of Intel boxes with Solaris connected to the Sparc Server running
> Oracle.
>
> My concern is, Oracle can only run on Sparc Solaris. How will my developers
> interact with the Oracle database on their Intel workstations.
>
> Is such an archiecture feasible?
>
> Thanks
>
> Paul
>
>
>
>

+---------------------+---------------+

|nojunkmail_at_nospam.com| mindspring.com| |nospam_at_nojunkmail.com| davegrantier@ |

+---------------------+---------------+

Received on Sun Jul 04 1999 - 20:14:52 CDT