BLOG Posts

  • Add a new certificate in unify controller
    I’m making use of Ubiquiti AP’s and therefore use the Unify software to manage them. I have it installed within an “ordinary” vm. The software normally uses a self-signed certificate. This is not a big issue as it is my local network. However Chrome starts warning more and more and Safari doesn’t seem to like the self-signed certificate at all after the latest updates. So it became time to install a “proper” certificate. This little article explains how.
  • Have only one session execute code (Critical section)
    Sometimes when you’re writing code you can encounter the situation only one session / thread may execute it (the code) at a time. This is commonly referred as a “Critial Section”. How do you solve such a problem within the Oracle Database?
  • Debugging via Dbms_Pipe
    When running code you sometimes have the need to debug the progress of the statements. One way is to use a table and write your debug output into it by means of an autonomous transaction. But sometimes it can be easier to just hand the debug info to a different session. Say hi to Dbms_Pipe…
  • Resize physical volume without reboot
    Sometimes you need to resize a filesystem because it grows out of it’s available space. With virtual machines this is quite easy, just resize the disk. But…. how do you make Linux know the disk has been resized?
  • Quickstart Apex with docker-compose v2
    As I read an article about Oracle providing version 23c “for free to developers” ( I wondered if it was usable for a quick deploy of Apex. As ORDS has been updated as well it turns out that needed some tweaking…
  • Connect a record player to Squeezeboxserver
    For my audio system I’m making use of Logitech Squeezeboxes as I’ve converted most of my CD’s (yes I’m old ;)) to MP3 format. In this way I’m able to play/stream the same music throughout my house. Spotify is also integrated into this set-up so I’m able to play that as well. But I also have a record player (old remember ;)) with vinyl records. It would be nice to play them through the same system….
  • UTM as a makeshift Vagrant replacement
    It’s almost becoming a series about UTM, my quest of finding replacements for tooling I used on my Intel based MacBook Pro. This time a little article about how I’m using UTM as a replacement for my usage of Vagrant.
  • Using Rosette with UTM and Docker
    When buying a new laptop I settled for a MacBook Pro with a M2 processor. As I was used to an Intel based MacBook Pro with virtual machines and Docker containers I keep searching for replacements for the functionality I was used to. Earlier I’ve written a blog post about running an Oracle Database on the M2 MacBook pro, this time I’d like to talk about using x86 based containers.
  • Running Oracle on MacBook M2
    As I am an Oracle consultant I sometimes want to try things on a local instance. My normal way of working is to fire up a virtual machine or docker instance with the Oracle database and try the things I want to try. As I bought a new laptop and selected a new MacBook Pro with an M2 processor, the docker method does not work anymore. And firing up a virtual machine is a bit more complicated as I used to have an Intel based MacBook (my laptops last for quite some time). There is, however, a workaround….
  • Disable “automatic-wifi”
    With the newer versions of macOS the Wifi of your MacBook is being enabled automatically when the laptop is being restarted. This might not be something you want.
  • Schedule sleep times mac
    Starting with macOS Ventura, Apple in all its wisdoms seems to have removed the scheduling possibilities for sleeping and waking your MacBook from the power options. When you want to schedule power options you need to use pmset command.
  • Controlling a POE switch from Home Assistant
    In my quest to save on electricity I detected my TV set was using quite some energy while “Sleeping”. It turned out it wasn’t sleeping the whole time, waking every x minutes trying to get to the internet (it’s not allowed to) for a few minutes and then going back to sleep. The TV is connect to a little switch along with other audio/video equipment to the LAN. So to test what would happen if the TV was really disconnected from the network I turned the switch off. What if this could be automated?