Skip to content

Expert Oracle Posts

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: 169]

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: 99]

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: 88]

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: 105]

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: 74]

1 Comment

Opening ports between Oracle Compute Cloud Service instances.

After we have created our oracle compute virtual machine our next goal is to get our application installed on those virtual machines. Applications sitting on different virtual machines need to talk to each other internally too. For this internal connection we need to open ports between those machines.

For our application In this post we will open communication between the two instances on a specific port 50 and will enable a telnet service. After opening the ports on the VMs we will verify if we are able to telnet from one instance to the other on that specific port 50

[Post Views: 73]

1 Comment
error: Alert: Content is protected !!