Viscosity North America
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.
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 126.96.36.199 or 188.8.131.52 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.
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
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
Join us in this educational session as we help you navigate and plan moving your databases to Oracle Cloud, along with useful tips before considering database as a service, infrastructure as a service or platform as a service options for your critical applications. In this session, we will discuss Oracle’s Cloud strategy, migration paths to your journey to the cloud, and discuss hidden gems in Oracle Cloud to simplify adoption. Lastly, we will breakdown many of the Oracle OpenWorld 2019 new announcements that will impact your cloud journey. In this session, we will share impact caused by: • The autonomous database • DBA 3.0 • Oracle Cloud VMware Solutions (OCVS) • EXACC and PCC • License model changes Whether you belong to a large enterprise or a one-man startup, cloud based databases are now a reality or part your short term technology roadmap. Like every major initiative, having a plan and executing to perfection is key to realizing the benefits offered by the cloud adoption, the absence of which could result in unplanned and unexpected downtime for your business critical applications.
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. 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 Performing Switchovers and Failovers o Switchover with Refreshable PDBs o Subset Standbys with PDBs Attendees will get access to all the scripts to automate the Data Guard configuration.