2020 has been a tough year for many, but I can’t complain considering what other people have gone through. While others lost their job due to the shutdown, I could work from home for extended periods.
I don’t know why I stopped blogging, probably because I am lazy or easily distracted. But this annual opportunity to say thanks to some people who has helped me a lot shouldn’t be missed (I did last year). Tim Hall aka ORACLE-BASE organizes an annual virtual Thanksgiving for us Oracle nerds.
I just upgraded a small Confluent Kafka cluster at a customer. Almost everything went fine, just following these instructions: https://docs.confluent.io/current/installation/upgrade.html (our servers are running on CentOS). But at the end KSQL server wouldn’t start and failed with this error message:
The slides from my talk at Riga Dev Days 2019 will be available here after the session.
Here is the link to the presentation.
If you try to import large Excel files to SQL Developer, it may hang for a long time. But let say you like SQL Developer very much, or you are too lazy to find another tool, here is a way to load large Excel files. By converting the Excel files to CSV SQL Developer can load it much faster.
Here is the link to my presentation at POUG 2018 in Sopot, Polen
Epoch time is common in some situations because it is easier to do date calculations than with normal dates. The most popular is UNIX Epoch time which is the number of seconds since the start of January 1, 1970.
I was supposed to do something else that involved using the package UTL_HTTP
from the database accessing an URL over HTTPS. Instead I lost several hours troubleshooting ORA-29024: Certificate validation failure and ORA-28750: unknown error (Nice error the last one).
Oracle Developer Community