RE: MS Server book
- From: "Mark Leith" <mark@xxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Jul 2004 15:39:14 +0100
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@xxxxxxxxxxxxxxxx
http://www.cool-tools.co.uk=20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of DENNIS WILLIAMS
Sent: 06 July 2004 14:54
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx=20
I said it "looked" clear - Riddick
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
bobmetelsky@xxxxxxxxxxx
Sent: Monday, July 05, 2004 5:06 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
