Oracle Database - Chronicles of Technology

Oracle Database

A collection of 11 posts

Can AI developers take advantage of Oracle Database 26ai?

Oracle Database

Can AI developers take advantage of Oracle Database 26ai?

Under the hood, Oracle Database 26ai is technically the same release family as 23ai (it's RU 23.26), but Oracle renamed it to signal that they've fundamentally moved from adding AI features to adopting an AI-native architecture. But if you look past the name change, there&

Oracle Database and Windows.

Oracle Database

Oracle Database and Windows.

Oracle Database on Windows always marches to its own drums. And most of the time, you should tag along because some of your Unix/Linux experiences are not applicable. Let's talk about password files.

Oracle User-Defined Functions

Oracle Database

Oracle User-Defined Functions

Last week, I presented to the Quest Oracle Community SIG on using Oracle User-Defined Functions and Oracle OCI Functions and how they could be instrumental in battling technology debt.

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/