Increasingly DBAs are called upon to manage multiple types of database, and also to migrate from a non-Oracle database to an Oracle Autonomous Database.

In fact, it’s also quite easy with Oracle Virtualbox to setup a sandpit virtual machine to test your migration strategy.

A number of software vendors provide pre-built virtual machine appliances that can be used for a sandpit. One such provider is Bitnami. They provide a number of appliances, and one of those is for the LAPP technology stack.

Bitnami LAPP Stack provides a complete, fully-integrated and ready to run LAPP development environment. In addition to PHP…


Sometimes, you may need to migrate an application from MySQL to something more advanced — like Oracle database.

For a reference on the differences between MySQL and Oracle database, refer to the documentation.

Oracle SQL Developer will assist you in the migration, and the official documentation is below.

It can also be helpful to setup Vagrant virtual machines to do your test migration. Fortunately, Oracle provides Vagrant projects that includes the LAMP stack (featuring MySQL).

It’s easy to clone the Oracle Vagrant repo like below, to setup the Vagrant Oracle Linux 7 project with LAMP extension.

$ git clone https://github.com/oracle/vagrant-projects


To get a better understanding of the Oracle Integration Service, it’s helpful to examine the sample integrations.

Oracle also provide a way to connect integrations together.

So the 3 sample processes that Oracle provide are:

Hello World — Example describing simple log and notification actions. This sample demonstrates how to use simple log and email notification actions with a REST Adapter in an orchestrated integration. The REST Adapter is triggered when you specify a URL.

Hello World Invoke — Example shows how to call/invoke a simple REST webservice. This sample demonstrates how to call and invoke a simple REST web…


The question is, what is an integration?

An integration is a simple and secure connection between multiple applications. There is also a mapping so a field in one application can correspond to a field in another application.

An integration includes at the least a trigger (source) connection (for requests sent to Oracle Integration) and invoke (target) connection (for requests sent from Oracle Integration to the target) and the field mapping between those two connections.

The Oracle Integration service is used to connect end-points between multiple applications.

The applications can be in the cloud, or on-premise.

In addition, the Integration service…


In Oracle Integration, it is easy to use the Processes feature to rapidly design, automate, and manage business processes in the cloud.

The documentation says it nicely.

Engage in business processes automated in the cloud.

The type of business processes that may be automated include:

Start an application and complete a form

Act on assigned tasks such as Approve, Reject, or Request Info

Find tasks and view their details and status

Upload documents related to a task, download them, and manage them in folders

Set out-of-office routing for assigned tasks

If you want automated business processes in the cloud —…


As the world’s #1 tool for Managing your Oracle database, the SQL Developer should be every ones best friend.

There are in fact 3 interfaces for SQL Developer:

  • Desktop
  • Web (ie SQL Developer Web)
  • Command line (ie SQLcl)

The desktop version of SQL Developer is still arguably the best interface.

Download it from here:

Let’s checkout what desktop SQL Developer has to offer for the Autonomous Database.

Prerequisites

Before attempting to connect to an autonomous database, the wallet file for the database needs to be downloaded to your workstation.

From the details page of the autonomous database, click on the ‘DB…


When visualising what a world-class web application on the Oracle cloud might look like, it’s helpful to build a prototype.

In fact, Oracle have built a prototype for you, and it’s listed as an option for installation here:

Let’s check it out!

MuShop — the Sample E-Commerce Application

The Sample E-Commerce Application is listed as:

Deploy a sample e-commerce application using Always Free Oracle Cloud resources

Fortunately installing the Sample E-Commerce Application in our Oracle Cloud Infrastructure is going to be easy when using the Resource Manager to create a stack to execute a Terraform script.

Start by ‘Create Stack’.


For development environments, a typical programmer will install all the development tools they need on their local workstation.

However there is an alternative….

If you are going to develop software for the Oracle cloud, then why not do the development in the Oracle cloud as well?

Even better if the image for the Oracle cloud contains all the tools you’ll ever need for development.

The Oracle Cloud Developer Image enables you to rapidly pre-install, and automatically configure and launch a comprehensive development environment on Oracle Cloud Infrastructure that includes the latest tools, choice of popular development languages, Oracle Cloud Infrastructure…


While it is possible to operate your cloud tenancy within the browser-based cloud shell, there is another way without the browser.

The install takes place from Powershell inside a ‘Run as administrator’ session.

Start Powershell

Get a menu of options with a right-click on the Windows menu button.

Then select the ‘Windows Powershell (Admin)’ option.

Local configuration

From the session created, you need to configure the remote execution policy for PowerShell.

> Set-ExecutionPolicy RemoteSigned

The cloud is all good when it’s always free.

Now the Oracle Cloud offers:

  • Always Free — Services you can use for an unlimited time.
  • 30-day Free Trial — US$300 in free credits.

Just a few steps and you’ll be on your way — in about 15 minutes!

Start here

To begin, from oracle.com you need to click on ‘View Accounts’.

Then ‘Try Free Tier’.

Paul Guerin

Paul Guerin is an international consultant that specialises in Oracle database performance. Paul is based from a global delivery center in South East Asia.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store