I am happy to announce that I will be presenting Data Guard Best Practices and Oracle Database 12c Release 2 New Features at the next Rocky Mountain Oracle User Group Technology Day in Denver on February 9, 2017. Come learn how to bullet proof your Data Guard configurations and what’s new in Oracle 12.2. My sessions agenda will be:

Session 8 Thursday 11:15 am to 12:15 pm
What’s New in 12.2: Oracle Database 12.2 New Features

Session 10 Thursday 2:45 pm to 3:45 pm
Bulletproof Your Data Guard Environment

The Oracle Database 12.2 New Features will be a continuation of Viscosity’s 12 Days of Oracle 12.2 but will more in-depth content and code examples.

Charles Kim, Oracle ACE Director
President, Viscosity North America


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


The Oracle Cloud Experience Technology Hands-on-lab Workshop is sponsored by the Cloud Computing SIG of IOUG. We are proud to announce our participation at the Georgia Oracle User Group Tech Days on March 15-16, Atlanta, Georgia. Every attendee will be given a Kindle version of the Oracle Cloud Pocket Solutions Guide:

NewImage

The Cloud Experience Technology Hands-on-lab Workshop will start with creating a database in Oracle Cloud. We will also focus on backing up an on-premise database to the cloud and various solutions that’s available from Oracle to backup both Oracle databases and non-Oracle databases. We will discuss complete solution options that you can implement as you make your journey to Oracle Cloud.

Attendees will :
• Learn how to set up OS secure authentication, generating private and public keys
• Learn about various kinds of containers in Oracle Cloud and create a storage container to leverage for the hands-on lab
• Learn when and how to use the cloud for business projects
• Learn methods to backup databases to the cloud, configure Oracle Recovery Manager to backup to and restore from the Oracle Cloud.
• Learn methods to migrate databases to the cloud.
• Create a database in Oracle Cloud
• Communicate from on-premise to the database that resides in Oracle Cloud
• General Q & A with community experts

We will also discuss real-life solutions addressing security concerns, opening ports, creating database links/communicating with databases in Oracle Cloud, and innovations that Oracle has made to Oracle Cloud in the past 2 years.


The Oracle Cloud Experience Technology Hands-on-lab Workshop is sponsored by the Cloud Computing SIG of IOUG. Here’s what the high level agenda will look like for the Great Lakes Oracle Conference which will be held on May 17 and 18 at Cleveland, Ohio. Every attendee will be given a Kindle version of the Oracle Cloud Pocket Solutions Guide:

NewImage

The Cloud Experience Technology Hands-on-lab Workshop will start with creating a database in Oracle Cloud. We will also focus on backing up an on-premise database to the cloud and various solutions that’s available from Oracle to backup both Oracle databases and non-Oracle databases. We will discuss complete solution options that you can implement as you make your journey to Oracle Cloud.

We will also discuss real-life solutions addressing security concerns, opening ports, creating database links/communicating with databases in Oracle Cloud, and innovations that Oracle has made to Oracle Cloud in the past 2 years.

Here’s a high level agenda of the Oracle Cloud Experience HOL Workshop for the Great Lakes Oracle Conference on May 17 and 18:

01:00 – 01:30 – Introduction to Oracle Cloud and Security
01:30 – 01:45 – Login to on-premise accounts and cloud accounts

01:45 – 02:15 – Database Cloud Lecture
02:15 – 03:00 – Hands on Workshop

03:00 – 03:30 – Oracle Storage Cloud and Database Backup Cloud Lecture
03:30 – 04:00 – Hands on Lab Workshop

Normally, this is an all day lecture and hands-on-lab workshop. We have created a special condensed version for the Great Lakes Oracle Conference.

The Oracle Cloud Solution Guide addresses Oracle Cloud fundamentals, Storage Cloud, Database Cloud, and Oracle Database Backup Cloud, as a quick go-to reference guide, as seen by industry experts. Here’s the outline of the book:
Introduction to Oracle Cloud
Review Oracle Cloud Fundamentals
– Logging into the OPC (for the first time)
– Discuss how to sign up for a free trial account

