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