AW: Oracle Win NT Configuration Standards

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Thu, 21 Sep 2000 10:31:24 +0200
Message-Id: <10626.117541@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_01C023A6.544B7980

Content-Type: text/plain;

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

Hi Satar,
=20
I think you should read Seans document, cause I also think you can = define
some standards for installing Oracle Databases. For example:
-file locations
-naming conventions
-NT settings
-prefered RAID configuration

=20
I know that this "standards" couldn't be used evertime, but such a = document
is a checklist where to look for.
=20
Regards

Volker Sch=F6n=20
E-Mail: mailto:v.schoen_at_inplan.de <mailto:v.schoen_at_inplan.de> =20 http://www.inplan.de <http://www.inplan.de/> =20

-----Urspr=FCngliche Nachricht-----

Von: Satar Naghshineh [mailto:Satar.Naghshineh_at_irvine.mellesgriot.com] Gesendet: Thursday, September 21, 2000 3:40 AM An: Multiple recipients of list ORACLE-L Betreff: RE: Oracle Win NT Configuration Standards

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?=20
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.=20
"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.=20

Regards,
Satar=20

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

-----Original Message-----=20
From: Bowes, Chris [SMTP:Chris.Bowes_at_kosa.com]=20 Sent: Wednesday, September 20, 2000 10:31 PM=20

To:     Multiple recipients of list ORACLE-L=20
Subject:        RE: Oracle Win NT Configuration Standards=20

	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.

=20

--Chris
Chris.Bowes_at_Kosa.com=20

=20

-----Original Message-----
From: Satar Naghshineh [ mailto:Satar.Naghshineh_at_irvine.mellesgriot.com <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=20

-----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=20

	        Hi Folks,=20

	        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.=20

Regards,
Sean :)=20

	        ######   ######  ######  ######
#    #   #    #  #    #  #    #  Rookie
####     #    #  ######  ######  Data
#   #    #    #  #    #  #    #  Base
#    #  #######  ######  #    #  Adminstrator


-------------------------------- ------------

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

The only man who never makes a mistake is the man who never does anything.

Theodore Roosevelt=20

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

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).=20

------_=_NextPart_001_01C023A6.544B7980

Content-Type: text/html;

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

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

charset=3Diso-8859-1">
<TITLE>RE: Oracle Win NT Configuration Standards</TITLE>

<META content=3D"MSHTML 5.00.3018.900" name=3DGENERATOR></HEAD>
<BODY>
<DIV><FONT color=3D#0000ff face=3DArial size=3D2><SPAN =

class=3D446422708-21092000>Hi=20
Satar,</DIV>
<DIV><SPAN=20 class=3D446422708-21092000> </DIV> <DIV>I=20
think you should read Seans document, cause I also think you can define = some=20
standards for installing Oracle Databases. For = example:</DIV>
<DIV>-file=20
locations</DIV>
<DIV><SPAN=20 class=3D446422708-21092000>-naming conventions</DIV> <DIV>-NT=20
settings</DIV>
<DIV><SPAN=20 class=3D446422708-21092000>-prefered RAID = configuration</DIV>
<DIV><SPAN=20 class=3D446422708-21092000> </DIV> <DIV>I know=20
that this <SPAN=20
class=3D446422708-21092000>"standards" couldn't be used evertime, but = such a=20
document is a checklist where to look for.</DIV> <DIV><SPAN=20 class=3D446422708-21092000> </DIV> <DIV><SPAN=20 class=3D446422708-21092000>Regards</DIV> Volker Sch=F6n = <FONT=20
color=3D#000000 face=3DArial size=3D2>E-Mail: <A=20
href=3D"mailto:v.schoen_at_inplan.de">mailto:v.schoen_at_inplan.de</A><= /U>=20
 <A = href=3D"http://www.inplan.de/"=20
target=3D_blank>http://www.inplan.de</A> <BLOCKQUOTE>
 <DIV align=3Dleft class=3DOutlookMessageHeader dir=3Dltr>-----Urspr=FCngliche Nachricht----- Von: Satar = Naghshineh=20
 [mailto:Satar.Naghshineh_at_irvine.mellesgriot.com] Gesendet: = Thursday,=20
 September 21, 2000 3:40 AM An: Multiple recipients of list=20 ORACLE-L Betreff: RE: Oracle Win NT Configuration=20 Standards </DIV>
 I must admit, I am at = a disadvantage=20
 because I didn't read his paper. But here are some questions I have = in regards=20
 to the ability to standardize installations: 1. Doesn't OFA address = issues in=20
 naming conventions? 
 2. Doesn't common = sense dictate that=20
 you want to spread I/O out evenly? How can you have a standard on = "file=20
 locations" when I might have two hard drives and someone else have=20 20?
 3. "what goes in which = tablespace"=20
 Assuming that you are meaning "objects in Tablespaces", cannot be=20 standardized, not even SYSTEM. 4. "what RAID levels = are preferred",=20
 There is no standards in RAID preference. One might choose not to run = on a=20
 RAID system. Sean might tell us of the different RAID systems and the = pro and=20
 cons of them based on the type of database of a certain set of data, = but he=20
 can't say if you run an OLTP database you should run RAID = 50.
 Again, naming = conventions are covered=20
 by OFA, if you need a copy, order it from Oracle. There can be no = standard=20
 database install. If you believe in a standard base install, you = probably=20
 believe in an answer to someone's question on "How can I improve my=20 performance on Oracle" or "How do I backup my database". I've been known to = sound mean at=20
 times, and I want to let you know that is not my intention. My = argument is=20
 that there can be no standard base install. If there was a way, then = every Joe=20
 would be an Oracle DBA and I wouldn't have to work so hard. = 
 Regards, Satar 
 P.S.  No offense = to Sean either,=20
 I don't know the guy, but I appreciate his kind intentions. = 
 <UL>
 -----Original Message----- = <FONT=20

