Charles Kim.

Charles Kim 300x300

Charles Kim.

President

Viscosity North America

Biography

Charles Kim is an Oracle ACE Director, VMware vExpert, an Oracle Certified DBA, Certified Exadata Specialist, and a Certified Oracle Linux, Oracle Cloud, and RAC Expert. Charles was selected into the Oracle ACE Program on May 2008 and became an Oracle ACE Director as of December 2009. Charles has been an Oracle ACE Director every year since 2009. Charles became a VMware vExpert in the class of 2013. Charles specializes in Cloud, Exadata, RAC, and Virtualization (VMware, KVM and Oracle VM) and co-authored ten books around the Oracle EcoSystem: – Oracle Cloud Pocket Reference Guide – A Handbook on Oracle Cloud Infrastructure – PDB Me to Oracle Cloud – A Lazy DBA’s Guide to Mastering Multi-Tenant – Exadata Expert Handbook – Oracle Database 11g New Features for DBA and Developers – Linux Recipes for Oracle DBAs – Oracle Data Guard 11g Handbook – Virtualizing Business Critical Oracle Databases: Database As A Service – Oracle ASM 12c Pocket Reference Guide – Virtualizing Hadoop – Solaris and Linux Recipes for Oracle DBAs Charles is the Founder and CEO of Viscosity North America, a highly specialized niche consulting organization comprised of industry experts in Oracle Engineered Systems, RAC, Oracle Cloud, Virtualization and Performance Tuning. Charles holds certifications in Oracle Databases, VMware, Red Hat & Oracle Linux, and Microsoft and has over 30 years of Oracle experience on mission and business critical databases. Charles presents regularly at local, regional, national and international Oracle conferences including IOUG Collaborate, VMware World, RMOUG, UKOUG, New Zealand/Australia Oracle User Group, and Oracle OpenWorld on topics of Oracle Cloud, RAC, Exadata, Database Consolidations, Private Database Cloud, ASM, Linux Best Practices, Data Guard Best Practices, Performance Tuning, VMware Virtualization Best Practices, and 7×24 High Availability Considerations.

Papers

The Rise of the PDBs

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

By now, everyone is aware that starting with Oracle Database 21c, non-containerized databases will no longer be supported. As customers upgrade to Oracle Database 19c, customers are adopting and embracing PDBs and learning to adapt to the new paradigm shift. Come learn what it takes to effectively create, configure, manage and monitor Oracle PDBs. Learn all the latest and greatest new features of Oracle PDBs from Oracle 12.2/18c/19c. Recent advances in pluggable databases will revolutionize how you maintain and manage your databases. Innovations in Oracle PDBs will change how you: • patch your databases • perform database upgrades • provide reporting databases • provision clones of pre-production, QA and DEV environments • setup Data Guard between the primary and standby environments • setup performance governors on the database tier • setup security with pluggable DBAs • consolidate your database environments • ask for outage windows to perform maintenance • provide higher availability, reliability and scalability

Case Study: Payment Processing Company Achieves 100% Uptime Migrating and Upgrading Database to Exadata

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

Learn how one of the largest payment processing companies migrated their mission critical databases to the latest Exadata with zero downtime. While migrating to the latest Exadata platform, we upgraded databases from Oracle 12c (12.1) to Oracle Database 19c. Technical architecture details will be discussed, how ultra high availability was accomplished, lessons learned will be shared, and most importantly, how we mitigated risk for performance. Many challenges and hurdles had to be overcome since the databases served a global financial client base. Production database migration to the Exadata environment had to be performed with zero downtime architecture with a “live-cutover” while continuing to process application data. Exadata clusters consisted of two sets of ten node RAC compute nodes across two data centers. Technologies leveraged includes: o Datapump o GoldenGate o Real Application Testing o 10 Node RAC Cluster o Global Data Services o 10 Node RAC Cluster Exadata replicating data to another 10 Node RAC Cluster Exadata

Automate and Bulletproof Your Data Guard

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

Learn how you can setup Data Guard with all the best practices. Attendees will get a brief history of Data Guard and how it became Data Guard. Then we will dive directly into new features in Oracle Data Guard 12c Release 2/18c/19c new features. In addition to demonstrating how simple it is to setup Data Guard, this session will disseminate fundamental Data Guard best practices and reference architectures that DBAs need to know to protect their Oracle ecosystem. The author of the Oracle Data Guard Handbook will demonstrate how DBAs should setup, configure, and monitor mission critical Data Guard environments (including Active Data Guard). Come see Data Guard best practices in action. The session concentrates on: o Building the Physical Standby o Monitoring and Maintaining the Physical Standby o Configuring Data Guard Broker o Performing Backup and Recovery with RMAN o Setting Archive Retention o Switchover with Refreshable PDBs o Subset Standbys with PDBs Attendees will get access to all the scripts to automate the Data Guard configuration.

