What is the Oracle Storage Cloud Software Appliance?
In a nutshell, the Oracle Storage Cloud Software Appliance serves as a cloud storage gateway to easily connect on-premise applications/data shares/workflows to Oracle Storage Cloud Service.

What is the Hardware Requirements
• 2 Cores
• 4GB of memory

What is the Software Requirements
• Oracle Linux 7 with UEK Release 4 or later
• Docker 1.8.3 or later. For information on Docker, please visit https://www.docker.com/.
• At least on NFS version 4.0

Installing Oracle Linux 7.2
Choose to option to Install Oracle Linux 7.2 and hit the enter/return button

Accept the default to install the English language and Click on Continue


Select on the Date & Time area to modify the default timezone for the VM.
We are changing our timezone from New York to Chicago
You can choose to enable NTP at this time
Click on the Done button when you are complete to take you back to the previous screen.

If you scroll down, you will see the Network & Host Name in the SYSTEM section. Click on the Network & Host Name part of the screen.

Change the Host name
Click on the Off switch on the far right corner to enable the Ethernet network
Click on the Done button when you are complete to take you back to the previous screen.

We will choose to keep the Minimal Install option.

For this particular installation, we will keep the “Automatic partitioning selected” option but it is required for you to navigate to the Installation Destination screen to validate that is what you choose:
By default, in the Partitioning section, the Automatically configure partitioning option is chosen. You can configure /root, /, /tmp/, swap and other file systems but for this configuration, we will choose the Automatically configure partitioning option and click on the Done button.

Now the Begin Installation button will be enabled. You are ready to start the installation.

While the installation is in progress, we will want to set the root password. NewImage

In the Root Password screen, we created the root password:
Because our password is weak, we will be asked to click on the Done button twice.

When you are routed back to the previous screen, you can optionally create additional users.


When the installation is complete, you will be asked to Reboot the VM. You will be asked to accept the license agreement.

This year will be my 10th consecutive year as a speaker at Oracle OpenWorld. I will focus on Oracle Cloud, Oracle Cloud and More Oracle Cloud. I will also be speaking at the 1/2 day Cloud Experience Technical Workshop (formerly known as Cloud Attack at the IOUG – Independent Oracle Users Group conference) with several other ACEs and ACEDs from The Oracle ACE Program on behalf of the Cloud SIG. We have a lot of preparation to do for updating our content for the Cloud Experience Technical Workshop.

OOW Speaker Header

For the Backup to the Cloud and Beyond session, we are thinking outside the box and delivering a solution that will handle both Oracle related files and non-Oracle files. Here’s the abstract to the session:

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.

In this session, we will reveal how Viscosity provides end-to-end backup solutions to Oracle Cloud. We will present a deep-dive content of backing up the database to the Oracle Cloud. We will go into extensive details on backing up non-oracle files to Oracle Cloud. We will demonstrate various methods to uploading and downloading various types files (including RMAN) to the Cloud and how to drive performance.

Stay tuned for additional details to my deep-dive session on Back Up to the Cloud and Beyond and for the Cloud Experience Technical Workshop.

Remember the number 33. I always seem to forget the $33 per TB per month number as I talk with potential customers. For a mere $33.00 / TB / Month, you can backup your Oracle Databases to the Oracle Public Cloud. For this low amount you get:

  • Unlimited Oracle Database backups
  • Automatic three-way data mirroring
  • Regional data isolation
  • Transparent access via Oracle Database Cloud Backup Module and Recovery Manager (RMAN)
  • RMAN encryption and compression

Performing backups to the cloud is a no brainer. Everyone should be considering backing up their database to the cloud.

Posted on July 27, 2016

Here’s an example to create a user account for Charles:

/usr/sbin/groupadd -K GID_MIN=500 -K GID_MAX=10000 ckim
/usr/sbin/useradd -g ckim -K UID_MIN=500 -K UID_MAX=10000 -c "Charles Kim" -d /home/ckim -m -s /bin/bash ckim

Then here is another example of creating a user for David:

# set -o vi
# for i in dknight; do groupadd -K GID_MIN=500 -K GID_MAX=10000 $i; /usr/sbin/useradd -g $i -K UID_MIN=500 -K UID_MAX=10000 -d /home/$i -m -s /bin/bash $i ; chage -d0 $i;echo "newpassword" | passwd --stdin $i;done
Changing password for user dknight

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.

Are you up on Oracle new features? Are you considering pluggable databases? Let’s take a look at the new features that Oracle introduced in Even though this is not a major release of Oracle, it is still packed with new features, especially in the world on multi-tenancy. The enhancements made to pluggable databases are really attractive. Here’s a brief overview of the new features in pluggable databases:

  • FDA Support for CDBs
  • PDB Containers Clause
  • PDB File Placement in OMF
  • PDB Logging Clause
  • PDB Metadata Clone
  • PDB Remote Clone
  • PDB Snapshot Cloning Additional Platform Support
  • PDB State Management Across CDB Restart
  • PDB Subset Cloning

Every DBA should know how to leverage these commands. DBAs need to add this list of commands in their arsenal.


Additional commands for your toolkit:
free –g (Memory free in Gigabytes)
free –g –s 1 (Display free in Gigabytes, update every second)

sar -u 2 10 (Report CPU utilization for each 2 seconds. 10 lines are displayed.)