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.
1 CommentAuthor: Brijesh Gogia
I’m an experienced Cloud/Oracle Applications/DBA Architect with more than 15 years of full-time DBA/Architect experience. I have gained wide knowledge on Oracle and Non-Oracle software stack running on-prem and on Cloud and have worked on several big projects for multi-national companies. I enjoy working with leading-edge technology and have a passion for Cloud architecture, automation, database performance, and stability. Thankfully my work allows me time for researching new technologies (and to write about them).
[sc name="linkedin"][/sc]
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.
Leave a CommentIn 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.
2 CommentsWe use Oracle native network encryption which gives us the ability to encrypt database connections, without the configuration overhead of TCP/IP and SSL/TLS and without the need to open and listen on different ports.
Below are the extra parameters we have for the encryption/data integrity
Leave a CommentTDE that we discussed in previous post is encryption mechanism for the data in rest. In this post, we are going to discuss the security…
Leave a CommentTransparent 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.
2 CommentsIn last post we created oracle cloud database by following a very simple process on the Oracle Cloud Console. We verified the database by connecting…
Leave a CommentCreating a new database instance from Oracle Database Cloud Console is a very simple and straightforward task. Just a few clicks will give you a running database in less than 45 minutes.
Below is step-by-step procedure to install an Enterprise database version on Oracle Cloud.
Leave a CommentOracle 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.
Leave a CommentIf 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.
1 Comment