face=3DArial size=3D1>From:   <FONT = face=3DArial=20

size=3D1>Bowes, Chris [SMTP:Chris.Bowes_at_kosa.com] = <FONT=20

face=3DArial size=3D1>Sent:   <FONT = face=3DArial=20

size=3D1>Wednesday, September 20, 2000 10:31 PM <FONT = face=3DArial=20

size=3D1>To:     Multiple recipients of list ORACLE-L <FONT =

face=3DArial=20
    =
size=3D1>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> =

<FONT=20

face=3DArial size=3D1>RE: Oracle Win NT Configuration = Standards

Well, if by standard = base, you mean=20

SGA settings, then no.  There is no "standard" base.  = What Sean=20

has is the filenames, locations, data vs index vs other file = locations and=20

the like.  Based upon that definition, then, yes, you can have = a=20

standard base configuration.  His paper (which I read) is = looking at=20

the OFA layouts, what to name the files, what goes in which = tablespace, what=20

to name the archive logs, how to mirror, what raid levels are = preferred,=20

etc.  I believe that you can have standards in those areas = that would=20

cover both the OLTP with 100 users and the DSS with only = 5.

--Chris <FONT=20

face=3DArial size=3D2>Chris.Bowes_at_Kosa.com

<UL>

      <P><FONT face=3D"Times New Roman" size=3D2>-----Original=20
      Message-----<BR></FONT><B><FONT face=3D"Times New Roman"=20
      size=3D2>From:</FONT></B><FONT face=3D"Times New Roman" size=3D2> =
Satar=20
      Naghshineh [</FONT><U><FONT color=3D#0000ff face=3D"Times New =
Roman" size=3D2><A=20
      =

href=3D"mailto:Satar.Naghshineh_at_irvine.mellesgriot.com">mailto:Satar.Nag= hshineh_at_irvine.mellesgriot.com</A><FONT=20

face=3D"Times New Roman" size=3D2>] <FONT = face=3D"Times New Roman"=20

size=3D2>Sent: = Wednesday,=20

September 20, 2000 4:11 PM <FONT face=3D"Times New = Roman"=20

size=3D2>To: = Multiple=20

recipients of list ORACLE-L <FONT face=3D"Times New = Roman"=20

size=3D2>Subject: RE: Oracle=20

      Win NT Configuration Standards<BR><BR></FONT></P>
      <P><FONT color=3D#0000ff face=3DArial size=3D2>Is there a =
standard=20
      database?&nbsp; I mean, don't you think that it is impossible to =
do?&nbsp;=20
      Maybe I need an OLTP database with 100 user connection and =
someone else=20
      wants a DSS database with 5 connections, etc.</FONT></P>
      <P><FONT color=3D#0000ff face=3DArial =
size=3D2>Regards,<BR>Satar</FONT><FONT=20
      face=3DArial> </FONT></P>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial=20
      size=3D1>-----Original Message-----</FONT><FONT=20
      face=3DArial><BR></FONT><B><FONT face=3DArial=20
      size=3D1>From:&nbsp;&nbsp;</FONT></B><FONT face=3DArial> =
</FONT><FONT=20
      face=3DArial size=3D1>O'Neill, Sean =
[SMTP:Sean.ONeill_at_organon.ie]</FONT><FONT=20
      face=3DArial><BR></FONT><B><FONT face=3DArial=20
      size=3D1>Sent:&nbsp;&nbsp;</FONT></B><FONT face=3DArial> =
</FONT><FONT=20
      face=3DArial size=3D1>Wednesday, September 20, 2000 3:46 =
PM</FONT><FONT=20
      face=3DArial><BR></FONT><B><FONT face=3DArial=20
      size=3D1>To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B><FONT =
face=3DArial>=20
      </FONT><FONT face=3DArial size=3D1>Multiple recipients of list=20
      ORACLE-L</FONT><FONT face=3DArial><BR></FONT><B><FONT =
