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.
Continue reading “Running Oracle on MacBook M2”Author: Patrick van Zweden
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.
Continue reading “Disable “automatic-wifi””Schedule sleep times mac
Starting with macOS Ventura, Apple in all its wisdom seems to have removed the scheduling possibilities for sleeping and waking your MacBook from the power options.
Continue reading “Schedule sleep times mac”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.
Continue reading “Controlling a POE switch from Home Assistant”Using a remote USB serial device locally (Linux)
Sometimes you want to use a USB serial device at a different location of where it is “plugged in”. With two tools (ser2net and socat) this is quite easy to do.
Continue reading “Using a remote USB serial device locally (Linux)”Lookup udev attributes
In a previous post (Passing serial port to unprivileged container) I needed to create an udev rule to adjust the permissions on a serial port I wanted to pass through to a container. How did I come up with the values needed in the rule?
Continue reading “Lookup udev attributes”Passing serial port to unprivileged container
I make use of Proxmox and sometimes you need to use an external device within a LXC container. This article describes howto pass a serial port to the container, but the procedure is the same for any device.
Continue reading “Passing serial port to unprivileged container”Export data in handy formats using SQLDeveloper
Just a small techtip
Sometimes you want to export table data. SQLDeveloper can help you with that with a few formats which are built-in and are callable via a simple hint within your SQL statement.
Continue reading “Export data in handy formats using SQLDeveloper”Creating a SqueezeboxServer container
For years I’ve been using a Logitech Squeezebox as my music system. First with the server software (slimserver) running on a Linux Box and later-on on a Synology NAS device.
As Synology stopped supporting the SqueezeboxServer it’s time to move the software into a Docker container. This way I’m able to use everything the way I used to and move the software towards another server (or run it at the Synology box via Docker).
Continue reading “Creating a SqueezeboxServer container”Using unicode characters in PL/SQL
Sometimes you need to use unicode characters in messages / strings you output from PL/SQL code. However sometimes the automatic installation procedures of a customer might use a different or weird character-set when installing your code into the database. What happens is that the character within the source (in a constant for example) becomes mangled and appears as a “character not recognised question mark” in the output.
Continue reading “Using unicode characters in PL/SQL”