Skip to content

Category: Oracle Cloud Basics

Migrating on-premise 12c pluggable database to Oracle Cloud Database

Published January 7, 2017 By Brijesh Gogia

In this post we will explore one of the method for moving your on-premise database to the Database Cloud Service. There are multiple options for solving this data movement challenge. In this post our focus will be to use SQL*Developer and command line tools to clone and move a pluggable database from our on-premise database to our cloud database. Pluggable databases is a feature of Oracle database 12c. We are using version 12.1.0.2 of Oracle database 12c.

There can be other simpler methods also if you have infrastructure/network in place to connect from your cloud databse to your on-premise database directly, like:

  • Using OEM, you can do this work very easily in a few click-and-watch steps.
  • Using DBLINK. This is the also one of the easiest way
  • Using SQLDVELOPER and choosing “Clone PDB to oracle Cloud” option. All required ports b/w on-premise and Oracle Cloud must be open and network/firewall related requirements must be met to use this option.

For this example we are using SQL Developer to clone the PDB but will not be using direct “Clone PDB to Oracle Cloud” option. We will be making a clone copy of the on-premise database, unplug it, copy over the data files to Oracle Cloud and plug it there.

Continue ReadingMigrating on-premise 12c pluggable database to Oracle Cloud Database
Leave a Comment

Clone Oracle 12c Pluggable database from one Oracle Cloud Service to another

Published January 5, 2017 By Brijesh Gogia

In this post we will be cloning  an Oracle Database 12c Pluggable Database from one Database Cloud Service to another.

We can have multiple options for doing this data migration. For our example we will use remote cloning of a PDB using Database Links. Note that this post will use the unique features of Oracle Database 12c Multitenant and Pluggable Databases (PDB). This was a new and the key feature of Oracle 12c which is not present in Oracle database version 11g.

Continue ReadingClone Oracle 12c Pluggable database from one Oracle Cloud Service to another
2 Comments

Transparent Data Encryption (TDE) – Oracle Database Cloud

Published December 31, 2016 By Brijesh Gogia

Transparent Data Encryption (TDE) has been a standard feature of Oracle database for quite a long time. Since database in cloud is increasingly becoming popular so this feature has taken a great importance keeping in mind that primary concerns that administrators have in keeping data in cloud (remote) servers is security.

Oracle Advanced Security Transparent Data Encryption (TDE) stops would-be attackers from bypassing the database and reading sensitive information from storage by enforcing data-at-rest encryption in the database layer. In this post we are going to demonstrate how the Transparent Data Encryption ensures that the data stored in the Oracle Database is protected and cannot be accessed from malicious users that have gained access at the OS level.

Continue ReadingTransparent Data Encryption (TDE) – Oracle Database Cloud
2 Comments

Oracle Database Cloud Services – Concepts

Published December 30, 2016 By Brijesh Gogia

Oracle compute, storage and network services that we discussed earlier in this website are part of Infrastructure as a Service (IaaS).

In this post we will briefly discuss about Oracle database cloud services which is part of Platform as a Service (PaaS). PaaS contains some of the platform services like Database, Business Analytics, Application Development (Java, Mobile,Messaging etc), Integration, Content and Collabration etc.

In simple words , Oracle Database Cloud Service offers elastic database services for application development, test and production deployment. The service delivers an easy to use web console user interface and RESTful API to provision and administer Oracle Database on Oracle Compute Cloud Offerings. When you create database deployments, Database Cloud Service creates compute nodes to host the database, using computing and storage resources provided by Oracle Compute Cloud Service. Additionally, it provides access to the compute nodes (and thus to the database) using networking resources provided by Oracle Compute Cloud Service.

Continue ReadingOracle Database Cloud Services – Concepts
Leave a Comment

Resizing the Instance – Oracle Compute Cloud

Published December 29, 2016 By Brijesh Gogia

If you find that your application workload has increased and you would like to add OCPUs and memory to your instance then you can do it with few easy steps. Oracle Cloud portal is very user-friendly and resizing the instance can be done without much efforts.

When you create an instance using the Create Instance wizard, one or more orchestrations are created automatically to manage the instance and its associated resources.

Continue ReadingResizing the Instance – Oracle Compute Cloud
1 Comment

Oracle Cloud ‘Orchestrations’ – working example

Published December 29, 2016 By Brijesh Gogia

Orchestration is the automated management of your system components for high availability, monitoring, and persistence. It ties together the components you create into a single, manageable collection. For example, with orchestration you can associate networks, network security, and storage with the instantiation of a virtual machine. This instantiation can be restarted automatically if it terminates for some reason, or it can be monitored.

To read about basic concepts of Oracle Cloud ‘Orchestrations’ read this post first.

STEP 1: CREATE REQUIRED ORCHESTRATION JSON CODE FILES

In this post, we will be creating one master orchestration JSON file named master.txt and two nested orchestration JSON files named volume.txt and instance.txt.

volume.txt and instance.txt will be called from inside the master.txt orchestration JSON file.

Continue ReadingOracle Cloud ‘Orchestrations’ – working example
1 Comment