 |
Experience : | 4 - 9 Years |
|
Location : | United Kingdom (U.K) |
|
Compensation : | U.S Dollars 1,00,000 & above
Very good daily rate plus expenses - Onsite opportunity |
|
Education : | UG - Any Graduate - Any Specialization,Graduation Not Required
PG - Any PG Course - Any Specialization,Post Graduation Not Required |
|
Industry Type : | IT-Software/ Software Services |
|
Functional Area : | ERP, CRM |
|
Posted Date : | 04 Apr |
|
 |
|
Job Description Looking for an instructor to teach the following course
Oracle Database 11g: Implement Streams
Duration: 5 Days
What you will teach
Oracle Streams allows students to share data, messages, and events between schemas, applications, and databases.
This course includes lessons on the fundamental components of Oracle Streams and how to administer each of these
components. The lessons are designed to give students practical experience in configuring and managing a Streams
environment. The course covers enqueue and dequeue messages using Oracle Streams. Also included are best
practice guidelines and troubleshooting practices.
This course counts towards the Hands-on course requirement for the Oracle Database 11g Administrator Certification.
Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on
Requirement. Self Study CD-Rom and Knowledge Center courses DO NOT meet the Hands-on Requirement.
Learn To:Administering a Streams EnvironmentManage Data ConflictsTroubleshoot the Streams EnvironmentConfigure
Streams Environment
Business Intelligence Developer
Database Administrators
Sales Consultants
Support Engineer
Technical Consultant
Prerequisites
Required Prerequisites
Oracle Database 11g: Administration Workshop II
Oracle Database 11g: Administration Workshop I
Suggested Prerequisites
Oracle Database 11g: Administration Workshop I
Oracle Database 11g: Administration Workshop II
Course Objectives
Quickly and easily configure an Oracle Streams environment
Monitor the capture, propagation, and apply of events
Alter the Streams environment to add new sites or objects
Configure conflict handling for data replication
Transform the data being replicated between two sites
Enqueue and dequeue messages using Oracle Streams
Perform basic troubleshooting of a Streams environment
Course Topics
Introduction and Overview
Oracle Streams: Basic Elements
Capture and Event Staging
Copyright © 2009, Oracle. All rights reserved. Page 1Staging Area Propagation
Rules Engine
Oracle Streams with Single-Source and Multiple-Source Database
Oracle Streams Usage: Scenarios
Using Oracle Streams for Upgrades and Migrations
Interfaces to Oracle Streams
Database Configuration
Configuring Database Parameters
Configuring Archive Logging
Supplemental Logging
Database Configuration with Enterprise Manager
Configuring Communication Between Databases
Configuring Multiple Streams Sites
Additional Preparation for File Propagation
Basic Objects of Oracle Streams
Object Types
Streams Events
Logical Change Records (LCRs)
Creating and Managing a Streams Administrator User
Staging Area Architecture
SYS.AnyData Queues
Creating a Staging Queue
View Interface to Queue Buffers
System-Created Rules
Using Rules in Oracle Streams
Generating System-Created Rules
Using Subset Rules with Oracle Streams
Row Subsetting
Customizing System-Created Rules
Negative Rule Sets
Rule Evaluation with Negative Rule Sets
Monitoring Rules
Enterprise Manager Interface to Oracle Streams
Oracle Streams Manageability Features
Configuring Oracle Streams
Streams Setup Page
Streams Tablespace Replication Wizard
Capture Management
Apply Management
Propagation Management
Managing Message Transformations
Simplified Streams Configuration
Simplified Configuration Procedures
Replicating a Single Tablespace (MAINTAIN_SIMPLE_TTS) and a Set of Tablespaces (MAINTAIN_TTS)
Instantiating Database Objects
Replicating Tables, Schemas, and Entire Database
Improved Diagnostics for Streams
Copyright © 2009, Oracle. All rights reserved. Page 2Removing a Streams Queue
Removing All Streams Components
Capture Process Concepts
Capture
Implicit Event Capture
Capture Process Components
Identifying Changes to Capture
Logical Change Records (LCRs)
Data Types, DDL and DML Types Captured
Commands and DDLs Not Captured
Streams Tags and Downstream Capture
Configuring a Capture Process
Creating the Capture Process
Downstream Capture
Capture Process Parameters
Starting and Managing the Capture Process
Monitoring Log File Availability
Capture Process Statistics
Troubleshooting Capture
Instantiation
Performing Instantiation
Preparing for Instantiation
Setting the Instantiation SCN
Import Instantiation and Creation
Instantiation Using Data Pump
Setting the Instantiation SCN Manually
Instantiating a Database Using RMAN
Verifying Instantiations at an Apply Site
Propagation Concepts and Configuration
Directed Networks
Queue and Forwarding
Apply Forwarding
Queue-to-Queue Propagation
Propagation Job, Rules, and Scheduling
Creating, Managing, and Monitoring Propagation
Troubleshooting Propogation Configuration
Apply Concepts and Configuration
Processing Streams Events
Applying DDL Events
Error Queue
Required Apply User Privileges
Apply Process Components and Rules
Enqueue Destination and Execution Directives During Apply
Virtual Dependency Definition
Apply Process and Parameters
Transformations
Copyright © 2009, Oracle. All rights reserved. Page 3Rule-Based Transformations
Declarative LCR Transformations
Customized Rule-Based Transformations
Modifying an LCR
Using LCR Extra Attributes
Creating a Rule-Based Transformation
One-to-many Transformations
Viewing and Managing Rule-Based Transformations
Apply Handlers
Creating an Apply Handler Procedure
Implementing a DML Handler
Creating an Error Handler
Implementing a DDL and a Precommit Handler
Restrictions for Apply Handler Procedures
Managing Apply Handlers
Customizing Apply Handler Actions
Viewing Apply Handler Information
Administering a Streams Environment
Managing the Capture Process
Managing Propagations
Managing Apply Processes
Starting and Stopping Streams Processes
Managing Streams Process Rule Sets
Troubleshooting Apply Failures
Reconfiguring the Streams Environment
Types of Streams Environments
Extending a Single-Source System
Extending a Multiple-Source System
Using Streams for Upgrades or Migrations
Removing Sites and Objects
Data Conflicts
What Is a Replication Conflict?
Error Queue
Types of Data Conflicts
Primary and Substitute Key Columns
Detecting Conflicts
Data Consistency and Convergence
Conflict Avoidance and Resolution Foundation
Site Ownership
Conflict resolution
Prebuilt Conflict Handlers
Resolution Columns
Column Lists
Configuring Supplemental Logging
Resolving Conflicts with Prebuilt and Custom Update Conflict Handlers
Common Data Conflict Errors
Print Values from a SYS.AnyData Type
Copyright © 2009, Oracle. All rights reserved. Page 4Managing Errors
Message Queuing Concepts
Enqueuing Events
Subscriptions and Recipient List
Creating a Messaging Client
Streams Messages with Object Types
Dequeuing Messages in Streams
Message Handlers
Configuring Message Notification and Monitoring Streams Messaging
Queue Management Page
Enqueuing and Dequeing Events
Enqueuing a Message in Streams
Creating User Messages with LCRs
Enqueuing a User-Created LCR
Configuring Propagation of Non-LCR Events
Dequeuing LCRs and Messages
Applying User-Created LCR Events
Configuring Rule-Based Apply of Messages
Purging the Staging Queue
Best Practices and Operational Considerations
Best Practices for Configuring Streams
Archive Logging
Capture Process SCN Values and Checkpoints
Modifying FIRST_SCN and START_SCN
Source Queue Growth
NOLOGGING Operations
Clock Synchronization
Integrating Triggers with Streams
Troubleshooting Oracle Streams
Troubleshooting Capture
Troubleshooting Propagation
Troubleshooting Apply
Common Apply Errors
Troubleshooting Secure Queue Access
|
Desired Candidate Profile Looking for an instructor to carry out some or all of the following courses
Audience:Application Developers
Database Administrators
Developer
Forms Developer
Support Engineer
Technical Administrator
Technical Consultant
Return to top
Prerequisites:Required Prerequisites:
Familiarity with Web-based and client/server applications
Familiarity with application development
Basic Windows or NT navigation and file-management skills
Understanding of basic relational database concepts
Return to top
Course Objectives:Configure a Siebel application
Describe the steps required to install Siebel application software to set up your enterprise
Define your company structure
Describe the Siebel application architecture
Navigate the Siebel application user interface
Populate and migrate data into the Siebel database
Automate business rules in your Siebel application
Secure access to Siebel applications and data
Migrate data between environments
Return to top
Course Topics:Using Siebel CRM
Understanding Siebel Applications
Navigating Siebel Applications
Working with Siebel Data
Controlling Access to Data
Responsibilities and Views
Users, Positions, and Organizations
Implementing the Company Structure
Controlling Access to Customer Data
Controlling Access to Master Data
The Siebel Web Architecture
The Siebel Web Client
The Siebel Enterprise
The Siebel Gateway Name Server
The Siebel Server
The Siebel Web Server Extension
The Siebel Filesystem
The Siebel Database Server
Managing the Siebel Enterprise
Components and Parameters
Server Management
Siebel Client Types
The Siebel Web Client
The Siebel Mobile Web Client
The Siebel Wireless Web Client
The Siebel Handheld Client
The Siebel Developer Web Client
Installation and Security
Securing Access to the Application
Installing Siebel Applications
The Siebel Application Architecture
Siebel Object Types and Object Definitions
The Siebel Data Model
Business Components
Party Business Components
Business Objects
Configuring Siebel Applications
Configuration Strategy
Setting Up a Developer
Managing Object Definitions
Configuring User Interface Objects
Configuring Business Layer Objects
Configuring Data Layer Objects
Automating Business Processes
Siebel Business Services
Building and Testing Siebel Workflows
Deploying and Invoking Siebel Workflows
The Task UI
Creating a Task
Siebel Business Rules
Creating Siebel Business Rules
Assignment Manager
Assignment Rules
Tailoring Assignments
Invoking Assignment Manager
Data Integration
Introducing Enterprise Integration Manager
Creating Data Maps
Running Enterprise Integration Manager
Application Deployment Manager
Introducing Application Deployment Manager
Deploying Application Customizations
|
