Oracle Global Data Services for Mission-critical Systems: Maximizing Performance and Reliability in Complex Enterprise Environments

ISBN-13: 9781484295526 / Miękka / 2023 / 370 str.

Mariami Kupatadze

Opis

Intermediate-Advanced user level

Spis treści

Chapter 1: Introduction of Oracle Global Data services

Chapter Goal:

Introducing the readers to the learning and understating of Oracle Global Data Services Concepts and benefits in production systems as well as mission critical systems.

No of pages : 20

Sub -Topics

• GDS Framework

• GDS catalog

• GDS region

• GDS pool

• GDS services

Chapter 2:  Installation of Global Service Manager 

Chapter Goal: Helping the readers with installation and configuration of the Oracle Global Data Services in Clustered environments. 

No of pages: 25

Sub - Topics

• Downloading GSM software

• Pre-Requisites for Oracle GSM

• Installation of the Oracle GSM

• Configuration Of Oracle GSM

Chapter 3:  Configuration of GSM and GDS catalog

Chapter Goal: Helping the readers to learn the installation of Oracle Global Service Manager and learn how to add the regions, gdspool and databases to the Oracle Global Service Manager.

No of pages: 25

Sub - Topics:  

• Creating Global service managers

• Creating GDS catalog

• Add region to GSM configuration

• Add gdspool to GDS configuration

• Adding databases and data guard broker configuration to the GSM

Chapter 4: GDS Test cases with RAC database with Active Dataguard

Chapter Goal: Helping the architects/readers/analysts to engage with hands-on exercises on exploring the advantages of the GDS with different test cases tested against the RAC database with Active dataguard.

No of pages: 110

Sub - Topics: 

• Starting and stopping Global data service (GDS) components

• Test Case: Global Service Failover

• Test Case: Role based Global Services

• Test Case: Replication Lag based Routing

• Test Case: TAF Enabled Global Service in GDS Environment

• Test Case: Locally based Routing

• Test Case:  High Availability of Global Service Manager (GSM)

• Test Case:  What if Global Data Services (GDS) catalog database becomes unavailable

Chapter 5:  Modify GSM of the database

Chapter Goal: Help the reader how to modify the region of the databases configured in GSM configuration.

No of pages: 12

Sub - Topics: 

• Check the configuration of the databases and region

• Create new regions 

• Modify the regions of the GSMs

• Modify the databases to update the regions to new regions

Chapter 6:  GDS Test cases with Oracle Golden gate

Chapter Goal: Help the reader with hands-on GDS exercises tested against the Oracle database with Golden gate replication in place.

 

Chapter 7:  Configuring GDS in OEM

Chapter Goal: Help the reader to understand how to add oracle global data services to OEM for monitoring.

Chapter 8:  Troubleshooting GDS issues

Chapter Goal: The Goal of this chapter is discussing and show how to troubleshoot issues in Global data service. 

No of pages: 25

O autorze

Y V Ravi Kumar is an Oracle ACE Director (ACED) and Oracle Certified Master (OCM) with 25 years of experience in banking, financial services, and insurance (BFSI) verticals. He has worked as a Vice President (DBA), Senior Database Architect, Oracle Engineered Systems Architect, and Technology Advisor. He is an Oracle Certified Professional (OCP) from Oracle 8i/9i/10 g/11 g/12c/19c and an Oracle Certified Expert (OCE) in Oracle GoldenGate, RAC, Performance Tuning, Oracle Cloud Infrastructure, Terraform, and Oracle Engineered Systems (Exadata, ODA, ZFS and ZDLRA), as well as Oracle Security and Maximum Availability Architecture (MAA) certified.

He has published over 100 Oracle technology articles, including ones for Oracle Technology Network (OTN), OraWorld Magazine, UKOUG, OTech Magazine, and Redgate. He has spoken twice at Oracle Open World (OOW). He has designed, architected, and implemented the core banking system (CBS) database for the central banks of two countries – India and Mahé, Seychelles. Oracle Corporation, US, awarded him the title Oracle ACE Director and published his profile in their Oracle ACE Program. They also published his profile on their OCM list and in their Spotlight on Success stories. He is the author of two Apress books, Oracle Database Upgrade and Migration Methods and Oracle High Availability, Disaster Recovery, and Cloud Services.

Sambaiah Sammeta is an Oracle Certified Professional (OCP) with 15 years of experience working as an Oracle Database administrator consultant. He has provided DBA support for various clients, including clients in the banking sector, retail, healthcare services, automobile sector, and financial services service verticals. He is an Oracle Cloud-certified Architect professional (2020 and 2019), Oracle Autonomous database cloud certified, and an Oracle database cloud certified specialist (2020). He planned and performed all the 11g to 19c and 12c to 19c database upgrades for several major banking and healthcare clients.

Mariami Kupatadze holds the distinction of being the first Oracle Certified Master (OCM) in her country, Georgia, and is a former member of the ACE program, having previously held ACE status. Mari has published multiple articles in prominent industry publications, such as OraWorld e-magazine and Oracle Technology Network (OTN), and has been a featured speaker at prestigious events, such as the APAC Oracle Users Groups Community (APACOUC) and the Luxembourg Oracle Users Group (LUXOUG). In 2019, she authored a chapter on Oracle Sharding for the Apress book Oracle High Availability, Disaster Recovery, and Cloud Services. A prolific blogger since 2010, Mari has published over 400 posts on her blog, which has been recognized as one of the Top 60 Oracle blogs.

Blurb

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.

You will:

• 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