face=3DArial=20
      =

size=3D1>Subject:       <F= ONT=20
face=3DArial> Oracle Win NT = Configuration=20

      Standards</FONT><FONT face=3DArial> </FONT></P>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial =
size=3D2>Hi=20
      Folks,</FONT><FONT face=3DArial> </FONT></P>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial =
size=3D2>I've=20
      put together a document which specifies configuration =
standard</FONT><FONT=20
      face=3DArial><BR></FONT><FONT face=3DArial size=3D2>guidelines =
for Oracle on Win=20
      NT platform.&nbsp; If anyone would like to review it</FONT><FONT=20
      face=3DArial><BR></FONT><FONT face=3DArial size=3D2>I will send =
it to them=20
      backchannel in PDF format for feedback on same.</FONT><FONT =
face=3DArial>=20
      </FONT></P><BR>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial=20
      size=3D2>Regards,</FONT><FONT face=3DArial><BR></FONT><FONT =
face=3DArial=20
      size=3D2>Sean :)</FONT><FONT face=3DArial> </FONT></P>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial=20
      size=3D2>######&nbsp;&nbsp; ######&nbsp; ######&nbsp; =
######</FONT><BR><FONT=20
      face=3DArial size=3D2>#&nbsp;&nbsp;&nbsp; #&nbsp;&nbsp; =
#&nbsp;&nbsp;&nbsp;=20
      #&nbsp; #&nbsp;&nbsp;&nbsp; #&nbsp; #&nbsp;&nbsp;&nbsp; #&nbsp;=20
      Rookie</FONT><FONT face=3DArial><BR></FONT><FONT face=3DArial=20
      size=3D2>####&nbsp;&nbsp;&nbsp;&nbsp; #&nbsp;&nbsp;&nbsp; #&nbsp; =

      ######&nbsp; ######&nbsp; Data</FONT><FONT =
face=3DArial><BR></FONT><FONT=20
      face=3DArial size=3D2>#&nbsp;&nbsp; #&nbsp;&nbsp;&nbsp; =
#&nbsp;&nbsp;&nbsp;=20
      #&nbsp; #&nbsp;&nbsp;&nbsp; #&nbsp; #&nbsp;&nbsp;&nbsp; #&nbsp;=20
      Base</FONT><BR><FONT face=3DArial size=3D2>#&nbsp;&nbsp;&nbsp; =
#&nbsp;=20
      #######&nbsp; ######&nbsp; #&nbsp;&nbsp;&nbsp; #&nbsp;=20
      Adminstrator</FONT><FONT face=3DArial><BR></FONT><FONT =
face=3DArial=20
      size=3D2>-------------------------------- =


------------</FONT><BR><FONT=20

      face=3DArial size=3D2>Organon (Ireland) Ltd.</FONT><FONT=20
      face=3DArial><BR></FONT><FONT face=3DArial size=3D2>E-mail:=20
      sean.oneill_at_organon.ie&nbsp;&nbsp; [subscribed: Digest =
Mode]</FONT><FONT=20
      face=3DArial> </FONT></P>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial =
size=3D2>The=20
      only man who never makes a mistake is the man who never does=20
      anything.</FONT><FONT face=3DArial><BR></FONT><FONT face=3DArial=20
      size=3D2>&nbsp;- Theodore Roosevelt</FONT><FONT face=3DArial> =
</FONT></P><BR>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial=20
      size=3D2>--</FONT><BR><FONT face=3DArial size=3D2>Author: =
O'Neill,=20
      Sean</FONT><FONT face=3DArial><BR></FONT><FONT face=3DArial =
size=3D2>&nbsp;=20
      INET: Sean.ONeill_at_organon.ie</FONT><FONT face=3DArial> =
</FONT></P>
      <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3DArial =
size=3D2>Fat=20
      City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; =
FAX: (858)=20
      538-5051</FONT><FONT face=3DArial><BR></FONT><FONT face=3DArial =
size=3D2>San=20
      Diego, California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- =
Public=20
      Internet access / Mailing Lists</FONT><FONT =
face=3DArial><BR></FONT><FONT=20
      face=3DArial=20
      =
size=3D2>---------------------------------------------------------------=


-----</FONT><FONT=20

      face=3DArial><BR></FONT><FONT face=3DArial size=3D2>To REMOVE =
yourself from this=20
      mailing list, send an E-Mail message</FONT><FONT=20
      face=3DArial><BR></FONT><FONT face=3DArial size=3D2>to: =
ListGuru_at_fatcity.com=20
      (note EXACT spelling of 'ListGuru') and in</FONT><FONT=20
      face=3DArial><BR></FONT><FONT face=3DArial size=3D2>the message =

BODY, include a=20 Received on Thu Sep 21 2000 - 03:31:24 CDT