Winter 2017 Workshop - February 2, 2017

Theme: Upgrade to Oracle 12C

When: Thursday, February 2, 2017

Where: Normandale Communicty College, Bloomington

9700 France Ave S, Bloomington



8:30-9:00 :  
Registration and Networking

9:00-9:30 :  
Welcoming Remarks and Board Member Elections: Dave Rodriguez, President TCOUG


Sponsor Introduction (Collier-IT, Meta7)


Speaker Introduction: Madhu Reddy, Vice President, TCOUG

9:30-10:30 :  
Oracle 12c Upgrade, Introduction and Overview: Roy Swonger, Oracle

Source side: Integrity checks on source database to be done prior to upgrade
Target side: Certification, how to find the right patches, PSUs vs Bundle Patches
Recommendations: Key 12.2 parameters and other parameter setting recommendations.


10:30-10:45 :  

10:45-12:00 :  
Upgrade Techniques and Scenarios: Roy Swonger, Oracle

Case 1: Command-line upgrade to Oracle 12c including what's new in 12.1 and 12.2
Case 2: Cross-endian Migration with Data Pump
Case 3: Cross-endian Migration with Transportable Tablespaces, including use of RMAN cross-platform incremental backups, and Full Transportable export/import
Case 4: Near-Zero or Zero-downtime migration with GoldenGate


12:00-1:00 :  
Break: Lunch

1:00-2:30 :  
Oracle Public Cloud & Oracle 12.2 new features: Roy Swonger, Oracle

Highlights of new features in 12.2
Oracle Public Cloud: What's available, how to migrate, possible use cases

2:30-2:45 :  

2:45-4:00 : 
Post Upgrade considerations: Roy Swonger, Oracle

Fallback Strategies: dealing with issues during the upgrade, dealing with issues found days or weeks later
Performance Management: how to ensure good performance after an upgrade

4:00-4:30 : 
Election Results, Giveaways and Prizes


About the Speaker

Roy Swonger - Vice President Software Development, Oracle

Roy Swonger has over three decades of experience in commercial software development. His 22- year career at Oracle has included work on software process and quality improvement as well as a progression of management roles in technical documentation, software development tools, and core database technologies. Roy has managed the Database Upgrade & Utilities in the Server Technologies division for more than 13 years. In this capacity he is responsible for the development of database features such as the Data Pump, SQL*Loader, External Tables, and Transportable Tablespaces.

In addition, Roy runs the global Upgrade Program for the database, coordinating worldwide efforts to make database upgrades faster, easier, and less risky for customers.

Roy holds a Bachelor of Science in Computer Science from Rensselaer Polytechnic Institute, and a Master of Software Engineering from Carnegie Mellon University.