OHUG Solutions Central – Come See The Experts

Don't try to describe the ocean if you've never seen it
Don't ever forget that you just may wind up being wrong

                                     -  From Mañana by Jimmy Buffet

Having been in the enterprise software business for longer than I really care to admit, I've witnessed an awful lot of smoke blown up an awful lot of skirts. (more...)

GDPR or AVG – regain control Part 1: Your Own Cloud

Create your own Cloud Replace Google or Dropbox, and gain control over you own data. Encrypt it, protect it, share your data only with who you want. ARM, Ubuntu and secured Nextcloud This episode will be followed by an entry on email. For now, I settle for a relatively cheap ARM device (an ODroid XU4, to be precise), run it with Ubuntu, and install NextCloud. The choice for Ubuntu has

Playing with ADWC (Autonomous Data Warehouse Cloud Service)

Oracle has launched Oracle 18c and the Autonomous Data Warehouse Cloud Service (ADWC). Many people call the Oracle 18c as the Autonomous database, and this is a huge mistake! Oracle 18c (that is in reality Oracle 12.2.0.2) is not an

Playing with Oracle Ravello – Migrating your VMs to the Cloud

Hello everyone, A few years back we had the boom of the “Private Cloud” rush, where everyone started to implement virtualization technologies to make a better use of it Infrastructure resources and improve high availability, scalability and innovation! Now to

The Forgotten Link To The Cloud

(Note: This article was also published at Oracle.com – https://blogs.oracle.com/database/the-forgotten-link-to-the-cloud) Last year when presenting a session at Collaborate’17 in Las Vegas regarding Tips and Best Practices for DBAs, I went thru the evolution of the DBA profession and also gave

Collaborate Preview #2: Consider your Options for Moving Oracle WebCenter to the Cloud

By now, most people have heard about the benefits of cloud computing. To summarize, the cloud promises more agility and scalability, with less cost and administration. However, for legacy customers using on-premise software, getting to the cloud isn’t always a simple and straightforward process. In fact, a lot of times confusion on deployment options, pricing, customer-managed versus vendor-managed, and security may delay cloud strategies. This is definitely the case for Oracle WebCenter Content customers who (more...)

Playing with Oracle Database Cloud Backup Service

This article will show you how easy is to make use of Oracle Cloud to securely store all our on-premises Oracle Database Backups. Note that backups stored in Oracle Cloud can also be used to create new Oracle Database Instances

Getting Ready, Part II

A recent post here, "Getting Ready", was all about getting ready for the Oracle Cloud Applications upgrade from R12 to R13.  Now that the upgrading is underway, I thought it might be a good time to add a bit to the info passed along in that prior post.  I'm thinking a basic bullet list is the best way to get this done, so here we go.

  • Upgrade Readiness  Checklist:  You can find (more...)

ADF on Docker – Java Memory Limit Tuning for JVM

It might look like a challenge to run Java in Docker environment, by default Java is not aware of Docker memory limits. Check this article for example - Java inside docker: What you must know to not FAIL.  I was able to run WebLogic and ADF (Essential WebLogic Tuning to Run on Docker and Avoid OOM) on Docker previously without Java memory issues, using JAVA_OPTIONS=-XX:+UnlockCommercialFeatures -XX:+ResourceManagement -XX:+UseG1GC. However after Docker upgrade (more...)

Playing with CrashSimulator

Hi everyone,   Today I will show you how CrashSimulator (Shell Script – current version 1.04) works in detail. When unzipping the zip file you will find the following files within it: CrashSimulator.sh.x – For high-resolution ssh emulator screens, it

Playing with 18c on Oracle Database Cloud Service – How to use and create a database STEP by STEP

  The Oracle Database Cloud Service (ODBCS)  is the DBaaS  extension of Virtual Image Service and includes additional automation for database provisioning during service creation, backup, recovery, and patching. While you are still responsible for the complete management of the environment,

Oracle 18c DBaaS Cloud Setup

The 18c Oracle DBaaS is now available. This is the only place that Oracle 18c will be available until later in 2018. So if you want to try it out, then you are going to need to get some Oracle Cloud credits, or you may already have a paying account for Oracle Cloud.

NewImage

The following outlines the steps you need to go through to gets Oracle 18c setup.

1. Log into your Oracle Cloud

Log (more...)

Playing with Google Authenticator and Oracle Cloud – Securing SSH to Oracle account with two factor authentication

The Requirement Increase security when connecting via SSH to the Oracle OS account at Oracle Cloud by implementing two factor authentication (TFA or 2FA). The Environment Oracle Cloud Instance OS: Oracle Linux 6.9 The Implementation For this exercise we will

Using the Slack webhook API from PL/SQL

Slack is a web-based chat room popular with many companies. Slack also has an API that can be used to post messages to a given "channel" or chat room. The simplest API offered is the "webhook" integration, which is "a simple way to post messages from external sources into Slack. They make use of normal HTTP requests with a JSON payload that includes the message text and some options."



To create a new Slack (more...)

Using Spark to Process Data From Cassandra for Analytics

After my presentation about Apache Cassandra, most people asked if they can run analytical queries on Cassandra, and how they can integrate Spark with Cassandra. So I decided to write a blog post to demonstrate how we can process data from Cassandra using Spark. In this blog post, I’ll show how I can build a testing environment on Oracle Cloud (Spark + Cassandra), load sample data to Cassandra, and query the data using Spark.

Let (more...)

Day 2 problems in the Cloud

Day 2 problems in the Cloud

When moving to the Cloud companies run into “Day 2 problems”. The technology, interfaces and how to use all the stuff are super easy however on the second day comes the real challenge: How to use all this great stuff in a structured way on company/enterprise level?

Here is a great read on “Day 2 problems in the Cloud“. Day 2 is a management problem, not a (more...)

Testing Latency On The Oracle Cloud

One of the best things about working on the HCM Cloud Center of Excellence team at Oracle is that you learn something new every day.

I recently worked on an inquiry from a customer asking about latency testing: has anyone ever done it and, if so, how did they go about it?  In all honesty, it was a stumper for me.  I had no idea how to respond.  Fortunately, one of the folks on the (more...)

Using SQL*Plus to Seed your Dockerized Oracle Database

In my last blog, you learned  to create a containerized Oracle database for your development/testing purpose. You also know how to connect to your container and run command in the container.

Most applications require some reference data e.g. example,my  OrderApp application based on Apache Tom EE  requires catalog data to be pre-populated before I can test my application. 

One of the readers asked me how can we run a SQL (more...)

Dockerizing Your Development and Test Oracle databases

You are probably reading this blog because your application depends on Oracle database. Most enterprises in the world depend on Oracle database to run their business. If you are a developer using Oracle database and getting started with Docker, you must be wondering how can you use a containerized Oracle database. 

In my last blog, I outlined how you can use a Dockerized Tomcat /Tom EE with an Oracle database. In this blog, (more...)

Picking Your Partner

I'm not much for New Year's resolutions.  History shows I just don't keep them.  Take my first New Year's celebration, for example.  My Dad told me I could stay up to ring in the new year if I could put meaning into it by making a resolution.  My resolution was to swear off chocolate cake.  So I rang in the new year with my folks; afterwards, they asked me what I thought of it.  I (more...)