Oregon and Southern Washington Oracle User Group (OSWOUG)
Oracle Cloud Hands-On Lab and Conference Sessions
Providence St. Vincent Medical Center | May 7 & 8, 2018
Monday May 7, 2018 Hands-On Lab: Register Now
IT as you know it is changing and we need to not only be aware, but embrace the cloud. For Oracle Databases there in none better than Oracle Cloud. If you have not experienced Oracle Cloud in the past 6 months, you are in for a surprise.
If you are running any kind of an Oracle workload, you cannot afford to miss this hands-on workshop. Oracle ACE Director, Charles Kim, will build on your foundation to become an Oracle Cloud expert.
Learn how Oracle Cloud differentiates itself from others, by being the fastest cloud in the world, Universal Cloud Credits and how to navigate through Oracle Cloud pricing, and how to save cost on Bare Metal Oracle Cloud Service with Terraform automation.
Schedule and Agenda
|1:00pm||Registration & Networking – Lunch provided.|
Richard Niemiec Keynote: Oracle Future: 12c R1 & R2 / 18c, Multitenant, Database In-Memory, Oracle Cloud, Oracle’s Autonomous Database
|2:15 – 2:30pm||
Setting up Complimentary Cloud Trial (best if you sign up the weekend before. See instructions below or email firstname.lastname@example.org for assistance.)
How to Provision your Cloud Trial
HANDS ON LAB (see details below of what you will explore)
|4:45pm||Charles Kim and Rich Niemiec: Cloud + Autonomous Warehouse Q & A|
Viscosity Oracle Cloud Sessions and Hands-On Lab
1:00 PM – 5:00 PM
Providence Health and Services (East Side)
2320 Lloyd Center Mall
Portland, OR 97232
3rd Floor. West parking lot 3rd floor – main entrance.
In this workshop, we will cover:
Oracle Cloud Infrastructure (OCI) 101
Why is OCI so different
What is OCI vs Classic
Region vs AD vs Datacenter
How to create a Virtual Cloud Network (VCN)
How to get to the Cloud
VPN topology and a Fastconnect topology
Key generation, opc account, ssh on a Mac, ssh with Putty
Compartments & Buckets
Block Storage vs object storage
How to create / calculate block storage capacity for performance
Create block storage, create file storage in cloud
What is compute
Bare Metal versus VMs
Assign network and firewall rules
Build a OS from an image
What is DBaaS
Automous vs regular DBaaS
New DB lifecycle
BM vs VM vs Exadata Cloud Service
DBaaS HOL – Build a DB
Preparing for the Cloud Hands-On Lab:
- You need to bring your own laptop
- If you are on Windows, you must have putty installed with puttygen
- Your corporate security must allow access to cloud.oracle.com
- Sign up for a free Oracle Cloud Trial to use during the lab: (We recommend this being done 1 day before the lab)
- To set up Oracle’s free Cloud Trial Visit https://cloud.oracle.com/tryit
- Click Create a Free Account and fill in the information (if you’ve done this before, you can use a new email address)Note Get USD300 of free credits good for up to 3500 hours of Oracle Cloud usage· Credits can be used on all eligible Cloud Platform and Infrastructure services for the next 30 days· Your credit card was used only for verification purposes and will not be charged unless you Upgrade to Paid in My Services
- After clicking Continue, you will get an email with a temporary password
- Click Get Started with Oracle Cloud, enter your email and temporary password and change the password.
- You are all set, and will use be able to use this account in the Hands On Lab.
Join OSWOUG and Viscosity North America for a full day of sessions on Oracle Cloud and Autonomous Data Warehouse (18c). Learn about where Oracle technology is going and how the role of the DBA is changing and how to stay relevant.
Tuesday, May 8, 2018
9:00 AM – 5:00 PM
Providence St. Vincent Medical Center
West side, Souther Auditorium
9205 SW Barnes Rd
Portland, OR 97225
Schedule and Agenda
9:00 SIGN-IN, NETWORKING. Continental Breakfast
9:30 Introductions, OSWOUG Business
9:45 Keynote : Richard Niemiec, Emerging Technologies: Innovation, Oracle Cloud, Big Data, and the Internet of Things
This session explores Oracle’s acceleration and the cycles of innovation in the world. It looks at the current big data revolution and some of the solutions out there, as well as Oracle’s big data solution. Attendees learn about the role that both Google and Facebook have played in the big data ecosystem and also how NoSQL databases such as MySQL fit in. The session also includes a look at the Internet of Things (IOT), which will drive big data even faster.
Emerging Technologies: Internet of Things (IoT)
State of the Art Cloud Platform: Big Data, Database
10:45 – 11:00 MIDMORNING BREAK
11:00 Charles Kim, Brain Overload with Oracle 126.96.36.199 / 18c New Features
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 that will change how you perform maintenance and tune the database. This session is not the traditional Oracle 12.2 database features. Be prepared to have mind overloaded with the following focused areas:
Upgrade to Oracle 12.2
Multi-Tenancy (PDB) Option
Database Upgrade Options
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.
Objective 1: Learn new features and functionality for Oracle Database New Features in 12c Release 2:
* Online Improvements
* Partitioning Option
* Multi-Tenancy (PDB) Option
* Data Guard
* General Database
Objective 2: Also learn about Oracle 12c Release 1 new features and Oracle’s patching direction with Oracle 18c
Objective 3: Attendees will learn key fundamental best practices to upgrading to Oracle 12.2
12:00 LUNCH, RAFFLE PRIZES
1:00 Fahd Saeed, Red Pill Analytics ODIEE
1:45 – 2:00 COFFEE BREAK
2:00 Rich Niemiec: The Best Oracle Database 18c New Features
This presentation will look at which 18c new features should be investigated for use. Most of the features that will be covered will be related to the DBA, but there will also be a few outside that realm that focus on the developer. There will be simple examples (such as a quick example using pluggable databases) to show the basic functionality of the new features. The speaker has been working with the Beta program over many versions of Oracle.
1. Overview of New Features including Memory Optimization for IOT, Multitenant Advances like Per-PDB Switchover, Zero Impact Grid Infrastructure Patching, Per-PDB Security, polymorphic table functions, Private Temporary Tables, Docker Support, New Installation Support, 18cXE release, Shard-aware applications, In-Memory External Tables, and Approximate Query improvements.
2. Each specific feature (such as pluggable databases)
3. Example of using specific feature (such as pluggable databases)
4. Other new features not discussed but worth considering
Objective 1: Overview of New Features
Objective 2: Each specific feature detailed
Objective 3: Example of using each specific feature
3:00 Charles Kim, Evolution and DBA 3.0
Learn how the cloud, AI and machine learning will change the database industry and how adjustments now will assist in making YOU more essential to the industry than ever before.
4:00 OSWOUG CLOSING REMARKS, RAFFLE PRIZES
4:30 NETWORKING RECEPTION
Meet the Speakers
Chief Innovation Officer, Viscosity North America
Rich Niemiec is the current Chief Innovation Officer of Viscosity North America. Rich is an Oracle Ace Director, a world renowned IT Expert, and was a co-founder and the CEO of TUSC, a Chicago-based systems integrator of Oracle-based business solutions started in 1988. Rich has served as President of Rolta TUSC and Rolta EICT.
Rich is the past President of the International Oracle Users Group (IOUG) and the current President of the Midwest Oracle Users Group (MOUG). Rich has architected and tuned many Fortune 500 systems over the past 25 years.
Co-Founder, President, Viscosity North America
Charles Kim is an Oracle ACE Director, a VMware vExpert, an Oracle Certified DBA, a Certified Exadata Implementation Specialist, and a Certified RAC Expert. Charles specializes in RAC, Exadata, Cloud, complex data replication, and virtualization and is the co-author of nine books on Oracle Database. Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft, and has over 26 years of Oracle experience on mission- and business- critical databases.
Charles presents regularly at local, regional, national, and international Oracle conferences, including COLLABORATE, VMware World, and Oracle OpenWorld, on topics of RAC, ASM, Cloud, Linux best practices, Data Guard best practices, VMware best practices, Oracle on VMware virtualization, and 7×24 high-availability considerations.
Charles is the founder and president of Viscosity North America, a niche Oracle consulting company specializing in Exadata, RAC, virtualization, and Oracle Cloud. Charles is also the president of the Cloud SIG for the Independent Oracle User Group.