A week of PostgreSQL

One of the attractive things of my job is this… Just a bit more often than every now and then, you get the opportunity to get out and meet people to talk about Postgres. I don’t mean the kind of talk I do every day, which has more of a commercial touch to it. – Don’t get me wrong, that is very important too! – But I mean, really talk about PostgreSQL, be part of (more...)

Epilogue

The AppsLab experiment ended this week as nearly all of us were laid off from Oracle.

Noel and I decided to keep this blog running, both as a historical resume of sorts and as a way for all of us who worked in ‘Lab over the years to share our ongoing adventures and talk about technology.

We had a good run, thanks to executive leaders like Paul and Jeremy, and I will always remember the (more...)

Playing with Oracle Cloud – Creating a Hybrid DR Deployment

On this article, we will create a Hybrid Disaster Recovery (DR by using Data Guard) Oracle Database Cloud Service database deployment with a primary database on-premises and a standby database in the cloud. This can be used to implement an improve the high

Oracle and More…

It has been over a year I wrote my last blog post. I would admit I was being lazy to write, but the good part is not anymore !!

I plan to take out some time and write at least 2 blogs every month and share my learning with the community and to learn from the community.

With the current pace of change in technology, it very important to keep up with it, though sometimes it (more...)

Playing with Oracle Database Cloud – Migrating to Cloud using an Oracle Cloud Backup

The idea for this scenario is to learn how to migrate an Oracle Database from on-premises to Oracle Cloud DBaaS by using a previously done backup using Oracle Cloud Backup Services. First, we will create an Oracle Database Cloud Services database

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

DOAG conference 2018 Call for Paper is open

Call for Paper is open. (Take a look on the timetable.)

For Engineered Systems please use the „Infrastructure“ Stream.

We had a wide range of topics :-)

https://2018.doag.org/en/speakers/

 

Exploring AR

Since back in 2015 when we got the Not-For-Sale developer model of Samsung Gear VR Innovator Edition which only works with Samsung Note 4, we started to set our eyes on the development of immersive digital media experience of virtual reality.

The original Gear VR in 2015. Feels so ancient ????

Along the way, we have researched on enterprise VR use cases, device platform, and development technologies. We created virtual gadget lab as soon as A-Frame (more...)

Research on Emerging Tech Like AI, IoT Aims to Make Your Work More Efficient

Cross-posting this bit I wrote for the official Oracle Application User Experience blog, enjoy.

Recently, at Oracle CloudWorld in New York, Oracle President Thomas Kurian talked about how emerging technologies can change the way you do your job for the better.

Investigating this impact is the primary focus of the AppsLab, the Oracle Applications User Experience (OAUX) Emerging Tech team, and it is what my team and I explore every day.

A recent (more...)

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,

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

Managing API Policy Versioning in Oracle API Platform

Oracle’s API Platform (API-P) product avoids the use of external configuration management. If you want to better understand why, then checkout our forthcoming book as it goes into detail about why this is the case (it can be pre-release version of the book can be obtained here). In a previous blog I wrote about and illustrated the use of the API-P’s own APIs so that it was possible to see what API iterations had (more...)

Here We Go, Again


"There are no wrong roads to anywhere."
-- Norton Juster, The Phantom Tollbooth

Every once in a while someone decides that Oracle functionality isn’t fast enough and makes a valiant attempt to correct these perceived deficiencies. Most of the time such efforts are anything but successful. From ‘home-grown’ referential integrity (which doesn’t work) to trying to speed up existing functionality the efforts are amazing and dismal at the same time. But that doesn’t keep (more...)

Tracing Executions in an API Environment

As APIs become more pervasive within our solutions we see the arrival of not just design and cataloging tools such as Apiary, Apigee and others but also the arrival of gateways. The gateways provide execution of operations including validation, accounting (moneytization), routing, and other controls such as throttled checks that would often not occur until the first contact with a service bus. For example initial routing based on the API call, fine grained authentication (more...)

Shoe Treads

In December our team was allowed two weeks to pursue a “passion project”. It didn’t have be work-related, just something you truly wanted to work on. I chose to design tread patterns on the soles of shoes.

I had never given a thought about shoe treads until, a week earlier, a woman on the NodeBox forum asked for help creating organic shoe patterns. I asked her to elaborate on what she meant by “organic” and (more...)

Why I picked Postgres over Oracle, part III

This is the final episode of this short series of blog posts on some of my drivers for moving to Postgres from Oracle.
Please do read Part I and Part II of the series if you have not done so. It discussed the topics “History”, “More recently”, “The switch to Postgres”, “Realization”, “Pricing”, “Support” and “Extensibility”.

In summary:

  • Part one focused on “why not Oracle anymore, so much”
  • Part two discussed on the comparison (more...)

Why I picked Postgres over Oracle, part II

Continuing this short series of blog posts on some of my drivers for moving to Postgres from Oracle.
Please do read Part I of the series if you have not done so. It discussed the topics “History”, “More recently” and “The switch to Postgres”.

Realization

In the last months, discussing Postgres with my Oracle peers, playing with the software and the tooling, I actually quite quickly realized Postgres is a lot cooler, at least to (more...)

Secure Erase of an Exadata System

What has to be done when the Lifecycle of an Exadata System comes to the end.

You need to do an secure erase of DB and Storage nodes.

By the way you can also secure erase the Switches and PDU, etc. but this is not described in this article.

Documentation

https://docs.oracle.com/cd/E80920_01/DBMSQ/exadata-secure-erase.htm#DBMSQ-GUID-DE6BBDF7-6BCB-412B-AD1E-E0FFEEFCC3AA

and  My Oracle Support Doc ID 2180963.1

Steps to do

I use the method via bootable USB Stick

Download Boot (more...)

Why I picked Postgres over Oracle, part I

As with many stories, if you have something to tell, it quickly takes up a lot of space. Therefor this will be a series of blog posts on Postgres and a bit of Oracle. It will be a short series, though…

Let’s begin

History

 I have started with databases quite early on in my career. RMS by Datapoint… was it really a database? Well, at least sort of. It held data in a central (more...)

Unified Front


"The most important reason for going from one place to another is to see what's in between."
-- Norton Juster, The Phantom Tollbooth

In Oracle’s most recent release, the audit options have been expanded and modified to create the Unified Audit Trail, a ‘one-stop shop’ for recording and reporting audit information. A new view, UNIFIED_AUDIT_TRAIL, provides access to the audit details:


 Name                                                          Null?    Type
 ------------------------------------------------------------- -------- ----------------------------
 AUDIT_TYPE                                                             VARCHAR2(64)
 SESSIONID                                                              NUMBER
 PROXY_SESSIONID                                                        NUMBER
 OS_USERNAME                                                             (more...)