Blog – Keyword: Oracle


  • DBCA doesn’t like personal SQL*Plus prompt

    The database creation (19c) using DBCA was hanging at 33%: The catproc0.log shows many connection errors: The generated trace file shows at the end: This was part of an automation script I wrote, which was started during the VM installation using ansible. It was working fine until not long ago. What might have happened? I…

  • Oracle Engineering Systems (Community) Day

    On a full room in the centre of Zurich, Switzerland, two great events dedicated to ODA, Exadata, ExaCC, Exadata at OCI or Azure, PCA and other derivatives took place on March 20th 2024. In the morning organized and sponsored by Tradeware AG was the 21st Oracle Engineering Systems Community meeting, followed by 11th Swiss Oracle…

  • Install Oracle Linux 9 and Oracle Database 19c on Windows WSL

    Since a few days I’ve a Oracle Database 19c running on my laptop (4 year old i5 processor with 16GB memory) under the Windows Subsystem for Linux with the latest Oracle Linux 9.3. It is working great for testing functionalities. It survives without problem sleep and restart without first shutting down correctly the database. While…

  • Swiss OUC – Database Circle Conference 2024

    I had the pleasure to assist to the first Swiss Oracle User Community conference in Zurich the last two days. Great event the the Oracle offices in the “Circle” at the Zurich Airport. It was opportunity to see some ex-Trivadis colleagues – Ludo, Frank, Dani and meet all the Oracle conference addicts. The two parallel…

  • Nice table for Oracle OLVM: VMs, hosts, clusters and vcpu pinning

    On my client infrastructure, for improved performance, we need to make sure each VM is pinning to different physical cores. We do the changes for the moment using the web interface. However, to read easily what the current status is, I’ve wrote a python script that draws a nice table showing where each VM is…

  • We did changed nothing. How to set up AES encrypted username password in DB2 client?

    It all started with the connections from Goldengate to DB2 not working anymore: The DB2 administrators say “We changed nothing. Maybe you changed something? And the DB2 documentation says nothing for this error. Next email from DB2 admins “well, we did activated the option TCPALVER=SERVER_ENCRYPT and maybe that is the problem” Indeed, that was the…