Unleash the Top 19 New Features of Oracle Database 19c

Event: Connect 2021
Stream: Architecture, Cloud Database & Technology

Oracle Database 19c is the terminal release of Oracle Database 12c and is packed with hundreds of enhancements for DBAs and Developers. Come listen to all the pertinent new features in Oracle 12.2/18c/19c that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2/18c/19c database features. Be prepared to have mind overloaded with the following focused areas: 1. Oracle 21c New Features 2. Oracle 19c New Features a. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2 and 18c 3. Oracle 18c New Features 4. Upgrade to Oracle 12.2/18c/19c/21c a. Upgrade considerations b. Zero downtime upgrade options 5. Multi-Tenancy (PDB) Option a. Elimination of support for non-container databases in Oracle 21c b. Changes in Oracle licensing policy with Oracle19c 6. Online Improvements 7. Partitioning Option 8. Data Guard 9. RMAN 10. General Database 11. RAC 12. ASM/ACFS Oracle DBAs/Developers can take immediate advantage of these new features. We will rapid fire all the new features to the audience. We will share all of the code from our presentation so that you can add them to your arsenal.

Bulletproof Your Database Upgrades to Oracle Database 19c

Event: APEX Special Series 2021, Connect 2021, Virtual Connect 2020, Virtual Connect 2020-Cloud
Stream: Architecture, Cloud Database & Technology

Come learn what it takes to upgrade to Oracle Database 19c from earlier Oracle database versions 11.2.0.x/12.1.0.x./12.2.0.x.  More importantly, come learn all the best practices for upgrading your databases to Oracle Database 19c. Attendees will learn how to perform database upgrades leveraging the following methods and why you should choose one over the other: 1) AutoUpgrade method 2) DBUA in silent and GUI method 3) Command-line hard core dbupgrade method. The Hands-On Upgrade Experience will encompass the following: 1) Installing Oracle Database 19c software – Learn how to install the base Oracle Database 19c software and apply the Release Update and even apply the one-off patches in a single command in silent mode 2) Patching the database software to the latest Release Update (RU) 3) Performing pre-upgrade tasks prior to the database upgrade – Additional scripts will be provided to attendees for performing pre-installation checks 4) Upgrading an Oracle 11.2.0.4 or 12.1.0.2 database to Oracle Database 19c with the latest RU 5) Performing post-upgrade tasks after the database upgrade 6) Learn how to perform AutoUpgrades to Oracle Database 19c

Tips and Tricks: Linux Best Practices and Automation for DBAs

Event: Connect 2021, Virtual Connect 2020, Virtual Connect 2020-Cloud
Stream: Architecture, Cloud Database & Technology

in virtualized infrastructures.  Leveraging real-life experiences and techniques, learn from the author of the Linux Recipes for DBAs book by APress on how-to: 1. Leverage PreInstall RPMs to prepare the Linux environment for Oracle database, OEM Agents, and EBusiness Suite environments 2. Setup and leverage a local Yum Repository 3. Setup Huge Pages / Disable Transparent Huge Pages 4. Setup Jumbo Frames 5. Setup Oracle ASM Filter Driver vs ASMLIB 6. Setup correct partition alignment 7. Automate Grid Infrastructure provisioning 8. Create ASM instance in silent mode 9. Automate Database provisioning 10. Automate installation of release updates and one-ff patches 11. Automate Grid Infrastructure and Oracle Database software cloning 12. Create ASM disk group with XML files 13. Create Golden Image databases for future cloning 14. Setup rsync to synchronize file system from source and target servers And much more.

DBA 3.0: The Next Evolution

Event: Connect 2021, Virtual Connect 2020, Virtual Connect 2020-Cloud
Stream: Architecture, Cloud Database & Technology

Discussions will include how technical enhancements to autonomous databases, cloud innovations and what you must learn to survive, how AI and machine learning can impact the database scene and understanding which technologies you need to learn to adapt. In this session, you will learn: • what is important in the database industry • how to generate your “OpEx Value” in an era where everything is about the bottom line • how to understand how business knowledge plays in the DBA role • how to innovate and win with Oracle Cloud, Azure and AWS • the value of the heterogeneous DBA • the critical role of the data driven DBA • the impact of autonomous in the DBA world • what relevance DBAs have in the autonomous world and how we can adapt • how does the pluggable DBAs have relevance? • why is the Cloud database administration worth while for me to learn