| |
| |
 |
| |
|
|
| Oracle9i
Real Application Clusters
Regular Track - 3 Days |
| |
| ARCHITECTURE |
- Cluster hardware components
- Nodes
- Interconnect
- Shared disk subsystem
- Cluster software
- Cluster manager
- Inter process communication software
- RAC components
- Disk Acess
- Global service daemon
- Background Processes
- Global enqueue service monitor
- Global engueue service daemon
- Global cache service processes
- LCK process
- Diagnosability Daemon
|
|
| INSTALLATION
& CONVERSION |
- Objectives
- Preliminary cluster preparations
- Cluster files or partitions for default database
- Global services daemon
- Information repository for the database server configuration
- Installations options
- OUI database configuration types
- Addditional installation considerations
- Migrate to Oracle9i RAC
- Convert a single instace to RAC
- Configure hardware
- Evaluate Tablespace Requirements
- Evaluate logfile Requirements
- Create shared file systems or raw devices
- Extract data from old database
- Installation steps
- Create the database
- Load data into the new database
- Adjust parameters
- Start database
- Additional migration considerations
|
|
| MANAGEMENT &
CONFIGURATION TOOLS |
- Objectives
- GSD management
- Server control utility
- SRVCTL command syntax
- SRVCTL cluster database configuration tasks
- Add & delete databases
- Add & delete instances
- Move & rename instances
- Store & remove environment data
- SRVCTL cluster database configuration tasks
- Starting databases & instances
- Stopping databases & instances
- Inspect status of cluster database
- Inspect database configuration information
- Enterprise manager & cluster databases
- Displaying objects in navigator pane
- Starting a database cluster
- Stopping a database cluster
- Status details tab
- Viewing cluster database status
- Job management for a cluster database or instance
- Registering cluster database events
- Parameter files in cluster databses
- Create & manage server parameter parameter file
- Parameter file search order
|
|
| SCALABILITY
& CACHE FUSION |
- Objectives
- Levels of scalability
- Scaleup & speedup
- Speedup & scaleup for different types of workloads
- Load balancing with oracle net services
- Client load balancing
- Connection load balancing
- Service & instance names
- Adaptive parallel query
- Cache fusion
- Cache fusion model
- Global cache service resource modes
- Global cache service resource roles
- Cache fusion block transfers:Example overview
- Example 1 : Read with no transfer
- Example 2 : Read to write transfer
- Example 3 : Write to write transfer
- Example 4 : Write to read transfer
- Block transfers in real application clusters
- Configuring multiblock locks
- Notes on using multiblock locks
|
| |
|
|
|
| |
|
|
| |
|
|
|
|
|