Oracle8: Distributed Database Implementation

Training Method: Instructor Led Training Instructor-led Training

Description:
In this course, participants learn data placement design methods for implementing robust distributed applications and databases. Students gain hands-on experience creating database links for server-server connections as well as read-only snapshots for table replication. Troubleshooting distributed transactions and recovering distributed database is also addressed. In addition, participants identify heterogeneous services in a network environment.

Join our Online Forums
Got a question about this class? Become a member of the Oracle Education Student Union. As a member, you can post your questions in our Online Forums and get an answer!

Register for this Course

Audience:
  • System Administrators
  • Database Administrators
  • Application Developers
  • Designer/Developers

Required Prerequisites:

Suggested Prerequisites:

Course Objectives:

  • Connect multiple systems in a distributed, network environment
  • Monitor transactions and manage database operations in a distributed Oracle Server environment
  • Administer, tune, and troubleshoot a distributed Oracle database
Return to top

Course Topics:

Distributed Systems Overview

  • Distinguish between client/server and server/server configurations
  • List the characteristics of a distributed database environment
  • Discuss the difference between remote and distributed queries and transactions
  • Describe the features of data replication

Implement a Distributed Database

  • List the factors used to determine data location
  • Create and use private and public database links
  • Compare the security issues for public and private database links
  • Create and maintain replicated tables
  • Use snapshots for table replication
  • Describe the features of the Oracle7 Server Advanced Replication option

Monitor Distributed Transactions

  • Identify the sequence of operations during a two-phase commit
  • Describing the function of a system change number
  • Describing the locking mechanism used for distributed transactions
  • Resolve in-doubt distributed transactions
  • Monitoring distributed transactions using data dictionary views

Troubleshoot and Recover a Distributed Database

  • Distinguishing between complete and incomplete recovery of a failed database
  • Perform change-based incomplete recovery of a distributed database

Administer a Remote Database

  • Setting strategies for accessing remote databases
  • Creating reports for monitoring distributed databases
  • Managing passwords and load data in a distributed database environment
Return to top

Suggested Next Courses:
Return to top

Related Courses:
 Return to top