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 […]
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 […]
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 18.104.22.168.
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.
When you buy an Oracle Database Appliance – any type – or just a X-server (e.g. X7-2), you get free support for OracleVM, Oracle Solaris and Oracle Linux. But Oracle Linux has different flavours , like basic, premier and premier limited. What kind of support do you get when buying […]
Found out a scheduled export- and import job was broken. Error: ORA-31626: job does not exist. After checking the scheduled jobs I realized that it’s not the scheduled job, but the datapump-job. And it’s all related to being cost-effective in the cloud….
Until recently, there was one rule when deploying Oracle software in the Azure cloud:
- count one Azure CPU Core as equivalent to one Oracle Processor license.
But there was somehow what confusion about hyperthreading VM’s. This has been nuanced by Oracle in their cloud-licensing document very recently