Storage Cloud
Oracle Storage Cloud Service Fundamentals
Object Storage
Archive Storage
What is a Container
Defining the Replication Policy
Setting the Replication Policy

Demonstrate Cloud SIG’s curl API in action
What is curl
Obtaining the Authorization token
Creating a Container with curl
Creating an Archive Container with Curl
Uploading a file with curl
Listing the Contents of a Container
Deleting a File in a Container
How much space have I consumed so far?
Upload CLI Jar
Uploading a File Using the uploadcli.jar File

Oracle Database Cloud
Provisioning a Database
* Generating SSH Keys
SSH’ing to the Database Server as oracle
SSH’ing to the Database Server as ops and root
Opening/enabling Port 1521
Creating a Database Link Between Private Database and Public Database Cloud
Creating a Secure Tunnel with ssh
Adding Database Storage to DBaaS

Oracle Database Backup Cloud
Show students how and where to download the Database Cloud Backup Module
Installing the Database Cloud Backup Module
Configuring RMAN for Backups
Backing up the Database to OPC
Discuss how and what is needed to perform backups for Oracle Standard Edition databases
Best Practices for Backing Up to OPC
Demonstrate how to restore and recover a database from the RMAN Database Cloud Backup

Review of Oracle Storage Cloud Software Appliance
Logging into the OSCSA
Best Practices with OSCSA
Where to find additional documentation
Quick Demo of Oracle Storage Cloud Software Appliance

Posted by: Charles Kim, Oracle ACE Director


The Oracle Public Cloud Experience Technology Hand-on-lab Workshop is sponsored by the Cloud Computing SIG of IOUG. Here’s what the high level agenda will look like for the Dallas Cloud Experience Technology Day Workshop being held on December 9th, 2016 at the Oracle Las Colinas office:

09:30 – 10:00 – Check-in
10:00 – 10:30 – Registration and cloud account setup for each student
10:30 – 11:00 – Introduction to Oracle Cloud and SSH Security
11:00 – 11:30 – Hands on Lab Workshop

11:30 – 12:00 – Oracle Storage Cloud and Database Backup Cloud Lecture
12:00 – 12:30 – Hands on Workshop
12:30 – 13:30 – Provided lunch and work through lunch as needed

13:30 – 14:00 – Oracle Cloud Customer Case Study
14:00 – 14:30 – Database Cloud Lecture
14:30 – 15:30 – Hands on Lab Workshop
15:30 – 16:00 – Oracle Storage Cloud Storage Appliance Lecture and Demo
16:00 – 16:15 – Final Questions and Answers

The outline for the Cloud Experience Technology Workshop will include the following content:
Introduction to Oracle Cloud
Review Oracle Cloud Fundamentals
– Logging into the OPC (for the first time)
– Discuss how to sign up for a free trial account

Storage Cloud
Oracle Storage Cloud Service Fundamentals
Object Storage
Archive Storage
What is a Container
Defining the Replication Policy
Setting the Replication Policy

Demonstrate Cloud SIG’s curl API in action
What is curl
Obtaining the Authorization token
Creating a Container with curl
Creating an Archive Container with Curl
Uploading a file with curl
Listing the Contents of a Container
Deleting a File in a Container
How much space have I consumed so far?
Upload CLI Jar
Uploading a File Using the uploadcli.jar File

Oracle Database Cloud
Provisioning a Database
* Generating SSH Keys
SSH’ing to the Database Server as oracle
SSH’ing to the Database Server as ops and root
Opening/enabling Port 1521
Creating a Database Link Between Private Database and Public Database Cloud
Creating a Secure Tunnel with ssh
Adding Database Storage to DBaaS

Oracle Database Backup Cloud
Show students how and where to download the Database Cloud Backup Module
Installing the Database Cloud Backup Module
Configuring RMAN for Backups
Backing up the Database to OPC
Discuss how and what is needed to perform backups for Oracle Standard Edition databases
Best Practices for Backing Up to OPC
Demonstrate how to restore and recover a database from the RMAN Database Cloud Backup

Review of Oracle Storage Cloud Software Appliance
Logging into the OSCSA
Best Practices with OSCSA
Where to find additional documentation
Quick Demo of Oracle Storage Cloud Software Appliance