How to solve needs-updating on Oracle Linux not seeing an UEK kernel update.
Oracle database plug in problems with .pdb archive, unless you provide a dummy file name convert.
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
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
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
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 188.8.131.52 databases on Windows platform. The platform is irrelevant though, Lees verder
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
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