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.
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).
Most of my work in the Oracle world has been DBA-oriented. But for the last years, I have rediscovered the joy of development and data analysis. When I haven’t been writing the code myself, I have often helped other developers when they connect to the Oracle database, and their program does not perform as expected.