New SQL:2023 Standard now published

Yesterday ISO published the new SQL:2023 Standard, making that day a special day for me as this is the first version of the SQL Standard I’ve actively participated in. The new Standard comes with an entirely new Part 16 SQL/PGQ for standardizing Property Graph Queries, the JSON data type, SQL/JSON simplified syntax, and many smaller things like some new string manipulation functions, aggregate functions, simplification of literal definitions, etc.

Continue reading “New SQL:2023 Standard now published”

Oracle Database: why do I see “Logon failed because the client is missing the KZTVOV_KPCLOG_O9L_LP capability flag.” in the alert.log?

Last week I got pinged with an interesting question by a user: why do I see kpolnb: Logon failed because the client is missing the KZTVOV_KPCLOG_O9L_LP capability flag. in my Oracle Database alert.log and cannot log in? This is indeed a curious message in the alert log and warrants a post as to what’s going on. To keep it short for the impatient:

Either change your user password to <=30 bytes or upgrade your database client to 23c+ and you will be good to go.

Continue reading “Oracle Database: why do I see “Logon failed because the client is missing the KZTVOV_KPCLOG_O9L_LP capability flag.” in the alert.log?”

Setup a cloud-based reverse proxy to your Raspberry Pi WordPress site

I got a couple of Raspberry Pis lying around at home and thought, what better use for one of them than to run my WordPress blog (another one than this one, but this one may soon follow). The trick to it, however, is that I do not have a static IP address from my internet provider, nor do I want to allow folks into my private network anyway. Luckily, I do have a small cloud-based VM on the public internet, too small probably to run WordPress and MySQL themselves but good enough to redirect some traffic. So, I thought, how about a reverse proxy on the cloud-based server just forwarding HTTP requests via an SSH tunnel to the Raspberry Pi? That way, I can have the Raspberry Pi establish the connection to the cloud-based server, meaning that the connection will be out of my private network and not into it, and it is all secured via SSH. The setup for such a reverse proxy and SSH tunnel is not complicated but requires a few steps that are not easy to find on the web. So, below I decided to document my pilot.

Continue reading “Setup a cloud-based reverse proxy to your Raspberry Pi WordPress site”

PDB-modifiable Oracle Database Parameters

I got an interesting question the other day: “which Oracle Database Parameters are PDB-modifiable?”, i.e., which parameters can have different values for an individual PDB than the CDB? Looking into the documentation, I realized there is no good one-stop page. Instead, the information is scattered throughout the Database Reference. Luckily, however, the answer can be retrieved from the database itself by querying the v$parameters system view.

Continue reading “PDB-modifiable Oracle Database Parameters”

Introducing Oracle Database 23c Free – Developer Release

Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every day. It can be downloaded straight from the Internet with no user account or license click-through requirements, enabling simple and fast access to the world’s only converged database that supports all data models and workload types.

Oracle Database 23c Free – Developer Release is packaged for ease of use and a full-featured experience, making it the perfect entry-level database for anyone who wants to build and run data-driven apps. Its built-in upward compatibility with Oracle Database Enterprise Edition and Oracle Database cloud services ensures that users can move to any other Oracle Database offering anytime.

Continue reading “Introducing Oracle Database 23c Free – Developer Release”