Re: Optimal Oracle config/setup for Remedy usage

From: Uwe Schneider <pi_at_richard-schneider.de>
Date: Fri, 12 Nov 1999 18:37:27 +0000
Message-ID: <382C5E67.A3556500@richard-schneider.de>

Hi, man without realname!

It is not very easy to find the question in your posting, but...  

> I have the following platform:
> --Sun Ultra Sparc 250 with as much hard drive as I'd like.
> --Solaris 2.6
> --Oracle 7.3.4 (must used this version)
> --ARS 4.0.3
we have almost the same environment.

>
> I would create one large partition for Oracle, let's say /usr/oraclewhere
> everything for oracle would go. During the installation a would chose the
> following options:
>
> Multi-Protocol Interchange
> Oracle Intelligent Agent 7.3.4.0.0
> Oracle Names 2.0.4.0.0
> Oracle Server Manager (Motif) 2.3.4.0.0
> Oracle Unix Installer 4.0.1.0.0
> Oracle7 Distributed Database Option 7.3.4.0.0
> Oracle7 Parallel Query option 7.3.4.0.0
> Oracle7 Server (RDBMS) 7.3.4.0.1
> Oracle7 XA Library 7.3.4.0.0
> PL/SQL V2 2.3.4.0.0
> Pro*C 2.2.4.0.0
> Spatial Data Option 7.3.4.0.0
> SQL*Module for C 1.1.5.0.0
> SQL*Net (V2) 2.3.4.0.0
> SQL*Plus 3.3.4.0.1
> TCP/IP Protocol Adapter (V2) 2.3.4.0.0

You need the RDBMS and SQL*Net. PL/SQL and SQL*Plus are better for convenience.
Most of these packages are perfectly a waste of space!

>
> That is about the gist of my oracle setup. There after I install Remedy
> and let it create the "temporary tablespace" and "ARSystem tablespace". I
> usually do not have anything else to do with oracle after this.
>

If you can afford more than one disk, distribute ARSYSTEM, ARTMPSPC and redo logs as much as possible.

--

Uwe Schneider       | Telefon +49 7251 / 82587
Karlsdorfer Str. 31 | Mail    pi_at_richard-schneider.de
DE-76646 Bruchsal   | http://www.richard-schneider.de/uwe

Linux - OS al dente! Received on Fri Nov 12 1999 - 12:37:27 CST