I feel like I barely made it alive this week. My crazy life started out on Sunday evening as I delivered a webinar for the New Zealand and Australia Oracle User Group on Backing Up Your Oracle Databases to the Cloud. Because the target audience was in Australia and New Zealand, my webinar was scheduled for 7PM on Sunday. Immediately next day afternoon, I delivered another presentation for Database Trends and Applications on Database Replication for Zero downtime Migrations, High Availability and Disaster Recovery presentation leveraging SharePlex. I haven’t delivered a speech on SharePlex and Data Replication since 2000 at IOUG in Orlando. The turnout for this event was great!

Next day, I flew to San Francisco to deliver the full-day Hands-On-Lab workshop on Oracle Cloud on Wednesday. This is our featured workshop that we deliver for the Oracle Cloud SIG on behalf of the IOUG – Independent Oracle Users Group sponsored by the Northern California Oracle User Group. There was lot of content that had to be updated and lot of new content on Oracle Ravello Cloud and Bare Metal Cloud Services that had to be added.

On Thursday, I delivered the keynote at the Northern California Oracle Users Group (NoCOUG) on Why You Need to Consider Upgrading to Oracle Database 12c Release 2 (Oracle 12.2) to Securely and Easily Migrate to Oracle Cloud. This was my first time presenting for NoCOUG and the turnout was great. After my keynote, I also sat on the Expert Panel on Oracle Cloud fielding questions from the audience.

I do not think I want to repeat a week like this again. On a positive note, I did get to meet a lot of experts from our industry. If you would like to download a copy of any or all of the presentations, please feel free to visit our Viscosity North America website. I feel like this crazy presentation life style is becoming more and more of a norm for me these days. I do enjoy doing the research and geeking out with fellow Oracle technologists.

Posted by Charles Kim, Oracle ACE Director


I am happy to announce that I will be presenting Data Guard at the next Arizona Oracle User Group in Phoenix on January 26, 2017. At January’s AZORA meeting we’ll have a total of four presentations; two sessions running at the same time in different rooms.

Bring a partner to make sure your organization does not miss out on any of the content. We’ll have pizza for lunch and cookies later in the day thanks to the generosity of OneNeck IT Solutions and Viscosity North America.

Once again, Republic Services will host (thank you Republic) in two of their brand-new training rooms on the first floor.

When: January 26, 2017 (Thursday) 12:30 pm – 4:00 pm

Where: Republic Services
1st Floor Training Rooms
14400 N 87th St (AZ101 & Raintree)
Scottsdale, AZ

Agenda:

12:30 – 1:00 Registration and Pizza
1:00-1:10 Welcome
1:10-2:10 Presentations

Room 1 Biju Thomas – OneNeck IT Solutions (Oracle ACE Director)
“Oracle Database 12c New Features for 11gR2 DBA”

Room 2 Charles Kim – Viscosity North America (Oracle ACE Director)
“Bullet Proof Your Data Guard Environment”

Here’s the summary to what I will be presenting:

Compliance to industry best practices can easily be achieved. 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 set up, 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 Integrating Data Guard with OEM 13c
o What’s new in Oracle Data Guard 12.2

2:10-2:25 Break – Coffee & Cookies

2:25-3:25 Presentations

Room 1 Biju Thomas – OneNeck IT Solutions (Oracle ACE Director)
“Introduction to Oracle Databases in the Cloud”

Room 2 Jerry Ward – Viscosity North America
“Building Faceted Search Navigation in APEX with Oracle JET and PL/SQL Pipelines”

3:25-3:30 Wrap Up and Closing


Here’s some of my favorite Oracle Database 12.2 Multitenant new features that I can talk about at this time. Oracle Database 12c Release 2 is slated to go live sometime this year.

Pluggable databases

  • The number of PDB limits per CDB increases to 4096 rom the limit of 252 PDBs in 12.2. Even though we do not have customers who have over 252 PDBs or even venture in this high number of PDBs, Oracle raised this limit in 12.2.
  • Resource manager will have the capability to limit the memory and govern CPU and I/O.  For RAC (or RAC One Node) services associated to a PDB, oracle will not have interconnect overhead
  • In 12.2, we will no longer need to to put the PDB in read-only mode to perform hot clones.  
  • We can refresh PDBs online.  
  • We can relocate PDBs without any downtime.  We can move PDBs from one CDB to another.  Larry Ellison in OOW 2015 did a live demo and moved a PDB from on-premise to Oracle Public Cloud.  12.2 eliminates the need to put the PDB in read-only mode.
  • Proxy PDBs are introduced.  We can have a new kind of a PDB which points to a remote PDB.  The remote PDB is presented as a local PDB and in all practical purposes looks like a local PDB with all functionality is available to the Proxy PDB.
  • All new Application Containers are introduced. Oracle revolutionizes the concept of having a single master application definition for all the tenant containers. We can make changes to just location and changes will sync to all the tenant container.