Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: MS Server book

Re: MS Server book

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Tue, 06 Jul 2004 10:04:58 -0400
Message-ID: <BAY2-F10uEzf2HL9OqN00094928@hotmail.com>


Dennis,

Bob has given a nice solutions for Windows related Oracle DBA activities. However just to answer your question, I have seen following 2 books more helpful.

1)Oracle 9i for Windows 2000 Tips and Techniques. This covers a lot of Windows stuff for Oracle.
2)Windows Server 2000 or 2003 by Mark Minasi. This is a good book covering most of Windows Server related stuff as explained by Bob.

Just stop by at Border or B&Nobles and have a look on these books. If you feel that it is good for your reference and reading, order it from bookpool.com or check at amazon.com used books section.

Regards
Rafiq

From: "bobmetelsky_at_comcast.net" <bobmetelsky_at_comcast.net> Reply-To: oracle-l_at_freelists.org
To: oracle-l_at_freelists.org
Subject: Re: MS Server book
Date: Mon, 05 Jul 2004 18:06:14 -0400

DENNIS WILLIAMS wrote:

>Thanks to everyone who has recommended Chris Kempster's ebook SQL Server
>2000 for the Oracle DBA. This book is really a marvel. Since most of my
>professional experience is on Unix, I feel that I need to learn more about
>the MS Server. Can anyone recommend a resource that can get me up to speed
>with what I will need to know about the MS server? It seems that the
>boundary between the system administrator and the DBA isn't as clear as it
>is with Oracle and Unix.
>
>

Hi Dennis

Not to over simplify this but I don’t believe there is such a book as windows 2000 server for the oracle dba. I’m pretty sure most of the administration books would gravitate toward using the server to authenticate uses, manage users, what the various ms services do - how to admin internet information server - how to recover from corrupt registries - domain controllers and he like. From a DBA perspective (my experience is exclusively on NT and 2000 server) there isn’t too much to it. I'd consider the following

Management
Right click my computer choose manage you will find services <-- what services are running
event viewer <-- error log
local users <-- system users

right click on those individual icons and that allows to change the properties

######################

CLI (command line interface)
command interface to run oradim orapwd etc start run cmd

and sqlplusw
start run -->sqlplusw scott/tiger_at_orcl

######################

environment variables
Right click my computer choose properties --> advanced --> env variables setting the path
Right click my computer choose properties --> advanced --> performance options sets the system page file

######################

File locations
During the install oracle will ask you for a home, you choose and area where you want the installation and OFA will live adjacent to that e.g. you choose C:\oracle you will get

C:\oracle\oracleinstall\
C:\oracle\admin\...
C:\oracle\oradata\...

The install will put the binaries in your path and the programs in your program list OEM

######################

Scripting
One thing I’m sure you will be hard pressed to find is a *decent* book on is cmd scripting. I’ve had better luck online

http://www.robvanderwoude.com/index.html
http://www.ipass.net/davesisk/oont_management.htm
http://gearbox.maem.umr.edu/~batch/
http://purl.oclc.org/net/dirk/batcoll.all
http://www.deltaelectronics.com/tglbatch/

misc tools
http://www.tburke.net/info/reskittools/topics/az_body.htm

######################

Registry entries
Start run regedit
Search for oracle

You will find all the install and system configurations. Fairly intuitive.

######################

Editors

Forget notepad
Get a good text editor for sql and CLI scripts http://www.editpadpro.com/download.html

The free version is excellent

######################

I don’t mean to offend any MS SA's but from a dba point of view I really don’t think its gets more complicated than that. Or in the very least the above will get you well on your way. (unless you really want to be a SA which IMO is not at all necessary to admin oracle)

Email me if you have any specific questions, I’d be happy to help. Again, I believe any MS SA book is going to be very general and will not address oracle.

hth
Bob



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

_________________________________________________________________
MSN 9 Dial-up Internet Access helps fight spam and pop-ups – now 2 months 
FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_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
-----------------------------------------------------------------
Received on Tue Jul 06 2004 - 09:01:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US