-
Using AI to confirm a wrongly cabled Exadata switch – or how to fix verify_roce_cables.py script for Python3.
One of the preparation steps when installing an Exadata X10M is to verify that the cabling of the RoCE switches is correctly done. The next step is to upgrade the Cisco switches with the latest firmware. During my intervention for Tradeware at the customer, the first didn’t work as the provided script is not compatible…
-
Oracle postpones release of 23ai on-premises to 2H CY2024
Oracle just updated the Release Schedule of Current Database Releases (Doc ID 742060.1) and changed the release date of database version 23ai on-premises to next half-year. Lets see how many months and bug fixing that means. 🙂 Update on 20.06.2024 – “Added new release dates for Oracle Autonomous Database – Dedicated Exadata Infrastructure, Autonomous Database on…
-
The DBT-16051 when creating a standby database using DBCA is still around. 7 years after.
Sometimes I ask myself why some bugs are not solved. When looking for DBT-16071 we find a blog post from Frank Pachot from more than 7 years ago. He shows that with Oracle 12.2 you can “create” standby databases directly with dbca. But that the script does only a duplicate for standby and nothing more.…
-
Change language and prompt in SQLcl for VS Code
Windows and language settings is a common problem for users outside English speaking countries. The windows language on my laptop is English, but time to time I use another laptop in Portugal with the same Microsoft account as login. This laptop is configured in Portuguese. My work laptop’s keyboard is Swiss, locale also set for…
-
How to use Zabbix to monitor Oracle DB – a quick test run
Currently I’m testing different solutions for monitoring (mostly) Oracle databases. One solution in the shortlist is Zabbix. Zabbix is open-source and currently has a quite active community helping out. On Zabbix website there is a nice quick download and setup instructions: I’ll use a Oracle Linux 9 VM under Windows WSL2 for installing Zabbix. For…
-
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…
