Topic

Oracle

A collection of 15 issues

Oracle: Using Docker Compose for Oracle 23ai (free)

Oracle 23ai is the latest Oracle database with Long Term Support (LTS). Oracle 21c was an Innovation Release, what means that it's primarily made for testing. And 19c was the LTS release before 23ai. 23ai means year 2023 + artificial intelligence. Unfortunately, we're waiting for 23ai since

Oracle: Timezone upgrade - the easy way

From time to time, countries change their time zone, or the daylight saving time changes (in Germany, we wait for that since years). As some date columns include this information - like TIMESTAMP WITH TIME ZONE, they have to be updated. These updates are called Timezone upgrades. The standard way

MySQL: create an InnoDB cluster

What is MySQL InnoDB Cluster? MySQL InnoDB Cluster is an easy way to increase the avalability and read-only operations of a MySQL database. For the simplest configuration, we need 3 hosts having MySQL server installed and running. In my case, I'll use MySQL sandboxes in MySQL Shell as

Oracle: How to solve "ORA-00800: [Set Priority Failed], [VKTM]"

When Oracle error ORA-00800 [Set Priority Failed], [VKTM] occurs, there are a few things to check: Permissions Owner The binary $ORACLE_HOME/bin/oradism has to be root. If it's oracle or any other user, you should change it using the rootuser. Group The group of the executable

MySQL: Use Docker Compose for MySQL

Using Docker, you can easily set up new MySQL instances. I prefer to use Docker compose for that - here's my configuration file (which should also work for MariaDB-Containers): services: db: image: mysql:8.0 restart: always environment: MYSQL_DATABASE: 'db' MYSQL_USER: 'user'