Skip to content

Category: Cloud Basics

Oracle EBS on Oracle Cloud – The changing role of Oracle DBA

Oracle E-Business Suite is one of the most comprehensive suite of integrated, global business applications used by many organization around the globe. Clients usually host E-Business Suite environment In-house which requires upfront investment and ongoing maintenance costs. This approach is proven to be non-scalable and non-flexible for the rapidly changing business needs. Cloud solutions are the way to go for these applications. Oracle Cloud Solutions with all their features and integrated security can handle the robust and complex architectures of the E-Business suite seamlessly. Oracle EBS on cloud can help organizations with its scalability, elasticity and performance at much lower costs.

[Post Views: 459]

1 Comment

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

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 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.

[Post Views: 159]

Leave a Comment

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

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.

[Post Views: 218]

1 Comment

Transparent Data Encryption (TDE) – Oracle Database Cloud

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.

[Post Views: 128]

Leave a Comment

Oracle Database Cloud Services – Concepts

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.

[Post Views: 110]

Leave a Comment

Resizing the Instance – Oracle Compute Cloud

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.

[Post Views: 131]

1 Comment

Oracle Cloud ‘Orchestrations’ – working example

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.


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.

[Post Views: 82]

1 Comment
error: Alert: Content is protected !!