Skip to content

Category: Oracle Cloud Basics

Oracle Cloud Infrastructure (OCI) – 3 – Concept of Compartments

To organize your Oracle Cloud resources you will create couple of compartments. Your goal of creating compartment is to have ease of management, security, isolation of resources.

When your tenancy is provisioned, a root compartment is created for you. Your root compartment holds all of your cloud resources.

Before we plan to create a new compartment under our root compartment we should understand some key points and best practices related to compartments.

Some key points that you keep in mind related to compartments are:

[Post Views: 65]

Leave a Comment

Oracle Cloud Infrastructure (OCI) – 2 – Console

Let us look at the Oracle Cloud Console in this post. Go to and sign up for the Free Oracle Cloud Promotion. Please note you will need to add your credit card number but it will not be charged.  There is no charge unless you choose to “Upgrade to Paid” from “My Services” console page.

Once your trial account is created you will become a tenant in Oracle Cloud Infrastructure. Oracle will send you a Welcome email which will have userid/password detailed to login to your “tenancy”.

Oracle Cloud Infrastructure supports the latest desktop versions of Google Chrome, Microsoft Edge, Internet Explorer 11, Safari, Firefox, and Firefox ESR. Note that private browsing mode is not supported for Firefox, Internet Explorer, or Edge. Mobile browsers are not supported.

[Post Views: 43]

Leave a Comment

Oracle Cloud Infrastructure (OCI) – 1 – Fundamentals

Cloud infrastructure is the most basic products delivered by cloud computing companies through the infrastructure as a service (IaaS) model.  You can create your own IT infrastructure complete with processing, storage and networking resources. Cloud Infrastructure companies provide you flexibility in infrastructure design so these infrastructure setups can be easily set up, replaced or deleted as opposed to a physical one, which requires manual work.

[Post Views: 48]

Leave a Comment

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
error: Alert: Content is protected !!