|
|
Oracle on Windows Resource Center
Oracle is committed to delivering superior solutions deployed on the Microsoft Windows platform that are cost-effective, reliable, and scalable to customers worldwide. The Oracle database is available on a variety of Windows Server platforms including x64 and Itanium.
|
Oracle Real Application Clusters (RAC) on Windows - Technical Hands-On Workshop Content
Microsoft and Oracle recently co-hosted an Oracle RAC on Windows Server 2003 x64 workshop in Redmond, WA. Jim Olsen, Senior Director of the Oracle Enterprise Technology Centers in North America and Larry Pedigo, Oracle database veteran, Performance Tuning Corporation covered several topics in-depth including Oracle RAC installation, performance tuning and best practices on Windows Server 2003.
Jump to the Following Workshop Categories:
 Windows Server for Oracle Database Administrators (DBAs)
Real Application Clusters (RAC)
Performance and Monitoring
Storage and Backup
Windows Server for Oracle DBAs
Oracle 10g Concepts on Windows
This session gives an excellent overview of Oracle architecture on Windows, specific differences between Oracle on Windows vs. Unix and also covers new features in Oracle 10gR2.
 Read More
 Watch Video
|
Windows Server 2003 Architecture
Saptak Sen, Windows Technical Evangelist, covers the Windows 64 Bit platform, memory and CPU comparison between 32 bit and 64 bit Windows. He also covers x64 Server options i.e. hardware support, compatibility with 32 bit applications. The presentation covers in great depth the performance benefits of database workloads on 64 bit. It covers database architecture on 64 bit hardware and file I/O improvements for Oracle 10gR2 on x64.
Read More
Watch Video
|
Oracle Memory Configuration for Windows
This module covers Oracle Memory configuration for 32 and 64-bit Windows. It covers the boot.ini, /3GB, /PAE and /NOPAE switches in Windows. It also covers Oracle memory configuration and AWE and the performance implications of 32-bit Oracle as well as the advantages of 64-bit Oracle.
Read More
Watch Video
|
Windows Server 2003, Storage and iSCSI
Suzanne Morgan, Program Manger, Windows Core Storage, covers iSCSI 2.0 Key features, Microsoft multipath I/O roadmap, the Microsoft iSCSI Software target that is part of Windows Server 2003 R2, and the planned features for iSCSI in Windows Vista and Longhorn Server.
Read More
Watch Video
|
PowerPoint Presentation: Oracle on Windows
Download and view this PowerPoint file which in which Kevin Ashby discusses Oracle in a Windows environment, including database architecture, systems management, Active Directory and Visual Studio integration, and much more.
Read More
|
RAC Installation on Window Server 2003 Lab
This module provides a comprehensive overview of how to install Oracle Cluster Ready Services and 10gR2 RAC on Windows Server 2003. We walk through the process of preparing servers, configuring public, private and iSCSI Network interfaces, installing database software and patches, performance counters for Windows and testing the install. This module is very comprehensive and contains screenshots for each step.
Read More
Watch Video
|
Oracle Administration and Monitoring Tools for Windows
This module covers Oracle GUI Administration tools for Windows including - Oracle Services Configuration, Event Viewer, Task manager, Windows Performance Monitor, Oracle counters for Windows Performance. It also covers Oracle command line administration tools including SQL Plus, ORADMIN, ORADEBUG, STATSPACK and Automatic Workload Repository Reports.
Read More
Watch Video
|
Monitoring and Testing Oracle I/O in Windows Server Environments
This module covers monitoring the I/O subsystem using perfmon, monitoring using Oracle tools and load testing the I/O subsystem using TTCP.
Read More
Watch Video
|
RAC Best Practices on Window Server
This module showcases some of the best practices of Oracle RAC on Windows Server, including hardware, storage, database layout, maintenance/operations, performance monitoring and analysis, backup and restore policies, Windows Server Optimizations and general Oracle Best Practices on Windows Server.
Read More
Watch Video
|
Top of page
Real Application Clusters (RAC)
Clustering
This module covers clustering concepts in detail. The topics covered include what is clustering and why it is required in database, clustering options, differences between various types of clustering, and factors to consider when choosing a clustering type for your Oracle database on Windows Server.
Read More
Watch Video
|
Oracle 10g RAC Overview
This module provides an introduction to RAC, Cache Fusion, failover and load-balancing, transparent application failover (TAF) and other RAC features.
Read More
|
Oracle 10g RAC Service Architecture
This module covers RAC Services Architecture, Cluster Ready Services (CRS), Nodeapps, User Defined Services, ASM Services, Internally managed Services and monitoring services on Window Server 2003 x54.
Read More
Watch Video
|
Cache fusion
This module covers cache fusion concepts, block transfers using cache fusion and cache fusion recovery.
Read More
Watch Video
|
Oracle 10g RAC Administration with SRVCTL
This module covers SRVCTL command syntax, examples and OCR and CRS administration on Windows Server 2003.
Read More
Watch Video
|
RAC Administration Lab
This lab covers administration concepts for Oracle RAC Administrators on Windows Server 2003.
Read More
|
RAC Networking Lab
This lab covers RAC networking with Windows Server 2003.
Read More
|
RAC Networking and Failover
This module covers how Oracle Net interacts with RAC, how to configure tnsnames for RAC with transparent application failover on Windows Server, how to configure JDBC connections for RAC and how to configure fast connection failover as an alternative to RAC.
Read More
Watch Video
|
RAC Performance Lab
This lab walks through several exercises that cover Oracle Performance tools for Windows Server.
Read More
Watch Video
|
Top of page
Performance and Monitoring
Monitoring and Testing the Network
This module covers how to monitor the network using Window tools, how to monitor the network using Oracle tools and how to load test the network.
Read More
Watch Video
|
Introduction to Performance Issues
This module covers how to resolve performance issues for Oracle on Windows Server. It covers the tools that are available to find and resolve problems, learn what affects system performance and what you should look for when configuring your system.
Read More
Watch Video
|
Top of page
Storage and Backup
Introduction to Storage
This module covers storage basics, introduces Direct Attached Storage, differentiates between Direct, Network Attached, iSCSI and SAN Storage, and introduces fiber channel SANs.
Read More
Watch Video
|
Oracle I/O Topics
This module covers introductory topics including how a disk drive works, understanding disk drive performance and RAID, disk controllers, disk configuration options, read/write mechanisms of the SAN and Oracle, and how these mechanisms affect performance.
Read More
Watch Video
|
Automatic Storage Management
This module is designed to facilitate the understanding of Oracle ASM and its components, how ASM handles disk redundancy and disk groups, ASM directories and files. It also covers ASMCMD command and how OEMs interface with ASM.
Read More
Watch Video
|
Oracle I/O Lab
The I/O Lab covers monitoring tools like perfmon, TTCP and Oracle provided monitoring tools.
Read More
|
Backup and Recovery Options
This module is designed to enable the understanding between off-line and on-line backups, understand how to backup RAC databases and how to do backup with Windows Server.
Read More
Watch Video
|
RMAN Backup and Recovery
This module covers the basic functionality of the Oracle Recovery Manager and how to perform a basic backup and recovery operation using RMAN.
Read More
Watch Video
|
Flashback Technology
This module covers the new flashback technologies in Oracle 10gR2. It is designed to enable understanding of how to use Flashback technology.
Read More
Watch Video
|
Backup and Recovery Lab
This lab has several exercises designed to illustrate backup and recovery of Oracle 10gR2 on Windows Server 2003.
Read More
|
Top of page
|
