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?” →

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” →

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 oracle.com 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” →

This is a short blog post about a tiny little feature that you are probably unaware of but can make your life easier.

When you work with databases, you sometimes may find yourself in a situation where you got a long-running query because you forgot a WHERE clause or you didn’t realize how many rows the table had, and you wished you could stop the query but not kill your entire database session in the process.
Say you have a transaction running, and now you want to verify your changes before committing but, oh no, you messed up the WHERE clause and the query goes off for a while. What are you going to do? Kill the session but have to redo the entire transaction again, or wait it out but it could be quite a while. Well, if you are on Oracle Database 18c or later, you will find yourself in luck. Say hello to ALTER SYSTEM CANCEL SQL!

Continue reading “How to cancel long-running queries in Oracle Database” →