I attended the Enterprise Postgres Day 2019 at the nice location of Westergasfabriek, Amsterdam in the Netherlands. Unfortunately, I was only able to attend the morning sessions till 1 PM, but it seems enough to get a good impression. For those who are not familiar with the difference between Postgres […]
Recently I got a question of a customer regarding a failover configuration. They wanted to install a second server acting as a failover server, switched off until the primary experiences an outage, and they don’t want to pay licenses for it. By bringing the failover-server to life and restore the […]
Little struggle with APEX 19.1 installation with Vagrant and VirtualBox on Oracle 18c XE – on Windows
Why is this a separate blogpost? It is clearly described at the github-page with Vagrant-boxes, so what can be added?
Well… it didn’t work. For me anyway. The database wasn’t created in de VM, so the rest was of no use either. The cause? A combination of […]
I passed the 1Z0-932- exam, known as “Oracle Cloud Infrastructure 2018 Architect Associate”. This was not a ‘walk in the park’ (for me), so I decided to share some experiences of my preparations. What not to do and what definitely should be done. I already had some experience with the […]
A short post after a tweet of Johannes Ahrends (@carajandb on twitter). He brought to our attention that he was worried: SE2 doesn’t include RAC anymore in 19c. Is it a documentation bug? Unfortunately not… his worries appeared to be ligitimate. He made a blogpost about it – in […]
Oracle licensing is mostly a substantial part of the costs of running Oracle software. And every change in the Oracle environment, whether it is about new hardware, going to the cloud, or up- or down- scaling, licensing is involved. And knowledge about Oracle licensing is needed to save costs or […]
With Oracle Enterprise Manager (OEM) you are able to monitor an Oracle environment as well as a non-Oracle environment, like Microsoft’s SQL Server.
You are also able to exchange notifications between Oracle Enterprise Manager and e.g. Microsoft’s SCOM. How to monitor this heterogeneous environment. What licenses do you for monitoring? And.. […]
An updated post about NUP’s on Oracle Database Appliances. Since Oracle launched the Oracle Database Appliance HA (with two nodes) a few years ago it has become clear that from the X7-2 and further not only the Enterprise Edition is possible to use, but also the Standard Edition. But when […]
During a migration of a database, a remote export/import procedure (through database-link) fails intermittently. Some tables are skipped during export, with the familiair ‘ORA-0155’ error. Snapshot too old. Procedure hasn’t changed. What’s going on, besides the obvious reasons for an ORA-0155. Database version changed from 10.2.0.4 to 22.214.171.124.
Customer got the following internal error message : ORA-600 [kdsgrp1] SQL> analyze table OPS$DWHPOPR_TEST.DWH_EURTABLE validate structure online; ERROR at line 1: ORA-01498: block check failure - see trace file.