Oracle Analytics Server Estate If you have chosen the Analytics Server route, either installed on your kit, or on Cloud virtual machines then you will be running the install yourself, and the patching, and the upgrading, and bug fixing. One of the key benefits of this approach is that it…
Analytics
Read more
January Reading
This blog opens with: “A couple of my students wanted me to write a switch and parameter handler for Python scripts. I wrote it just to show them it’s possible but I also show them how to do it correctly with the Python getopt library, which was soft-deprecated in Python 3.13 and replaced…
Analytics
Read more
Some Pre-Christmas Reading
1. Oracle ASM Filter Driver (AFD) Filtering and 5.15 UEK7 kernels Ron shares the background: “As a long time fan of the Oracle ASM Filer Driver, one of the major benefits for Oracle ASM Filter Driver (AFD) is AFD Filtering. AFD can ensure writes are only performed by trusted and…
Analytics
Read more
December Musings
1. Lock Control in Database Onur Ardahnli began with, “In today’s article, we will discuss checking for LOCKs in the database, which is one of the checks we perform when there is a problem in the database.” 2. Spring Cleaning This blog goes through two different scenarios and concludes with: “Wrangling…
Oracle
Read more
November Reading
Recent Blogs I’ve Read: 1. How Can a Data Breach of an Oracle Database be Managed and Analysed? Pete Finnigan asks, “If you become the latest victim of a data hack and your Oracle database is compromised then what do you do?” 2. Applying the first Monthly Recommended Patches (MRP)…
Installing ODI 12c
This is a quick guide to manually installing ODI on a Windows machine. This will take a blank machine and set up a fully functioning ODI system. For this you must have a database in place already and have an account at oracle.com so you can download the software. You…
Oracle Analytics
Read more
October Reading
Nikhil Kotak shares abuot: 2. Should you use the Override and/or Replace Features? Jim Marion asks this question! He ends the blog by saying, “The Override/Replace features are fantastic for REPLACING Oracle’s delivered code. In other words, if you don’t want Oracle’s code to run at all, then override or…
Setup Linux User
I am creating an ODI server, and the first task is to setup the linux user. This post will show how to create a user and connect to it in MobaXterm using Keys. The Tasks involved are: Create the User Set the Password Login Here I have created a session…
Analytics
Read more
End of Summer Reading
1. Staging Tables in Oracle 23ai Dani Schnider begins this blog saying, “Browsing through the Oracle 23ai New Features Guide, I once again discovered a small, inconspicuous feature that I had previously overlooked: There is a new option to create stage tables. What is the advantage of this enhancement?” 2. Separating…
Analytics
Read more
Some Summer Reading
1. Installing Xfce on Oracle Linux 9 Martin Bach shares, “This post explains how to install Xfce on Oracle Linux 9.4 x86-64 using the EPEL (Extra Packages for Enterprise Linux) repository. I’m fairly sure the same applies to ARM64 as well, but I didn’t have time to test. The article is based on…