President
Viscosity North America
Red Hat Enterprise Linux and Oracle Linux continues to gain market share as a reliable 7/24 mission-critical enterprise server platform. As a DBA in today’s economy, you must possess both the system and database expertise. In this session, learn the tips and tricks to install and configure Linux with all the industry best practices. Don’t stop there. You need to learn the secrets of automating the Grid Infrastructure and database software stack for both RAC and non-RAC environments. Imagine being able to provision a 4 node RAC cluster that is fully patched and being able to create a RAC database on Oracle 19c in couple of hours. Learn all the best practices for Red Hat/Oracle Linux 7 and 8 required to implement Oracle Databases in bare metal servers and 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.
With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported. As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book written by Oracle ACEs. 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. Innovations in pluggable databases will blow your mind. 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 • can confidently provide higher availability, reliability and scalability
The database administration role as we knew it is dead. DBAs who have been around for decades have become irrelevant in this data driven economy. Developers want autonomous management and executive leaders want to cut costs anyway they can. Join Oracle community experts as we discuss the next evolutionary role of the database administration role and what we must do to adapt and survive in this ever changing dynamic technology driven world. Learn what future skills you need to possess and how you can stay on top of the demand. 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 #6. Pluggable Databases Risen From the Dead With the recent announcement at Oracle OpenWorld, starting in Oracle Database 19c, we are allowed to have up to 3 pluggable databases per container database. Effective Oracle Database 20c, non-containerized databases will no longer be supported. As an attendee of this session, you will receive a free copy of the PDB Me to Oracle Cloud book written by Oracle ACEs. 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. Innovations in pluggable databases will blow your mind. 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 • can confidently provide higher availability, reliability and scalability
Companies can recognize immediate ROI by upgrading to Oracle Database 19c, especially those who are still running on legacy databases that will go out of premier support this year (11.2) or next year (12.1). As part of this Oracle Database 19c Hands-On Experience, attendees will learn the intimate details of upgrading databases to Oracle Database 19c. 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
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 12 Release 2 is packed with 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 20c New Features 2. Oracle 19c New Features 1. Why do you need to go directly to Oracle Database 19c and skip Oracle Database 12.2/18c 3. Oracle 18c New Features 4. Upgrade to Oracle 12.2/18c/19c/20c a. Upgrade considerations b. Zero downtime upgrade options 5. Multi-Tenancy (PDB) Option 1. Elimination of support for non-container databases in Oracle 20c 2. 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 13. In-Memory 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.
