خدمات داده‌های جهانی اوراکل برای سیستم‌های حیاتی: حداکثر کردن عملکرد و قابلیت اطمینان در محیط‌های پیچیده سازمانی

Table of Contents About the Authors About the Technical Reviewer Acknowledgments Introduction Foreword Chapter 1: Introduction to Oracle Global Data Services GDS Components GDS Features Configuration Best Practices of GDS in Maximum Availability Architecture Global Services and Distributed Transactions Global Services in Multitenant Architecture Global Service Failover Details GDS Restrictions, License, and Compatibility Troubleshooting Summary Chapter 2: Introduction to Oracle Sharding What Is Sharding? Benefits of Sharding Sharding High Availability Sharding Methods GDSCTL Commands Used for Oracle Sharding Oracle Sharding Workshop Configuration Steps Installing the GSM Software Creating the Catalog Database Setting Up the GDS Administrator Accounts and Privileges Creating the Shard Catalog Creating the Global Service Manager Setting Up a TNS Entry on the Catalog Creating the Operating System Credentials Registering and Starting the Scheduler Agents on Shards Creating the Regions and Shard Groups Setting Up Valid Node Checking for Registration Creating Directories on Shards Creating a Shard Template for DBCA Creating Shards Reviewing the Configuration Configuring the TNS Entries for Shards Running the Deployment Reviewing the Deployment Configuring Global Services Verifying the Data Guard Broker Configuration Creating the Schema for Testing Verifying the Data Distribution Troubleshooting Problem 1 Workaround Problem 2 Workaround Problem 3 Solution Problem 4 Solution Problem 5 Solution Problem 6 Solution Problem 7 Solution Problem 8 Solution Problem 9 Solution Problem 10 Solution Problem 11 Solution: Problem 12 Solution: Problem 13 Solution Problem 14 Solution Summary Chapter 3: Monitoring Oracle GDS and Oracle Sharding Configuring EM Agents Installing Agents on Hosts Configuring Autodiscovery Discovering the Shard Catalog Database in Enterprise Manager Reviewing Sections Related to Sharding Managing Chunks Troubleshooting Problem Reason Solution Summary Chapter 4: Installing a Global Service Manager Setting Up the Environment First Physical Standby Database Server Second Physical Standby Database Server Prerequisites Linux Package Requirements Space Requirements Ports Requirements Downloading the Global Service Manager Software Unzipping the Global Data Service Manager Binaries Installing the Oracle Global Data Service Manager Creating the Oracle Home Directory for the Global Service Manager Invoking the Oracle Universal Installer Global Service Manager in Primary Database Server Global Service Manager in Physical Standby Database Server Using GDSCTL Summary Chapter 5: Configuring and Administering Oracle GDS Setting Up the Environment Primary Database Version and the Patch Set Physical Standby Database Server First Physical Standby Database Server Second Physical Standby Database Server About GDSCTL Connecting to the GDSCTL Utility Overview of the GDS Catalog Primary Catalog Database Details Standby Catalog Database Details Creating the GDS Catalog About the GSMCATUSER Account Registering the GSM to the GDS Catalog Starting All the Global Service Managers Starting gsmeast Adding a GDS Pool to the GDS Configuration Adding Regions to the GDS Configuration Adding Databases to the GDS Configuration About the GSMUSER Account Known Issues Summary Chapter 6: Test Cases: Using Oracle GDS with Oracle ADG Setting Up the Environment Primary Database Version and the Patch Set Physical Standby Database Server Second Physical Standby Database Server Catalog Database Used in This Chapter Starting and Stopping GDS Components Sourcing the GSM Environment Connecting to the Catalog Setting the Current GSM Starting the GSM Checking the Status of GDS Components Checking the GSM Configuration Starting the GSM Named gsmnorth Starting the GSM Checking the Status of the GSM Starting the GSM Named gsmsouth Setting the Current GSM Starting the GSM Checking the Status of the GSM GDSpool Databases Summary of This Section Test Case: Global Service Failover High-Level Steps of This Test Case Prerequisites Logging In to the GDS Catalog Connecting to the GDS Catalog Checking the Status of the GSM gsmeast Checking the Status of the Databases Checking the Current Configured Services Checking the Current gdspool in the GSM Configuration Checking the Configuration of the Regions Creating a Role-Based Global Data Service Starting the Service Checking the Status of the Database Checking the Configuration of the Service Checking the Active Services in the Database orcldb Testing the Database Connection Using the Service sales_reporting_srvc Shutting Down the Physical Standby Databases Starting Both the Standby Databases Summary of This Test Case Test Case: Role-Based Global Services High-Level Steps of This Test Case Prerequisites Creating a Role-Based Global Service Named srvc_prim Testing the Database Connection Performing the Switchover Operation Summary of This Test Case Test Case: Replication Lag-Based Routing High-Level Steps of This Test Case Prerequisites Physical Standby Database Lag Check Summary of This Test Case Test Case: TAF-Enabled Global Service in the GDS Environment High-Level Steps of This Test Case Prerequisites Connecting to the GDS Catalog Creating a Role-Based Global Service Named prim Starting the Service and Checking Its Status Checking the Status of the Running Services and the Databases Preparing the TNS Entry Testing the Database Connection Running the SELECT Statement Performing a Switchover Operation to Make orcldbs the Primary Database Monitoring the SELECT Statement Summary of This Test Case Test Case: Local-Based Routing High-Level Steps of This Test Case Prerequisites Checking the Status of the GSMs Checking the Status of the Databases Checking the Current Configured Services Checking the Current gdspools in the GSM Configuration Checking the Configuration of the Regions Testing the Global Service with Attribute locality Set to anywhere Starting the Service Checking the Status of the Service Checking the Configuration of the Service Checking the Status of the Databases TNS Entry for the Service Testing the Database Connection Using This Service Stopping the Service and Removing the Service Testing the Global Service with the Attribute locality Set to local_only Starting the Service Checking the Status of This Service Checking the Configuration of the Service Checking the Status of the Databases Starting the Service Checking the Status of This Service Checking the Configuration of the Services Checking the Status of the Databases Testing the Database Connection Using This Service Summary of This Test Case Summary Known Issues Chapter 7: Test Cases: Using Oracle GDS with Oracle GG Setting Up the Environment Primary Database Version and the Patch Set Oracle GoldenGate Replicated Database Information About the GDS Catalog Database Database SQL Scripts Configuration of Oracle GoldenGate Global Data Service Components Configured for This Demonstration Status of the GSM Running in the Primary Database Server Status of the GSM Running in the Replicated Database Server GDS Pool Databases Test Case: Global Service Failover High-Level Steps of This Test Case Checking the Active Services in the Database orcldb Checking the Active Services in the Database ggoradb Testing the Database Connection Relocating the Service in the GDS Environment Summary Chapter 8: Test Cases: Using Oracle GDS with Oracle RAC Setting Up the Environment Primary Database Version and the Patch Set Physical Standby Database Version and the Patch Set GSMGSMs, Regions, gdspools, and Databases Global Service Manager gdspool Created for This Exercise Regions Created for This Exercise GDS Catalog Repository and Database Information Adding gdspool Databases to the GDS Configuration Adding a RAC Database to the Global Data Service Configuration Test Case: Global Service Failover in RAC High-Level Steps of This Test Case Prerequisites Connecting to the GDS Catalog Checking the Status of the GSM gsmeast Checking the Status of the Databases Checking the Currently Configured Services Checking the Current gdspool in the GSM Configuration Checking the Configuration of the Regions Starting the Service Checking the Status of the Service Checking the Status of the Database Checking the Configuration of the Service Checking the Configuration of All the Components Checking the Active Services in the Database, oragdspr Checking the Active Services in the Physical Standby Databases, oragdsdr and oragdstr Testing the Database Connection Shutting Down Both Physical Standby Databases Testing the Database Connection Starting Both Standby Databases Stopping and Removing the Service Summary of This Test Case Adding a New Physical Standby Database to the Global Data Service Configuration Removing the Physical Standby Database from the Global Data Service Configuration Summary Chapter 9: Exploring Raft Replication in Oracle 23c Raft Replication Enabling Raft Replication GSM Catalog Database Details Shard Database Details Test Cases for Raft Replication Test Case 1: Moving Chunks from One Replication Unit to Another Test Case 2: Scaling Up the Raft Replication Test Case 3: Moving a Replication Unit from One Shard to Another Test Case 4: Copying a Replication Unit from One Shard to Another Test Case 5: Changing the Leader of the Replication Unit Test Case 6: Scaling Down in Raft Replication Test Case 7: Testing the High Availability of Shards What Happens When a New Shard Is Added to the Sharded Database Known Issues Problem 1 Solution Problem 2 Solution Problem 3 Solution Problem 4 Solution Problem 5 Solution Problem 6 Solution Problem 7 Solution Summary Chapter 10: High Availability of the Global Service Manager Setting Up the Environment Primary Database Version and the Patch Set First Physical Standby Database Server Second Physical Standby Database Server Catalog Database Used in This Chapter Test Case: High Availability of the GSM High-Level Steps of This Test Case Prerequisites Starting and Checking the Status of the GSM gsmeastl Starting and Checking the Status of the GSM gsmnorth Starting and Checking the Status of the GSM gsmsouth Starting the Service Checking the Status of the Service and the Databases Testing the Database Connection Stopping the GSM gsmeast Testing the Database Connection Stopping the Second GSM gsmnorth Testing the Database Connection Testing the Database Connection Starting All the GSMs Stopping and Removing the Service Summary of This Test Case Test Case: Crash of the GDS Catalog Database High-Level Steps of This Test Case Prerequisites Starting All the GSMs and Checking Their Status Checking the Status of the Databases Checking the Current Configured Services Checking the Current gdspools in the GSM Configuration Creating a Role-Based Global Service Named sales_catlog_srvc Checking the Status of Services and the Databases Testing the Database Connection Shutting Down the GDS Catalog Database Performing a Switchover Operation When the Catalog Database Is Down Adding a New Service When the Catalog Database Is Down Stopping and Starting the GSM When the Catalog Database Is Down Summary of This Test Case Summary Index New to Oracle Global Data Services? You’ve come to the right place. This book will show you how to leverage the power of Oracle GDS to ensure runtime load balancing, region affinity, replication lag tolerance-based workload routing, and inter-database service failover. In particular, you will see how to maximize the utilization of replication investments with Oracle GDS. The book starts by guiding you through the installation and configuration of GDS and provides details for each component in the GDS framework. Next, you’ll learn how to configure various components of Oracle GDS in standalone environments. Hands-on exercises that explore the advantages of GDS with different test cases utilizing Active Data Guard (ADG), Oracle GoldenGate (OGG), and Oracle Real Application Clusters (RAC) will help you put your learning in context. The book concludes with a demonstration of how to add Oracle GDS to OEM for monitoring and troubleshooting. You’ll also see how to monitor Oracle GDS in a centralized location using Oracle Enterprise Manager Cloud Control. After completing this book, you will understand the architecture, components, and implementation strategies of GDS using ADG and OGG in mission-critical environments. What You Will Learn Understand Oracle Global Data Services architecture and its various components Install and configure Oracle Global Data Services Use Global Data Services with Active Data Guard and Oracle Golden Gate. Monitor Global Data Services using Oracle Enterprise Manager Cloud Control. Troubleshoot issues in Global Data Services Who This Book Is For Oracle database administrators, Oracle database architects, Oracle technical managers, Oracle application business analysts, and Oracle data engineers.