Blogs 1. ORA-00479: RVWR process terminated with error followed by ORA-479 Mahmmoud Adel posted about an error that occurs on a 19c DB, when trying to enable the FLASHBACK mode on a standby DB. He gives an analysis and solution. 2. Natural Selection & Converged Databases (Oracle finds good solutions…
Author: Adrian Ward
30 Years working on Oracle systems, specialising in Oracle analytics. Previously known as OBIEE, and before that Seibel Analytics
Oracle ACE
OBIEE
Read more
Mid-October News
Blogs of the week 1. indirect partition pruning This blog begins with, “During one of the discussions, <at POUG2022> I claimed Oracle can – under specific circumstances – do a partition pruning, even when the partition key isn’t somewhere defined as a filter. It’s probably easiest to show it by a…
Oracle Analytics
Read more
Fail: Signing UP to OAC from a Free Cloud Account
I thought I would create a trial OAC instance in my Oracle Cloud instance Apparently you need a paid account to sign up, because you need Oracle support, which is not included in a trial cloud account
Conference
Read more
Back to School
Have you had a good Summer? Here’s a round up of the blogs that have caught my eye over July and August: Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c Mike Dietrich shares why this isn’t just a simple upgrade. You MUST upgrade to Oracle…
Analytics
Read more
News from May 2022
Blogs of the Month qgis with Oracle Cloud Database “One of these complex situations is the connection to an Always Free Autonomous Database. Oracle tries to secure the database access, so by default it does not allow a simple connection with host, port, service_name and username/password. Instead a wallet is provided…
Oracle
Read more
April’s Blogs
Blogs of the Month Building a REST API with ORDS, PL/SQL Functions, & Arrays Jeff Smith shares how to build a REST API that return a JSON array list of strings. 2. Configuring Nginx on AWS EC2 for Oracle GoldenGate 21c This blog begins with: “When installed, Oracle GoldenGate (Microservices) will…
Cloud
Read more
Autumn Days…
Blogs of the month 1.10 Best Database Management Software of 2021 (+ Examples) This blog lists the Best Database Management Software as: ManageEngine Applications Manager DBeaver Raima Database Manager Valentina Redis Enterprise DbVisualizer Oracle Database Database Labs Sadas Engine Percona Monitoring and Management and gives an extensive overview of each….
Oracle Analytics Cloud
Read more
Latest OAC Features and Updates
New Features and Updates for Oracle Analytics See the release announcement. A summary: Oracle Analytics Cloud Release 6. 0 is a significant update. Highlights include: 1. Extended data management capabilities 2. Custom Knowledge 3. Data Quality Insights With every release, OAC includes User Experience enhancements and new visualizations. Highlights for…
APex
Read more
Best of last year
Here is my take on the good reading stuff from last year. Obviously there is a bit of a covid theme to a lot of the blogs I read, but also some great tech updates. Learn how Oracle used APEX to quickly launch its COVID-19 therapeutic app Read about how…
Get Oracle Software
The Linux Problem I have nothing against Linux, but… When you want software from Oracle and you have a windows machine, you just browse to the oracle website, hit the download, boom you have your software. But from Linux? I have tried different methods over the years, including download to…