From oracle-l-bounce@freelists.org Tue Jul 6 09:33:17 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i66EX1N20636 for ; Tue, 6 Jul 2004 09:33:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i66EWp620594 for ; Tue, 6 Jul 2004 09:33:01 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3D2BC72C805; Tue, 6 Jul 2004 09:14:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 00518-96; Tue, 6 Jul 2004 09:14:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3686F72C814; Tue, 6 Jul 2004 09:14:24 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 06 Jul 2004 09:12:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BF82172C6C8 for ; Tue, 6 Jul 2004 09:12:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32480-100 for ; Tue, 6 Jul 2004 09:12:52 -0500 (EST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.184]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2865B72C84B for ; Tue, 6 Jul 2004 09:12:52 -0500 (EST) Received: from [212.227.126.208] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1Bhr3e-0004mC-00 for oracle-l@freelists.org; Tue, 06 Jul 2004 16:36:30 +0200 Received: from [62.69.73.48] (helo=mark) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1Bhr3d-0003pJ-00 for oracle-l@freelists.org; Tue, 06 Jul 2004 16:36:29 +0200 From: "Mark Leith" To: Subject: RE: MS Server book Date: Tue, 6 Jul 2004 15:39:14 +0100 Organization: Cool-Tools UK Limited Message-ID: <001201c46367$02bdf000$0a01a8c0@mark> MIME-Version: 1.0 Content-type: text/plain; charset=Windows-1252 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2616 In-Reply-To: <0186754BC82DD511B5C600B0D0AAC4D607B00954@EXCHMN3> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:b84f750678d1b190d66395c4009b4b4f X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4480 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mark@cool-tools.co.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Dennis,=20 A service is basically a process that you can set to start automatically on system start up. You can also set service dependencies (e.g. ServiceA needs to be running before ServiceB can start). Services - as opposed to application processes - don=92t need a UI to run. Think of them as UNIX daemon processes.=20 You need to know how to start/stop them (Control Panel/Administrative Tools/Services menu), and you should also be aware of who the service runs as.. Most run as "LocalSystem", sometimes you have to switch these to a user with "Administrator" privileges.=20 You can *sometimes*, not very often, get registry corruptions. The registry is basically a "database" of application or service settings - like settings stored in config files in /etc for system wide (HKEY_LOCAL_MACHINE), or /home/username (HKEY_CURRENT_USER) for the current user. Also possibly like the rpm database. As Bob mentioned you get at the registry by running regedit from the Run command on the Start menu. It's probably a good idea to export a copy for a backup, or before trying to "hack" it ;) In NT/2K environments, there is a "quick tweak" that can be set to make Windose optimise performance for either Applications (those with a GUI) or Background Services (as above). You can get at this in the Control Panel/System tool, under the Advanced tab, click the Performance Options button and set it for Background. You can also set you "Pagefile" (think swap space) from there too. The general rule is install the OS and any drivers that you need, install the database and *leave it alone*!! ;) The big problem with Windows stability is new patches and drivers and apps that just seem to get installed willy nilly on Windows systems - a lot of the time requiring a reboot.=20 Set the screen saver to "None" - and use the "Power" options to turn the monitor off after x minutes under the Display Properties (right click on the desktop - Properties menu).=20 HTH Mark Mark Leith Cool-Tools UK Limited Tel: 01905 330 281 Fax: 08701 275 283 mark@cool-tools.co.uk http://www.cool-tools.co.uk=20 -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of DENNIS WILLIAMS Sent: 06 July 2004 14:54 To: 'oracle-l@freelists.org' Subject: RE: MS Server book Bob - Thanks for your excellent reply. My problem is not knowing what I don't know. Your input is encouraging (as always), that maybe there isn't that much to it. And thanks for the excellent tips. - I'm not insisting on W2K for the Oracle DBA, although if the market supports a couple of Unix for the Oracle DBA, you'd think one for MS2K would not be unreasonable. - So far we've been able to keep Oracle on Unix, but like many of you, I'm being asked to start supporting SQL Server. On the wide variety of platforms it supports (joke). - I'm thinking maybe there is a MS2K book that has a few pertinent chapters. Specific topics that concern me are: - What the heck is a service and what do I need to know? - I keep hearing about the registry and how it can mess you up. - Earlier NT systems needed to be reconfigured to support databases well. Is that still true? Is there a checklist to ensure a W2K is configured for SQL Server or Oracle? How do you ensure half the CPU isn't devoted to the screen server? Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com=20 I said it "looked" clear - Riddick -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of bobmetelsky@comcast.net Sent: Monday, July 05, 2004 5:06 PM To: oracle-l@freelists.org Subject: Re: MS Server book DENNIS WILLIAMS wrote: >Thanks to everyone who has recommended Chris Kempster's ebook SQL=20 >Server 2000 for the Oracle DBA. This book is really a marvel. Since=20 >most of my professional experience is on Unix, I feel that I need to=20 >learn more about the MS Server. Can anyone recommend a resource that=20 >can get me up to speed with what I will need to know about the MS=20 >server? It seems that the boundary between the system administrator and >the DBA isn't as clear as it is with Oracle and Unix. > =20 > Hi Dennis Not to over simplify this but I don't believe there is such a book as=20 windows 2000 server for the oracle dba. I'm pretty sure most of the=20 administration books would gravitate toward using the server to=20 authenticate uses, manage users, what the various ms services do - how=20 to admin internet information server - how to recover from corrupt=20 registries - domain controllers and he like. From a DBA perspective (my=20 experience is exclusively on NT and 2000 server) there isn't too much to it.=20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.711 / Virus Database: 467 - Release Date: 25/06/2004 =20 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.711 / Virus Database: 467 - Release Date: 25/06/2004 =20 ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------