Oracle Database - Chronicles of Technology

Oracle Database

A collection of 8 posts

Database: Rolling Password Change

Oracle Database

Database: Rolling Password Change

Recently, I've found about great Oralce Database 21c feature: Gradual Password Rollover. Here is the best part it was backported to the Database 19c.

Oracle Database: Zoning Conundrum

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.

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.zip 3. Unzip the software: unzip

Flashback: The Lesson I Learned

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: Consume SQL*Plus Output

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.

Keycloak: Use Oracle Autonomous database

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.

Off-the-map 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_HOME=/u01/oracle/