Navigating Oracle 12c Databases in the Oracle Cloud

Many organizations are now embracing the cloud in order to help reduce their operational costs, but the notion of migrating an Oracle 12c multi-tenancy database from on-premise to the Oracle Cloud may seem like a daunting proposition.

According to a recent IOUG survey conducted by Unisphere Research and sponsored by Oracle, enterprise customers increasingly see a future with hybrid approaches, including a combination of private and public cloud resources. And, as the number of cloud services within enterprises grows, the survey finds there will be more reliance on both for cost mitigation, as well as backup and continuity. “Cloud is increasingly seen as a highly agile and robust platform for enterprise application development. More development work is going to the cloud,” writes Joe McKendrick, Unisphere Research lead analyst. “Database backup and disaster recovery, along with enterprise applications are the areas seeing the greatest returns from cloud implementations.”

The prospect of doing so requires a dramatic shift in the way users do their jobs – from performance testing, to administration, to management, and ongoing maintenance.

John Pocknell, senior product manager at Quest Software, recently discussed how to tackle migrating Oracle 12c database to the Oracle Cloud during a DBTA webcast.

According to Pocknell, Oracle Database Cloud Service offerings include pre-packaged elastic DB services for dev, test, and prod; Oracle Database Cloud Service Bare Metal with a choice of four editions on two Bare Metal dedicated hardware;  Oracle Database Exadata Cloud Service which is a high performance solution for business-critical applications; Oracle Database Exadata Cloud Machine with pre-installed Oracle Cloud; and Oracle Database Exadata Express Cloud Service with Medium performance solution for SMBs.

Additionally, Amazon also offers solutions for Oracle databases, Pocknell said.

To create an Oracle database in the cloud, users can follow several simple steps once they sign in to their account. Users will have to create a VM Public Key to access the VM on the cloud, Pocknell explained.

General users can create one using a free utility called PuTTY. After the key is generated, users will have to save the private key and create a new file that will allow users to connect to the database.

Pocknell also outlined how users can move a pluggable database to the Oracle cloud, how to one-step schema copy to an Oracle cloud database, and how to move data into the Oracle cloud database, and performance testing in the Oracle cloud database.

An archived on-demand replay of this webinar is available here.