One of the recommended webserver/app server systems to use in you ORDS/Apex stack is Weblogic, the other is Tomcat. I prefer tomcat because it is soo much quicker and easier to install, and more importantly, to configure. Pre-Requisites For this install I am using the JDK we already install (GraalVM…
Installing JDK 21 on Windows
Continuing our series on using apex to manage Oracle Analytics security. The APEX ‘Stack’ consists of five components The good news is that all of the above can be installed for free, even on windows, for you to learn from. Lets look at how we ‘install’ JDK Firstly we download…
Installing Apex on Windows
Oracle Analytics security can (and should in my view) use database tables managed using Oracle Apex. These tables can enable The reason we would do this is because user administration does not exist in OAS, the nearest you can get to it would be to use Console to manage the…
February News
Stew Ashton writes, “Finding the difference between two dates or timestamps is hard! I am not fully satisfied with any of the solutions I have already proposed (or read), but I think this time I may have a decent answer.” 2. Step-by-Step Guide to Creating a New Forms Server in…
Automating the OAS System
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…
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…
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…
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…
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…