How to connect Oracle 19C database on Red Hat Linux to a PostgreSQL database, with an Oracle database link over ODBC

There are quite a few blogs about this subject, but I wanted to share how I performed this database link from Oracle to PostgreSQL. Though I mention Oracle 19C, these steps will probably work on all Oracle database versions from 11G onward. For the PostgreSQL version, this will work presumably Lees verder

Patching Oracle, database datapatch fails with ORA-20004: Uninitialized state in install_file

Now this blog is with courtesy of my esteemed colleague Jeroen Nijholt, also a DBA/Technical Consultant with Ordina. I asked his permission to use some of his notes to blog about this. He was assigned to patch a few Oracle databases on Windows platform. The platform is irrelevant though, Lees verder

Microsoft AADSTS90033: A transient error has occurred. Please try again.

On the 14th of December 2020 I started up the laptop from my employer but Microsoft Outlook. Teams and Onedrive could not connect. Also another application that uses a passthrough Microsoft login would not work and spit out this error: Request Id: [some unique id] Correlation Id: [some unique id] Lees verder

Don’t create a user from an Oracle script within a set container to pdb

For an 19C Oracle database that will be added in an Oracle Fail Safe cluster I had to install statspack with an Oracle script, which also creates the perfstat user. Because I didn’t want to create a local listener because Oracle Fail Safe has is own mechanism for this, I Lees verder