Due to my upcoming job having a large part being Oracle, I figured I should install Oracle on my Mac. I found this article on the Oracle site that made running it in a virtual machine look easy. Simply, it’s:
git clone https://github.com/oracle/vagrant-projects
# Optional: download the Oracle Database installation file and place it in this directory
And that’s where the wheels fell off. I haven’t used Vagrant for a couple of years. My Vagrant fell into a wibbling heap. I needed to do the following to drag everything up to date:
brew install vagrant
And then install Virtualbox from the Virtualbox downloads page. Bringing up vagrant then refreshes the vagrant image, brings the oracle image up to date and runs it.
oracle21c-xe-vagrant: INSTALLER: Started up
oracle21c-xe-vagrant: Oracle Linux 8 BaseOS Latest (x86_64) 3.3 MB/s | 49 MB 00:14
oracle21c-xe-vagrant: Oracle Linux 8 Application Stream (x86_64) 3.2 MB/s | 37 MB 00:11
oracle21c-xe-vagrant: INSTALLER: Oracle preinstall and openssl complete
oracle21c-xe-vagrant: INSTALLER: Environment variables set
oracle21c-xe-vagrant: INSTALLER: Downloading Oracle Database software
You’re going to need the instantclient libraries. Do the following in the instantclient directory, you might want to have copied *.dylib* into /usr/local/lib:
This list of lists of falsehoods is a great read. The programming ones are good for for me, especially, but everyone should read the ones in their speciality. Better still, it’s on GitHub, so you can add to it!
I especially like the Big List of Naughty Strings. This is something software testers should use daily. Dates, times, timezones, names and addresses are all problematical.
When I installed ubuntu 20.04.3, I expected the ubuntu networking to Just Work. That was wrong. And apparently, there’s a new network management subsystem to worry about. A quick Google search led me to the Ubuntu docs and thence to create the file /etc/netplan/01-netcfg.yml:
I put all my GitHub/GitLab checkouts in ~/workspace, a hangover from BBC days, along with using VMWare Fusion. Although I tend to use docker more these days. I tried mounting it from within VMWare but no luck. A pointer from a chap on Reddit led me to these lines:
sudo mount -t fuse.vmhgfs-fuse .host:/ /mnt/hgfs -o allow_other
Or alternatively, add the following to /etc/fstab:
These are all things you can find elsewhere but a couple of password issues came as a surprise to me
These are all things you can find elsewhere but a couple of password issues came as a surprise to me when a legacy system got the MySQL 5.7 upgraded to 8.0.
Firstly, password policies are much tighter. There’s a plugin that by default demands an uppercase letter, a number and a punctuation character. That foxes our legacy system whose installer just generates lowercase letters and numbers. Uninstall it.
So this was an hilarious case of reference counting.
There I was, developing my Perl Catalyst app. I migrate to gitlab like all the other cool kids. I move the original development directory to .bak like a good boy.
But, my plackup is still running and because reference counting, the open files are all still there so I was still happily running. I check out the gitlab version, make changes and NOTHING HAPPENS. Until finally the penny drops, I quit the original, now renamed directory and re-enter the correct one.