Prototyping

There are often a number of prerequisite installs that a developer needs to do to create an application. While it’s not always necessary to develop the application inside a VM, it is an effective way to separate the application from other workloads on your workstation.

While it’s possible to perform those tasks manually after starting the VM, it’s easier to script the tasks inside the Vagrantfile instead.

The Oracle Vagrant project is at the following link:

When you script the installs inside the Vagrantfile, then setting up your development environment doesn’t get any easier.

We intend creating an application…


Prototyping

When prototyping an application in Oracle VirtualBox, it can be possible to use a GUI client (eg browser) that is in the same virtual machine. However the virtual machine will need a desktop environment installed, and either X11 or Wayland.

If that’s not desired, or not convenient, to install a desktop environment on the virtual machine then you may separate the application and the client like this:

— application executes in the virtual machine.

— client from the host machine connects to the application executing in the virtual machine.

More simply, a service can be presented outside of the virtual…


APIs are not just for receiving information about an end-point.

APIs can do other tasks too — using Python.

As we will use Python, the place to start is the Github OCI Python SDK page.

There are a number of Python example scripts here.


The Oracle cloud is comprehensively setup for engagement via APIs.

The simplest case is perhaps determining client clock skew:

$ curl -s --head https://iaas.ap-sydney-1.oraclecloud.com | grep Date


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…

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