Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 


ISBN 10: 
0-9776715-1-8
ISBN 13:
978-0-9776715-1-9
Library of Congress Number: 2013931103
330 pages
Perfect Bind- 9x7
Publication Date: 0113
Shelving:  Databases/Oracle Oracle In-Focus Series #44

  Windows for the Oracle DBA
The Definitive Reference

Mark Sorger

Retail Price $49.95 /  £34.95
 

Order now at 30% off and get access to the code depot! Only $34.95
(30% off)

 

     
Key Features About the Author Reader Comments
Table of Contents Index Topics Errata
     

 


This book will cover all major aspects of Windows system management critical to running Oracle on Windows.  Unlike general system administration books, this book will focus on those tasks most important to Oracle administrators.

The author has broken down the complex subject of Windows administration into easy to digest chapters organized by task.  This makes the subject matter easier to learn and makes it a compelling reference that the reader will go back to for specific information.


 

Key Features

• See how professionals manage Oracle on a Windows server.

• Learn how to automate Oracle tasks with Windows scripts.

• Understand how to build powerful server-side alert mechanisms.

See how to manage data files on a Windows server.
 

 

About the Author:


   Mark Sorger
  Mark Sorger has 32 years of experience in IT. He began as an Application Programmer for Business Applications on RSTS/E and later VAX/VMS. 

He moved on to VAX/VMS System Management, Windows Server administration, and Oracle Database Administration. 

Mark has been an Oracle DBA for 17 years on VMS, Solaris, HP-UX, Windows, and Linux.  He is currently the DBA Lead on a large Government Contract.

 Table of Contents:

Chapter 1 - Introduction to Windows

Why use Windows for Oracle?
A Brief History of Windows
The Threaded Model on Windows
Choosing the Best Release of Windows and Oracle Commonly Used Windows Commands
Directory Commands
Windows File Commands
String Searches in Windows
Summary

Chapter 2 - Windows User and Group Management

About Users and Groups
The Computer Management Screen
Working with Users and Groups
Adding a User
Adding a Group
Adding a User to a Group
Conclusion

Chapter 3 - Windows Performance Monitoring and the Event Viewer

Introduction
Windows Task Manager
Windows Performance Monitor
Adding Counters in the Performance Monitor
Saving Settings to a File
Saving Sessions to a Logfile
Playing Back Monitor Sessions
Windows Event Viewer
Windows 2003 Event Viewer
Windows 2008 Event Viewer
Saving to a CSV Spreadsheet or Other File Type
Summary

Chapter 4 - The Windows Registry

Introduction
Functionality of the Windows Registry
Running the Registry Editor
Taking a Backup of the Registry Keys
Restoring an Individual Key from an Export
Oracle Related Registry Entries
Summary

Chapter 5 - Oracle-related Environment Variables

Introduction
Where to find Windows Environment Variables
The Windows PATH Variable
ORACLE_HOME
Checking for ORACLE_HOME
Using ORACLE_SID in Windows
Finding TNSNAMES.ORA Location
Summary

Chapter 6 - Windows Services

Introduction to Windows Services
Services via the System Management Console
The Windows Properties Screen / General Tab
Automatic Startup of Oracle on Windows
Properties Screen / Log On Tab
Controlling Services Using the net Command
Controlling Services Using the sc Command
Summary

Chaper 7 - Windows Batch Jobs

Introduction Batch Jobs
Using the Windows Task Scheduler (Windows 2003
Batch Jobs Using the Windows Task Scheduler (Windows 2008)
Scheduling Windows Batch Jobs to be Triggered by System Events
Scheduling Windows Batch Jobs to be Triggered by Dates and Times
Batch Jobs Using the schtasks Command
Batch Jobs Using the at Command
Summary

Chapter 8 - Network Commands on Windows

Introduction
Using ipconfig to get your TCP/IP Address
Using the netstat –an Command
Using ping to see if a Server is Responding
Using nslookup to get the TCP/IP Address
Using tracert to get the Path/Route Server
Connecting to a Device on a Remote Server
The hostname Command
A Word About IIS and FTP
Summary

Chapter 9 - Killing Windows Processes

Using the Task Manager to Kill a Process
Killing Processes Using taskkill
Killing Stuck Services Using sc queryex and taskkill
Summary

Chapter 10 - Windows Installs and Upgrades

Introduction
Stopping Oracle Related Services
Stopping the Windows Distributed Transaction Coordinator Service
Stopping the Windows Management Instrumentation Service (Oracle 11gR2)
Stopping Antivirus or Backup Software
Using tasklist /m to Find the Owner of Open DLLs
A Note About the ORACLE_HOME Environment Variable
The Last Product Installed Will be the First in the PATH
A Note on Installing a New Listener
Open DLLs – When All Else Fails…
Summary

Chapter 11- Managing Oracle on Windows Using ORADIM

Introduction
ORADIM
The net stop and net start Commands
How to Cleanly Shut Down Your Oracle Database When Windows is Shut Down
Summary

Chapter 12 - Shell Scripting Basics

Introduction
Commenting on Code
The goto Command
Redirecting Output to a File
The findstr and find Commands
The forfiles Command
How to Rename or Datestamp Files
How to Sleep
Two Handy Utilities
Putting it all together
Summary

Chapter 13 - Windows Shell Scripts

Introduction
Oracle Shutdown Script for Windows
Oracle Startup Script for Windows
Rotate SQL*Net Logs – Stopping the Listener
Rotate SQL*Net Logs – Not Stopping the Listener
Data Pump Export
Check Oracle Alert Logs for ORA-
Checking for a Running Service
Purge Audit Tables
Oracle Cold Backups on Windows
Summary

Chapter 14 - Miscellaneous Things That Had No Category

Introduction
The net file Command
Windows 2008 UAC
ODBC on 64 Bit Machines
Simple Table of UNIX to Windows Commands
What to do if an EXE Will Not Run
The net statistics server Command
The systeminfo Command
Oracle Fail Safe
Organizing Oracle Files – OFA on Windows
Summary

Index:

Reader Comments:

Errata:

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks