Topic

Oracle

A collection of 20 issues

MySQL: Use CheckMk to monitor MySQL

CheckMk is a great tool for monitoring. Especially when it comes to standard functions for operating systems. But CheckMk is also great for the monitoring of MySQL databases. If you want to use it, just install the CheckMk agent on the MySQL server. Additionally, you'll need the MySQL

Oracle: Which updates to install

In my IT carreer, I often come to new customers I didn't know before. So I don't know their infrastructure. As I'm a DBA, I'm not interested in application servers (besides telling the customer that Operating Systems and standard applications should always

Oracle: Prepare database for upgrade using autoupgrade.jar

In my job, I often have to upgrade or patch Oracle databases. Furtunately, most of all the databases in production are now on 19c, and the rest is mainly on 12.2.0.1. The best tool for upgrading is autoupgrade.jar, which in future will be the only upgrade

Oracle: Upgrade from 12.1.0.1 using autoupgrade.jar takes ages

Last year, when I upgraded many Oracle databases to 19c, I had a few databases which were still on Oracle 12.1.0.1. In case that you forgot what 12.1.0.1 meant for Oracle and all customers: * Until 12.1.0.1, we had Enterprise Edition, Standard

Oracle: Use Docker Compose for Oracle Autonomous Database

Oracle Autonomous Database is "an easy-to-use, fully autonomous database that scales elastically and delivers fast query performance. As a service, Autonomous Database does not require database administration." You can use Oracle Autonomous Database in Oracle Cloud. But if you don't have that, or you prefer to

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'