About admin

I have been proud for the past 4 years to be the only person in the world who held the highest designation from both Oracle and VMware as the Oracle ACE Director and VMware vExpert at the same time.  This week, I am proud to announce that Nitin Vengurlekar (@dbcloudshifu) joins me in this designation.  We are known in both industries for our technical aptitude, authoring books, blogging and speaking at national/international conferences.  

I am also excited to announce that I was accepted into the VMware vExpert program for the 5th consecutive year for the 2017 calendar year.  This year will be Nitin’s first year as a VMware vExpert.  We, at Viscosity North America, are very excited and honored to be the only company in the world who house 2 individuals that hold titles of Oracle ACE Directors and VMware vExperts.

Posted by Charles Kim, Oracle ACE Director and VMware vExpert

Twitter: @racdba

 

 



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



Installing Docker for Mac is super easy. It is a simple as downloading and copying the program to the application folder.

To download Docker for Mac visit the docker site:
https://docs.docker.com/docker-for-mac/

Please download the stable release.

NewImage
Simply Drag and Drop the Docker icon to the Application folder. It is that easy to install Docker on the Mac.

Launch Docker from the applications folder. Since this is the first time you are invoking Docker, you will get the standard message about Docker being an “… application downloaded from the Internet. Are you sure that you want to open it?” Click on the Open button.

NewImage

At the Welcome screen, click on the Next button

NewImage
Click on the OK button to allow for privileged access.

You will be asked to provide your password. Enter your password to finish the installation process. Now, you will see docker on your task bar on top of the screen.

NewImage

Optionally un-select the Send diagnostics & usage data check box; click on “Got it” button to complete the installation.

Now from any terminal, type the following commands:

Dobbys-MacBook-Pro:~ Dobby$ docker ps
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS              PORTS               NAMES
Dobbys-MacBook-Pro:~ Dobby$ docker info
Containers: 0
 Running: 0
 Paused: 0
 Stopped: 0
Images: 0
Server Version: 1.12.3
Storage Driver: aufs
 Root Dir: /var/lib/docker/aufs
 Backing Filesystem: extfs
 Dirs: 0
 Dirperm1 Supported: true
Logging Driver: json-file
Cgroup Driver: cgroupfs
Plugins:
 Volume: local
 Network: null host bridge overlay
Swarm: inactive
Runtimes: runc
Default Runtime: runc
Security Options: seccomp
Kernel Version: 4.4.27-moby
Operating System: Alpine Linux v3.4
OSType: linux
Architecture: x86_64
CPUs: 4
Total Memory: 1.951 GiB
Name: moby
ID: YGJ4:TIP6:KYX5:EK5X:REV3:3KEL:O3AP:6UIF:2DGX:YYDR:OGCX:QOSY
Docker Root Dir: /var/lib/docker
Debug Mode (client): false
Debug Mode (server): true
 File Descriptors: 15
 Goroutines: 27
 System Time: 2016-11-19T15:45:11.894167372Z
 EventsListeners: 1
No Proxy: *.local, 169.254/16
Registry: https://index.docker.io/v1/
WARNING: No kernel memory limit support
Insecure Registries:
 127.0.0.0/8

Next, click on the Docker logo on the top status bar and select Preferences. Move the memory indicator to 4GB or more and click the restart button at the button of the screen.


Here’s a simple script that anyone can use to check for lags in Data Guard. Basically, there’s two kind of lags in Data Guard that we want to monitor. The first is the apply_lag which is the amount of time the standby database is lagging behind relative to the primary database due to application of redo data. The second is the transport_lag which provides information about how much redo data is behind (in terms of time) because it is not available or applicable on the standby database. The transport lag can be used to determine bandwidth issues between the primary and stanby database sites.

You can specify the MIN_THRESHOLD parameter which will be the 2nd parameter that is passed into the dg_check_lag.ksh script (below). For lot of our customers who are on Active Data Guard, we change this script to determine seconds that the transport and apply lag is behind by. It is common for us to send alerts when the transport or apply lag is greater than 30 seconds for Active Data Guard customers.

Stay tuned as I will reveal scripts to monitor gaps in archive log sequences. I use the term gap loosely here as it is not determining the gap from v$archive_gap but looking at the number of applied archive logs on the standby database and comparing the applied archive logs to the maximum sequence number based on the thread number.

Come visit Viscosity North America for latest updates to local events, white papers and case studies.