After nearly a year, a scheduled scripted PDB hot clone worked flawlessly, and ‘suddenly’ it failed with this error in the target cdb alert log. Some explanation:CDB1900A/PROD is the source cdb/pdb on machine PRODUCTIONCDB1900B/CLONER is the target cdb/pdb on machine CLONE 2021-03-08 15:50:49.421000 +01:00 CREATE PLUGGABLE DATABASE CLONER FROM PROD@clone_pdb Lees verder
Oracle
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 creating 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 Lees verder
Patching Oracle database home 19.5 fails with Copy failed of mgr_help.jar
Today I wanted to patch a 19c client home on Windows, which had a patch level of 19.5 (Windows Bundle Patch: 30151705). I wanted to patch this to (at the time of writing) the latest greatest 19.9 (Window Bundle patch: 31719903). To my surprise I got this during patching: Copy Lees verder
Patching Oracle 12.1.0.2, 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 12.1.0.2 databases on Windows platform. The platform is irrelevant though, 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
Connecting to an Oracle database – some common problems and solutions
This page is my attempt to collect some common problems and their solutions with connecting to an Oracle database. In the hopes that someday I bump into my own page, searching for a solution for some ORA-…. error. ORA-01017: invalid username/password; logon denied ORA-01017: invalid username/password; logon denied Cause: An Lees verder