OOW19 / Code one – some shortcuts to keynotes and dowloadable presentations

By |2019-09-24T13:06:51+02:00September 23rd, 2019|Categories: Database, ODA|Tags: , , , , , |

Oracle Open World is over. Didn’t attend this year, but I’m always interested in what is going on, and in the presentations. so I listed some shortcuts to the keynotes and presentations for my own lazyness. A lot of presentations are downloadable, but it depends on the willingness of the […]

Should a standby database be considered in the cloud?

By |2019-09-03T20:38:57+02:00September 3rd, 2019|Categories: Database, Standby, Uncategorized|Tags: , |

To answer this question for your company, the criticalness of your application and database must be clear. In a High Availability Environment, a standby-database can be part of the technical solution to ensure minimum downtime for your database.

But when moving to a public or private cloud (IaaS, PaaS), the providers ensure […]

Enterprise Postgres Day 2019, June 11th 2019, an impression

By |2019-07-15T09:05:01+02:00July 15th, 2019|Categories: Database|Tags: , , , , , |

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 […]

Oracle disaster recovery without licensing the DR site

By |2019-06-02T11:40:43+02:00May 12th, 2019|Categories: Database, licensing|Tags: , , |

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

By |2019-05-12T13:33:42+02:00May 7th, 2019|Categories: Database|Tags: , , , |

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 […]

If Oracle made toasters…

By |2019-09-29T19:11:40+02:00April 29th, 2019|Categories: Database, Zonder categorie|Tags: , |

An old fun comparison. Judge by yourself if it still make a bit of sense… :-). Author unknown.

If IBM made toasters…
They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe […]

No more RAC in SE2 19c

By |2019-04-09T09:58:03+02:00April 9th, 2019|Categories: Database, licensing, RAC, Uncategorized|Tags: , , , |

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 […]

expdp, ora-1555, Query Duration = 0

By |2019-05-12T13:38:49+02:00March 2nd, 2019|Categories: Database|Tags: , , |

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 11.2.0.4.

ORA-600 [kdsgrp1] Opening a Cursor On a Table

By |2019-02-23T20:20:36+02:00February 28th, 2019|Categories: Database|Tags: , , |

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.

What kind of Oracle Linux support on Oracle hardware is included

By |2019-05-30T11:31:46+02:00September 15th, 2018|Categories: Database, licensing, Uncategorized|Tags: , , |

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 […]