Learn all of the available upgrade and migration methods in detail to move to Oracle Database version 12c. You will become familiar with database upgrade best practices to complete the upgrade in an effective manner and understand the Oracle Database 12c patching process.So it's time to upgrade Oracle Database to version 12c and you need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. You will be aware of the practical issues and proactive measures to take to upgrade successfully and reduce unexpected issues.
With every release of Oracle Database there are new features and fixes to bugs identified in previous versions. As each release becomes obsolete, existing databases need to be upgraded. Oracle Database Upgrade and Migration Methods explains each method along with its strategy, requirements, steps, and known issues that have been seen so far. This book also compares the methods to help you choose the proper method according to your constraints.Also included in this book:Pre-requisite patches and pre-upgrade stepsPatching to perform changes at the binary and database level to apply bug fixesWhat You Will Learn:Understand the need and importance of database upgrading and migrationBe aware of the challenges associated with database upgrade decision makingCompare all upgrade/migration methodsBecome familiar with database upgrade best practices and recommendationsUnderstand database upgrade concepts in high availability and multi-tenant environmentsKnow the database downgrade steps in case the upgraded database isn't compatible with the environment
Discover the features and benefits to the organization when it moves from the old database version to the latest database versionUnderstand Oracle 12c patching concepts
Who This Book Is For:
Core database administrators, solution architects, business consultants, and database architects
Les Cris et les Inuit se trouvent confrontés aux difficultés de l'irruption de la modernité dans leurs territoires : gouvernance, environnement, santé, maintien de la culture... Comment vivre dans un monde nouveau en gardant ses propres valeurs ? Les auteurs jettent un éclairage sur la question en étudiant l'évolution des peuples autochtones.
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 componentsInstall and configure Oracle Global Data ServicesUse 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.
This book focuses on the utilization of GoldenGate Services (GGS) in conjunction with a microservices architecture on the Oracle cloud (OCI), primarily for data migration and integration across various data sources and targets.
The book begins with a practical example of utilizing GGS on a Marketplace VM, progressively advancing to in-depth discussions on implementing GoldenGate as a Service on OCI. The book offers illustrative guides for data replication between RDBMSs (such as Oracle, Postgres, and big data targets such as Kafka). Additionally, it explores monitoring techniques using Enterprise Manager and Grafana dashboards. A comparative analysis is presented between traditional VM-based GoldenGate installations and the OCI service model. Special attention is given to Zero Downtime Migration (ZDM) and leveraging GGS for database migration from on-premises to OCI. Some chapters address multi-cloud replication using OCI GGS and include real-life case studies.
By the end of this book you will have gained comprehensive insights into the architectural design of GoldenGate Services and will be adept at replicating data using GGS, enabling you to replicate setups in your own environments.
What You Will LearnSet up GoldenGate Services for high availability (HA), disaster recovery (DR), migration of data to cloud, and moving data into the data lake or lakehousePerform logical migration of data to the cloud using the ZDM tool (ZDM uses GoldenGate internally).Replicate data to big data targetsMonitor GGS using Enterprise Manager and GrafanaReplicate data in a multi-cloud environment
Who This Book Is ForOracle database administrators who want to replicate data or use Oracle GoldenGate Services for migration and setup of high availability (HA) and disaster recovery (DR); and data engineers who want tobuild the data warehouse, data lake, data lakehouse to push data in near real-time
This book is your one-stop resource on MySQL database installation and server management for administrators. It covers installation, upgrades, monitoring, high availability, disaster recovery, security, and performance and troubleshooting. You will become fluent in MySQL 8.2, the latest version of the highly scalable and robust relational database system.With a hands-on approach, the book offers step-by-step guidance on installing, upgrading, and establishing robust high availability and disaster recovery capabilities for MySQL databases. It also covers high availability with InnoDB and NDB clusters, MySQL routers and enterprise MySQL tools, along with robust security design and performance techniques. Throughout, the authors punctuate concepts with examples taken from their experience with large-scale implementations at companies such as Meta and American Airlines, anchoring this practical guide to MySQL 8.2 administration in the real world.
What YouWill LearnUnderstand MySQL architecture and best practices for administration of MySQL serverConfigure high availability, replication, disaster recovery with InnoDB and NDB enginesBack up and restore with MySQL utilities and tools, and configure the database for zero data lossTroubleshoot with steps for real-world critical errors and detailed solutions
Who This Book Is ForTechnical professionals, database administrators, developers, and engineers seeking to optimize MySQL databases for scale, security, and performance
Le journaliste Arthur Locke croit rêver. Il va enfin interviewer la fondatrice de Terminus, la nouvelle ville intelligente à la fine pointe de la technologie. Sur place, un mystère flotte sur la cité. Quelque chose ne va pas avec l'intelligence artificielle, qui est censée améliorer la vie des citoyens. Dans quel piège Arthur vient-il de tomber?
