RE: Oracle Win NT Configuration Standards

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Wed, 20 Sep 2000 17:27:05 -0700
Message-Id: <10625.117517@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C02362.AD79D1D0
Content-Type: text/plain;

charset="iso-8859-1"

I must admit, I am at a disadvantage because I didn't read his paper. But here are some questions I have in regards to the ability to standardize installations:

Doesn't OFA address issues in naming conventions?
Doesn't common sense dictate that you want to spread I/O out evenly? How can you have a standard on "file locations" when I might have two hard drives and someone else have 20?
"what goes in which tablespace" Assuming that you are meaning "objects in Tablespaces", cannot be standardized, not even SYSTEM.
"what RAID levels are preferred", There is no standards in RAID preference. One might choose not to run on a RAID system. Sean might tell us of the different RAID systems and the pro and cons of them based on the type of database of a certain set of data, but he can't say if you run an OLTP database you should run RAID 50.

Again, naming conventions are covered by OFA, if you need a copy, order it from Oracle. There can be no standard database install. If you believe in a standard base install, you probably believe in an answer to someone's question on "How can I improve my performance on Oracle" or "How do I backup my database".

I've been known to sound mean at times, and I want to let you know that is not my intention. My argument is that there can be no standard base install. If there was a way, then every Joe would be an Oracle DBA and I wouldn't have to work so hard.

Regards,
Satar

P.S. No offense to Sean either, I don't know the guy, but I appreciate his kind intentions.

> -----Original Message-----
> From: Bowes, Chris [SMTP:Chris.Bowes_at_kosa.com]
> Sent: Wednesday, September 20, 2000 10:31 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Win NT Configuration Standards
>
> Well, if by standard base, you mean SGA settings, then no. There is no
> "standard" base. What Sean has is the filenames, locations, data vs index
> vs other file locations and the like. Based upon that definition, then,
> yes, you can have a standard base configuration. His paper (which I read)
> is looking at the OFA layouts, what to name the files, what goes in which
> tablespace, what to name the archive logs, how to mirror, what raid levels
> are preferred, etc. I believe that you can have standards in those areas
> that would cover both the OLTP with 100 users and the DSS with only 5.
>
>
> --Chris
> Chris.Bowes_at_Kosa.com
>
>
>
> -----Original Message-----
> From: Satar Naghshineh
> [mailto:Satar.Naghshineh_at_irvine.mellesgriot.com]
> Sent: Wednesday, September 20, 2000 4:11 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle Win NT Configuration Standards
>
>
>
> Is there a standard database? I mean, don't you think that it is
> impossible to do? Maybe I need an OLTP database with 100 user connection
> and someone else wants a DSS database with 5 connections, etc.
>
> Regards,
> Satar
>
> -----Original Message-----
> From: O'Neill, Sean [SMTP:Sean.ONeill_at_organon.ie]
> Sent: Wednesday, September 20, 2000 3:46 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle Win NT Configuration Standards
>
> Hi Folks,
>
> I've put together a document which specifies configuration
> standard
> guidelines for Oracle on Win NT platform. If anyone would like to
> review it
> I will send it to them backchannel in PDF format for feedback on
> same.
>
>
> Regards,
> Sean :)
>
> ###### ###### ###### ######
> # # # # # # # # Rookie
> #### # # ###### ###### Data
> # # # # # # # # Base
> # # ####### ###### # # Adminstrator
> -------------------------------- ------------
> Organon (Ireland) Ltd.
> E-mail: sean.oneill_at_organon.ie [subscribed: Digest Mode]
>
> The only man who never makes a mistake is the man who never
> does anything.
> - Theodore Roosevelt
>
>
> --
> Author: O'Neill, Sean
> INET: Sean.ONeill_at_organon.ie
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

------_=_NextPart_001_01C02362.AD79D1D0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Oracle Win NT Configuration Standards</TITLE>
</HEAD>
<BODY>

I must admit, I am = at a disadvantage because I didn't read his paper. But here are some = questions I have in regards to the ability to standardize = installations:

1. Doesn't OFA = address issues in naming conventions?

2. Doesn't common = sense dictate that you want to spread I/O out evenly? How can you have = a standard on "file locations" when I might have two hard = drives and someone else have 20?

3. "what goes = in which tablespace" Assuming that you are meaning "objects = in Tablespaces", cannot be standardized, not even SYSTEM. =

4. "what RAID = levels are preferred", There is no standards in RAID preference. = One might choose not to run on a RAID system. Sean might tell us of the = different RAID systems and the pro and cons of them based on the type = of database of a certain set of data, but he can't say if you run an = OLTP database you should run RAID 50.

Again, naming = conventions are covered by OFA, if you need a copy, order it from = Oracle. There can be no standard database install. If you believe in a = standard base install, you probably believe in an answer to someone's = question on "How can I improve my performance on Oracle" or = "How do I backup my database".

