Oracle Database - Chronicles of Technology

Oracle Database: Zoning Conundrum

The Oracle Database has long and complicated relations with time-aware data. It has gotten even more interesting in the internet era and global data processing. As usual, it's a story about how a single line of code at the design time could save many work hours in maintenance.

SQL*Plus

Quickest way to set up the Oracle Instant Client for sqlplus access to the Oracle Database

Need quick and immediate access to SQL*Plus (i.e., sqlplus) from your Linux server? 1. Navigate to: https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html 2. Download these files: * instantclient-basic-linux.x64-21.5.0.0.0dbru.zip * instantclient-sqlplus-linux.x64-21.5.0.0.0dbru.

Database

Flashback: The Lesson I Learned

This piece is not about features or products. It's about lessons that we learn or not. The one I learned some twenty-three years ago was: "Don't ask for troubles and do one thing at a time."

Ansible

Ansible: Consume SQL*Plus Output

A simple way to consume Oracle Database data in Ansible playbooks without extensive Python or PL/SQL coding or 3rd party modules.

Keycloack

Keycloak: Use Oracle Autonomous database

The Keycloack Server documentation recommends an external database to persist realms configuration. The article describes how to configure Oracle Autonomous Transaction Processing service with WildFly/JBoss application server.

Oracle Apex

Off-the-map Apex

From time to time, you need good old Oracle software. And the first challenge you face is to find the software binaries.

Oracle SOA Suite

Custom .bash_profile for Oracle Fusion Middleware

I have created some crude custom .bash_profile scripts that I use to make things easy for me after I install some of the various Oracle Fusion Middleware products. Oracle HTTP Server (OHS) 12c export PS1="\u@\h:\$PWD> " export DISPLAY=:1 export MW_