Importing into the Autonomous Data Warehouse using Oracle Data Pump

Introduction This post details the steps required to import into the Autonomous Data Warehouse (ADW) using the Oracle Data Pump Import utility on Oracle Classic Infrastructure (OCI). Versions OCI Compute    Oracle-Linux-7.6-2018.11.19-0 Instant Client     18.3.0.0.0 for Linux x86-64 (64-bit) ADW DB            18.0.3.3 SQL Developer 18.3.0.277 Assumptions An Oracle Cloud […]

Hybrid DNS in OCI

It’s a common scenario to have DNS name resolution between FQDNs in OCI and your on-prem… or between multiple OCI VCNs.  How do we make this happen today?  By using a hybrid DNS solution, of course! What is a hybrid DNS solution?  It’s essentially a DNS overlay on top of the built-in OCI VCN DNS.  […]

Achieving DR in the cloud using Oracle Dyn

Recently a colleague of mine (Kumar) and myself were facing a scenario where we needed to provide a solution providing disaster recovery (DR) functionality between two OCI regions.  It is a fairly common requirement to support some sort of disaster recovery (DR) between different geographical locations.  It has been a common practice in traditional enterprise […]

Oracle Data Integrator Cloud Service (ODICS) : Where to Run Studio

Oracle Data Integrator (ODI) is now available as a Cloud Service: Oracle Data Integrator Cloud Service (ODICS). For customers who are interested in a subscription model for their ODI installation and want to integrate and transform data in the Cloud, this is the solution. Start by deploying ODICS following the Oracle By Example document Provisioning […]

Deploying ODICS Studio on a Windows Image (Compute Cloud Service)

Based on our experience, in the on-premise world, most ODI Developers are using ODI Studio on Windows. So, we thought detailing how to deploy ODICS on a Windows Image on Compute might be useful. This can be used to connect to an ODICS Repository that has already been installed. PLEASE NOTE THAT THIS IS ONLY […]

Creating an instance in Oracle Public Cloud via REST API’s – a usable example

Introduction This post will walk a user through creating a storage volume, and an instance with that volume attached in the Oracle Public Cloud(OPC) via REST API’s. While this article will use curl to demonstrate the calls, these steps can be replicated with any REST client of your choosing.   Prerequisites In order to execute […]

Oracle ATG Commerce IaaS/Cloud provisioning

Introduction The Oracle ATG Commerce provisioning tool set allows for the rapid deployment of the ATG Commerce stack. The tool set contains 3 distinct components that can be used independently, or together to create a Cloud provisioning, software installation and software configuration solution. The Oracle ATG Commerce stack is comprised of several integrated software packages. […]

ODI on Compute Cloud Service: Step by Step Installation

Introduction We have seen in Connect ODI to Oracle Database Cloud Service (DBCS) how to connect ODI on premise to DBCS. But it is also possible to deploy ODI in the Cloud – either on the PAAS (on JCS) or the IAAS (on Compute Cloud Service). In cases where a JEE ODI Agent is not needed, […]

Exalogic Virtual Tea Break Snippets – Pythonised SimpleExaCli

Having completed the CreateAssembly (Create Assets) re-write of the SimpleExaCli I decided it was time to migrate some of the additional functionality I use and enhancing the outputs to match my requirements. This quick blog entry will describe the currently migrated commands and their new output structure. In accordance with my previous CreateAssembly blog I […]

Exalogic Virtual Tea Break Snippets – Create Assets Evolution

Following the success of the CreateAssets shell script and it’s subsequent merging into the SimpleExaCli script I decided to extend the features and leverage the full functionality of the 2.0.6.x (Echo) IaaS. As part of the revisit of the code a rewrite in python was performed and the primary reason for this was it allowed […]

Exalogic Virtual Tea Break Snippets – IaaS Utility vServer

Following a number of discussions around the SimpleExaCli Script and the ModifyLVM Script that are available from this blog site I decided to package the scripts and any future scripts within a simple Utility vServer that was then converted to a template using the SimpleExaCli script. The advantage of constructing this standard utility vServer is […]

Exalogic Virtual Tea Break Snippets – Wrapping the Exalogic iaas cli

Having worked with the Exalogic Command Line for a while I
decided to wrap some of the common functions in a simplified bash
script. This saves me creating the keys, connecting and
identifying the appropriate Ids. Instead I can simply specify the
Name and the script will do the rest of the work. This initial
version has just a few commands in it but as I add more the blog
entry will expand, as will the script, and document the new
functionality.

Exalogic Virtual Tea Break Snippets – Cloning an existing vServer

Following on from my Blog entry “Scripted

Template Generation from an existing vServer” I have built a
wrapper script that can be used to execute the Template Generation
script or Clone a specific vServer. This script was not
incorporated into the original script because it must be executed
on a Compute Node with access to the /OVS/Repositories directory
and the Compute Node are a minimal install and hence do not have
all the required software available. As part of the Cloning
process this new script will create an Assets input file that can
be used with the CreateAssets.sh describe in the blog “Scripting

Asset Creation” and optionally execute the result to create
the clone.

To successfully run the script you will need the following 3
scripts located in the same directory on a machine with the EMOC
cli/api rms installed.

Exalogic Virtual Tea Break Snippets – Scripting Asset Creation

So far in this series we have looked at creating asset within the
EMOC BUI but the Exalogic 2.0.1 installation also provide the Iaas
cli as an alternative to most of the common functionality
available within EMOC. The IaaS cli interface provides access to
the functions that are available to a user logged into the BUI
with the CloudUser Role.

As such not all functionality is available from the command line
interface however having said that the IaaS cli provides all the
functionality required to create the Assets within a specific
Account (Tenure). Because these action are common and repeatable I
decided to wrap the functionality within a simple script that
takes a simple input file and creates the Asset.

Following the Script through will show us the required steps
needed to create the various Assets within an Account and hence I
will work through the various functions within the script below
describing the steps.

You will note from the various steps within the script that it is
designed to pause between actions allowing the proceeding action
to complete. The reason for this is because we could swamp EMOC
with a series of actions and may end up with a situation where we
are trying to action a Volume attached before the creation of the
vServer and Volume have completed.