Viscosity North America
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
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
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.
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.
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 18.104.22.168 or 22.214.171.124 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
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.
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