I've been known to = sound mean at times, and I want to let you know that is not my = intention. My argument is that there can be no standard base install. = If there was a way, then every Joe would be an Oracle DBA and I = wouldn't have to work so hard.

Regards, Satar

P.S.  No = offense to Sean either, I don't know the guy, but I appreciate his kind = intentions.

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =

SIZE=3D1 FACE=3D"Arial">Bowes, Chris [SMTP:Chris.Bowes_at_kosa.com] Sent:   Wednesday, September 20, 2000 10:31 PM To:     Multiple recipients of list ORACLE-L Subject:       = RE: Oracle Win NT Configuration = Standards

Well, if by standard = base, you mean SGA settings, then no.=A0 There is no =

&quot;standard&quot; base.=A0 What Sean has is the filenames, =
locations, data vs index vs other file locations and the like.=A0 Based =
upon that definition, then, yes, you can have a standard base =

configuration.=A0 His paper (which I read) is looking at the OFA = layouts, what to name the files, what goes in which tablespace, what to = name the archive logs, how to mirror, what raid levels are preferred, = etc.=A0 I believe that you can have standards in those areas that would = cover both the OLTP with 100 users and the DSS with only 5.

=A0

--Chris =

Chris.Bowes_at_Kosa.com

<P><FONT FACE=3D"Arial">=A0</FONT>
</P>
<UL>
<P><FONT SIZE=3D2 FACE=3D"Times New Roman">-----Original =

Message----- 
From: Satar Naghshineh [<A = HREF=3D"mailto:Satar.Naghshineh_at_irvine.mellesgriot.com">mailto:Satar.Nag= hshineh_at_irvine.mellesgriot.com</A>] 
Sent: Wednesday, September 20, 2000 4:11 = PM 
To: Multiple recipients of list = ORACLE-L 
Subject: RE: = Oracle Win NT Configuration Standards

<BR>
</FONT>
</P>

Is there a standard = database?=A0 I mean, don't you think that it is impossible to do?=A0 = Maybe I need an OLTP database with 100 user connection and someone else = wants a DSS database with 5 connections, etc.

Regards, Satar

-----Original Message----- 
From:=A0=A0 O'Neill, Sean = [SMTP:Sean.ONeill_at_organon.ie] Sent:=A0=A0 Wednesday, = September 20, 2000 3:46 PM To:=A0=A0=A0=A0 Multiple = recipients of list ORACLE-L Subject:=A0=A0=A0=A0=A0=A0=A0 Oracle Win NT = Configuration Standards

Hi Folks,

I've put together a document which specifies = configuration standard guidelines for Oracle on Win NT = platform.=A0 If anyone would like to review it 
I will send it to them backchannel = in PDF format for feedback on same.

Regards, Sean :)

######=A0=A0 ######=A0 ######=A0 ###### #=A0=A0=A0 #=A0=A0 #=A0=A0=A0 #=A0 = #=A0=A0=A0 #=A0 #=A0=A0=A0 #=A0 Rookie

</FONT><FONT SIZE=3D2 FACE=3D"Arial">####=A0=A0=A0=A0 #=A0=A0=A0 #=A0 =
######=A0 ######=A0 Data</FONT><FONT FACE=3D"Arial"><BR>
</FONT><FONT SIZE=3D2 FACE=3D"Arial">#=A0=A0 #=A0=A0=A0 #=A0=A0=A0 #=A0 =

#=A0=A0=A0 #=A0 #=A0=A0=A0 #=A0 Base #=A0=A0=A0 #=A0 #######=A0 ######=A0 = #=A0=A0=A0 #=A0 Adminstrator

</FONT><FONT SIZE=3D2 FACE=3D"Arial">-------------------------------- =

------------ 
Organon (Ireland) Ltd. 
E-mail: = sean.oneill_at_organon.ie=A0=A0 [subscribed: Digest Mode]

The only man who never makes a mistake is the man who = never does anything. =A0- Theodore = Roosevelt

-- 
Author: O'Neill, Sean 
=A0 INET: = Sean.ONeill_at_organon.ie

Fat City Network Services=A0=A0=A0 -- (858) 538-5051=A0 = FAX: (858) 538-5051 San Diego, =

California=A0=A0=A0=A0=A0=A0=A0 -- Public Internet access / Mailing =
Lists</FONT><FONT FACE=3D"Arial"><BR>
</FONT><FONT SIZE=3D2 =
FACE=3D"Arial">---------------------------------------------------------=

----------- To REMOVE yourself from this = mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note = EXACT spelling of 'ListGuru') and in the message BODY, include a line = containing: UNSUB ORACLE-L (or the name of mailing list you = Received on Wed Sep 20 2000 - 19:27:05 CDT