Oracle 19c
AutoUpgrade
Best Practices
A Step-by-step Expert-led Database Upgrade
Guide to Oracle 19c Using AutoUpgrade Utility
Sambaiah Sammeta
Sukumar Chillakuru
www.bpbonline.com
FIRST EDITION 2022
Copyright BPB Publications, India
ISBN: 978-93-91030-902
All Rights Reserved. No part of this publication may be reproduced, distributed or transmitted in any form or by any means or stored in a database or retrieval system, without the prior written permission of the publisher with the exception to the program listings which may be entered, stored and executed in a computer system, but they can not be reproduced by the means of publication, photocopy, recording, or by any electronic and mechanical means.
LIMITS OF LIABILITY AND DISCLAIMER OF WARRANTY
The information contained in this book is true to correct and the best of authors and publishers knowledge. The author has made every effort to ensure the accuracy of these publications, but publisher cannot be held responsible for any loss or damage arising from any information in this book.
All trademarks referred to in the book are acknowledged as properties of their respective owners but BPB Publications cannot guarantee the accuracy of this information.
www.bpbonline.com
This book, written by Sambaiah Sammeta and Sukumar Chillakuru, and technically reviewed by Venkata Ravi Kumar Yenugula will cover most of the scenarios for upgrading the Oracle database from versions 11g, 12c, and 18c databases to Oracle version 19c. This book describes the best methods that can be used to upgrade the Oracle databases, and mainly deals with how to use the Oracles AutoUpgrade utility to upgrade the databases from the lower versions to Oracle 19c with minimal manual intervention. This book covers the various scenarios tested against the Real Application Clusters databases with Physical Standby databases, and also covers the test cases for both the non-container databases and the multitenant databases. This book also contains the various downgrade scenarios tested and explains both the benefits and pitfalls with each of the downgrade processes. The book is releasing at the right time as Oracle is strongly recommending to use the AutoUpgrade tool to upgrade the Oracle databases. This book covers most of the scenarios that a DBA can find in a real time environment, and most importantly, each chapter is well tested and has hands-on steps, making this book an extremely helpful guide for the Oracle Database upgrade process.
I would like to congratulate Sambaiah Sammeta and Sukumar Chillakuru for this excellent book. It is a must have book for every DBA working on the Oracle Database upgrades.
Sandesh Rao
Vice President
AIOPS and Machine Learning
Autonomous Database
ORACLE Corporation
Dedicated to
My beloved Parents,
Sammeta Narayanamma
Sammeta Uma Maheshwar Rao
&
My wife Sujitha and daughter Sarayu
Thanks
Sambaiah Sammeta
My beloved Parents,
Chillakuru Ramadevi
Chillakuru Rajagopal Reddy
&
My wife Anitha and daughter Akshara Reddy
&
My boss Satyendra Pasalapudi
Thanks
Sukumar Chillakuru
About the Authors
Sambaiah Sammeta is an Oracle Certified Professional with 15+ years of experience, working as an Oracle Database administrator consultant. He provided the DBA support for various clients including the clients in the Banking sector, Retail, Health care services, automobile sector, and the Financial service verticals. He is an Oracle Cloud certified Architect professional (2020 and 2019), Oracle Autonomous database cloud certified, and Oracle database cloud certified specialist (2020). He planned and performed all the 11g to 19c and 12c to 19c database upgrades in a few of the major banking and Health care clients.
Sukumar Chillakuru is a DBA by profession with 14+ years of experience, currently working as a Database Architect at Infolob Solutions India Pvt Ltd. in Chennai. He has previously worked in reputed IT firms like Oracle, CTS, Apps Associates, and Megasoft. He is an expert in performing the Oracle Database Upgrades and Migrations. He is an Oracle certified Professional in Oracle database, Autonomous database, Oracle Cloud Infrastructure Architect Professional, and Oracle Goldengate Certified Specialist.
He developed his passion in technical writing and grabbed the opportunity to work with the Oracle University as an Author and Co-Author of five different courses on Oracle Cloud Infrastructure and Oracle Autonomous Database.
About the Reviewers
Yenugula Venkata Ravi Kumar (YVR) is an Oracle ACE Director and Oracle Certified Master (OCM) with years of experience in the banking, financial services, and insurance (BFSI) verticals. He has worked as a Vice President (DBA), Senior Database Architect, Senior Specialist Production DBA, and Oracle Engineered Systems Architect.
He is an Oracle Certified Professional (OCP) from Oracle 8i to Oracle 19c and also the Oracle Certified in Oracle Golden Gate, RAC, Performance Tuning, Oracle Cloud Infrastructure, Terraform, and Oracle Engineered Systems (Exadata, ZDLRA, and ODA), Certified in Oracle Security and Maximum Availability Architecture (MAA) Certified.
He has published 100+ articles, which includes Oracle Technology Network (OTN), OraWorld Magazine, UKOUG, OTech Magazine, and Redgate. Twice he has been an Oracle Speaker at Oracle Open World (OOW), IOUG 18, NYOUG, AIOUG, and Sangam. He has designed, architected, and implemented the core banking system (CBS) database for the central banks of two countries India and Mahe, Seychelles.
Oracle Corporation USA has published his profile in their Oracle ACE Program as Oracle ACE Director (ACED). They have also published his profile in their Oracles Certified Master (OCM) list and Spotlight on Success stories.
He has also co-authored a couple of books and for BPB Publications, he has co-authored the book, Oracle Golden Gate with
K M Krishnakumar is an Oracle OCI certified Architect, Autonomous Database Expert, Exadata specialist, Speaker (Oracle Open World), and Author. He has 16+ years of experience in Information Technology, where he has played various roles like Software Engineer, Senior Consultant, Principal DBA, Solution Engineer, and Cloud Architect. He holds a Master's degree in Business Administration from Anna University. He started working with the Oracle Technologies from 2004 as a DBA and has been with the Oracle Corporation for years.