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

Preparations for the 1Z0-932 – exam

By |2019-04-29T13:54:20+02:00April 29th, 2019|Categories: Cloud|Tags: , , , |

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

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

All about Oracle Licensing

By |2019-03-18T07:38:26+02:00March 18th, 2019|Categories: Cloud, licensing|Tags: , , , , , , , , , , |

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

Oracle licenses needed while monitoring your (non-)Oracle environment with OEM

By |2019-05-12T12:12:25+02:00March 6th, 2019|Categories: licensing, Oracle Enterprise Manager|Tags: , , , , , |

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

Licensing ODA on NUP’s and with different metrics

By |2019-05-12T12:48:23+02:00March 4th, 2019|Categories: licensing, ODA|Tags: , , , |

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

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.

X