Select Page

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


2:30pm Charles Kim:

Setting up Complimentary Cloud Trial (best if you sign up the weekend before.  See instructions below or email 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

Setup Networking
How to create a Virtual Cloud Network (VCN)
How to get to the Cloud

Networking 101
Availability Domains
VPN topology and a Fastconnect topology

SSH 101
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
Boot Storage
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:

  1. You need to bring your own laptop
  2. If you are on Windows, you must have putty installed with puttygen
  3. Your corporate security must allow access to
  4. Sign up for a free Oracle Cloud Trial to use during the lab:  (We recommend this being done 1 day before the lab)
    1. To set up Oracle’s free Cloud Trial Visit
    2. 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
    3. After clicking Continue, you will get an email with a temporary password
    4. Click Get Started with Oracle Cloud, enter your email and temporary password and change the password.
    5. You are all set, and will use be able to use this account in the Hands On Lab.

Tuesday May 8, 2018 OSWOUG Conference:  Register Now

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.

OSWOUG Conference

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 / 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:

Oracle 18c
Upgrade to Oracle 12.2
Online Improvements
Partitioning Option
Multi-Tenancy (PDB) Option
Data Guard
General Database
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


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

DBA 2.0 is Dead. How do we embrace DBA 3.0 with the Oracle Autonomous Data Warehouse Cloud? Oracle 18c?
Oracle Autonomous DW Cloud is the talk of the year. With databases becoming self-healing, self-patching, self-tuning, and self-securing, Oracle professionals fret about their future and the state of direction for the industry. Learn how you can prepare to evolve and adapt to the Changing Role of the DBA with Charles Kim and the components that make up the Autonomous Database.

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.



Meet the Speakers

Rich Niemiec

Rich Niemiec

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.

Charles Kim

Charles Kim

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.

Providence St. Vincent Medical Center

 9205 SW Barnes Rd
Portland, OR 97225

Get In Touch


    Share This