• 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

  • 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

    Tags: , ,

  • Did you miss yesterday’s IOUG session with Oracle Aces about backing up to the cloud? Don’t worry! At the beginning of October, there will be a review of all you missed at Open World.

    screen-shot-2016-09-19-at-10-23-28-am

    screen-shot-2016-09-19-at-10-23-49-am

    screen-shot-2016-09-19-at-10-26-12-am

  • On Monday, September 12, from 11am-12pm CT join Charles Kim and Nitin Vengurlekar for a webinar previewing Oracle Open World.

    Let us challenge your thoughts about backing up files to Oracle Cloud. Every customer should be considering RMAN backups of their databases to Oracle Cloud (if not already). Backing up the Oracle database to the cloud is just the tip of the iceberg. You have to think outside the box and consider the entire solution and include the non-database files such as middleware backups, documents, reports, logs, etc.

    To register click here.

  • Join us during Oracle Open World, for an Oracle ACES and IOUG Cloud SIG event over Oracle Database Cloud Capabilities on September 18th, from 8-12.

    Start your journey to the Oracle Cloud here, with this intensive Hands On Lab session that will walk you through an Oracle Cloud services trial. Learn how to setup and configure the cloud and migrate data from an on-premise Oracle Database 12 implementation to the cloud. Create a storage container, set up OS secure authentication, and configure RMAN to use the Oracle cloud.

    Agenda:
    8:00 am PT – Registration, Introductions, workshop account setup and instruction.
    8:30 am – 12:00 pm PT – Leader guided cloud instruction with use cases, hands on exercises using Oracle Cloud
    11:15 pm PT – Luncheon for registered attendees
    12:00 pm PT – Wrap up

    To sign up, visit here.

  • This post is a small deviation from the original article written by Steven Lemme, Oracle Corporation from the following site:
    https://blogs.oracle.com/managementpartner/entry/get_hands_on_cloud_experience

    We had a great success with our first Cloud Attack at Independent Oracle Users Group Collaborate 2016 conference.

    2016 04 10 15 36 28

    Members of the IOUG Cloud SIG executed their first Cloud Attack hands on bootcamp workshop experience. Leveraging experience from highly successful RAC Attack workshops, the objective was to use the public Oracle Cloud so attendees could quickly get underway getting live hands on Cloud skills & experience. In fact, the workshop addressed top feedback from a survey in the Collaborate 16 general session and participants enabled with Cloud skills they could start using when they returned back to their offices after the event. By using the Oracle Cloud, attendees only needed to bring a device to participate. One attendee was amazed when he finished the workshop using an old Windows XP PC with 1GB of RAM and this gentleman below completed it all from his iPad. And with Cloud, attendees could virtually be anywhere, connect and go without the instructors having to procure and prep a room full of PC’s or worry who’s laptop had enough storage, RAM, or CPU to load a virtual image.

    Prior to Collaborate 16, a lot of hard work and planning was done behind the scenes by volunteer customer and partner experts to execute this first workshop in Las Vegas. Erik Benner – Mythics, Charles Kim –Viscosity North America, IOUG Board members Troy Ligon – American Express and Seth Miller -Veritas, Kai Yu – Dell, Rene Antunez – Pythian, supported by Pat Shuff, Steven Lemme, Laura Ramsey of Oracle.

    The IOUG conference committee and staff such as Alexis Bauer Kolak provided a perfect setting for attendees with a large space, power, and AV so attendees could drop in and get started.

    Attendees arrived early in the morning but eager for a full day of hands on in the Oracle Cloud and objective of starting from an on-premise environment to going onto the Oracle Cloud and working with Oracle Database 12c, backing up to the Oracle Cloud and learning how to take advantage of Oracle Database 12c Multitenant and movement of a PDB from a Cloud environment back to on-premise. The workshop kicked off by an agenda, objective and goals review followed then by Erik Benner getting everyone hands-on with a refresher on SSH connectivity from the conference center.

    Erik Benner and Charles Kim, Oracle ACE Director, tag teamed as instructors while the other Cloud SIG volunteers went around the room helping attendees with their workshop activities and questions. It was not just about completing the exercises, but the actual experience learned while doing them along with help from peers. Here we see attendees following along with Charles Kim on a live demonstration on the Oracle Cloud of what they are about to perform themselves.

    And so attendees could maximize their training while away from the office, the Oracle Technical Network sponsored an amazing lunch onsite.

    2016 04 10 12 03 26

    As the workshop progressed, Cloud Attack T-shirts sponsored by Mythics were unboxed as further incentive for attendees to interact with questions.

    2016 04 10 10 06 51

    When it came to the end of the scheduled workshop time, several attendees asked if they could stay longer to gain more hands on experience and so volunteer instructors stayed an extra hour until the last attendee departed. Upon completion of the workshop several attendees commented on the great experience they had and later during the week Cloud SIG volunteers received many more positive comments. So the Cloud SIG is now looking into doing the next one at Oracle OpenWorld 2016 in San Francisco. Stay tuned to the Oracle Cloud SIG website for updates to upcoming events.

  • IOUG Collaborate16 Comments Off on COLLABORATE 16 – Cloud Innovation & Best Practice Competition

    Have Cloud Talent? Share It & Get Recognized!

    Oracle customers and partners may submit their best use of Oracle Technology through the Oracle Cloud for judging, award, and recognition at Collaborate April 10-16, 2016, by the Independent Oracle User Community Cloud SIG. This is an opportunity to be featured and possibly published as a best practice to your peers and overall Oracle user community.

    To participate in this opportunity to showcase your company’s innovation and your skills, submit your use case or best practice by March 24th 2016

    General Guidelines

    Members of the IOUG and other Oracle Global User Community

    Members can enter, as well as any attendees of COLLABORATE 16.

    Onsite attendance to COLLABORATE 16 is not mandatory to submit an entry; however the finalists will be notified two weeks prior to the event and invited to present their entry onsite to the Cloud SIG judges and a live audience in a session at COLLABORATE 16.

    Entries must involve use of the Oracle Cloud. Entries which include a hybrid of Oracle Cloud and on-premises Oracle product technology are also eligible.

    Participants can utilize their own Oracle Cloud subscription or an Oracle Cloud trial subscription.

    Initial judging and selection of finalists will be performed by IOUG Cloud SIG Leadership. Finalists will be judged by IOUG Cloud SIG Leadership and attendees of the IOUG COLLABORATE session on Thursday, April 14.

    Judging categories will be finalized based on submissions.

    Examples of potential categories would be:

    • Best solution or innovative resolution to a business problem
    • Best Oracle Cloud Marketplace App
    • Best DevOps or Dev/Test example
    • Most innovative use of Oracle Cloud Database Service
    • Most innovative use of Oracle Cloud Platform (Java, Fusion, Mobile, IOT, OMC, etc…)
    • Honorable Mention – best entry from offsite COLLABORATE 16 “virtual” attendee
  • Session Title: Cloud Attack !!
    Session Number: 1588
    Session Type: Pre-Conference Workshop

    A boot camp design by Oracle User Community Technology Experts for Oracle Technology Professionals to experience uses of the Oracle Public Cloud and Oracle Technology on-premise to accomplish work critical for their businesses and careers.

    Attendees in this session will enhance their skills and job relevancy by gaining new knowledge and skills using the Oracle Public Cloud within their job role through actual use cases and hands on lab work.

    Speakers will detail how backup to the cloud can be used to meet different needs of their organization and how to justify use of new technology within their business. Learn how to create a storage container, setup OS secure authentication and configure RMAN to use the Oracle Cloud. Perform a backup to the Oracle Cloud and recover from it back to your on-premise server. Learn how to migrate from an on-premise Oracle Database 11g to a pluggable Oracle Database 12c (PDB) in the Oracle Cloud. Then move a PDB in which Developers have completed their work in the Oracle Cloud back on-premise and into production.

    Learning Objective #1:

    Learn the best practices to create an on-premise private database cloud including a self-service catalog

    Learning Objective #2:

    Attendees will learn how to migrate databases to OPC with technologies like RMAN, Data Pump, Pluggable Database (PDB), Snapshot clones, and Data replication technologies like GoldenGate and help you understand which way is the best solution for you

    Learning Objective #3:
    Learn how to migrate from an on-premise Oracle Database 11g to a pluggable Oracle Database 12c (PDB) in the Oracle Cloud.

    Outline / Content Structure:
    A. SIG leaders will speak on the following topics:
    1. Private Database Cloud – what you need to implement Private Database Cloud
    2. Considerations to adopt Hybrid Cloud
    3. Oracle Public Cloud – Evolution of OPC
    4. Use cases for OPC

    B. Perform hands-on lab to Learn ins and out to Backup as a Service
    1. Create storage containers in OPC
    2. Setup your OS to setup secure authentication to OPC
    3. Setup RMAN configuration for OPC
    4. Backup your database to the cloud and restore/recover the database to any server

    C. Perform hands-on labs to Rapidly Provision Databases in OPC
    1. Move databases from on-premise to OPC
    2. Learn how to plug and un-plug databases (PDB) into OPC

    D. Perform hands-on labs to secure access to the database in the cloud
    1. Learn security best practices in OPC

  • IOUG Collaborate16 Comments Off on Data Guard Attack!!

    Session Title: Data Guard Attack!!
    Session Number: 1580
    Speakers: Charles Kim, Oracle ACE Director and Nitin Vengurlekar, Oracle ACE Director
    Track: Database
    Session Type: Hands-on Lab
    Sub-Categorization: High Availability & Data Protection

    Abstract
    There is no reason why Data Guard setup, configuration, maintenance and monitoring cannot be setup As A Service. Automation is the crux of any rapid deployment and cloud models. Setting up Data Guard should be a service catalog for any DBaaS deployment.

    You will also learn the new Data Guard features available in Oracle Database 12.2

    Download the latest and greatest Data Guard automation toolkit from http://dbaexpert.com/dg/ prior to attending this session. We have incorporated industry best practices to the DG Toolkit. This session will disseminate fundamental Data Guard best practices and demonstrate how DBAs can automate setup, configuration, and monitoring of Data Guard environments with assistance from the Date Guard Toolkit (DG Toolkit).

    In this hand-on deep dive session, we will go through step by step details of setting up Data Guard with the automation toolkit:
    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

    Learning Objectives:

    1. Most importantly, learn how to build the physical standby with ease and automation using the DG Toolkit
    2. Learn how to monitor the physical standby database with DG Toolkit
    3. Learn how to monitor the physical standby database with DG Toolkit

    Outline / Content Structure:
    Perform preliminary check prior to starting the Data Guard Build
    1. Perform assessments on the source database
    2. Perform assessments on the physical standby

    Perform detailed steps to build the physical standby database
    1. Look at building the physical standby with easy menu steps
    2. Look at duplicating the physical standby database

    Configure the Data Guard Broker

    Perform monitoring of the Data Guard Environment
    1. Monitor the physical standby for performance
    2. See how far behind we are

    Perform RMAN to disk configuration options