Skip to content

Database

Everything our consultants learn while running databases for customers: Oracle, PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB and Delphix. Expect hands-on posts about installation, day-to-day administration, backup and recovery, performance tuning, replication and upgrades.

Native OEM MCP Server or OEM AI Assistant?

I have been recently writing several posts about AI integration in Oracle Enterprise Manager. Let’s compare both solutions now: Native OEM MCP Server and OEM Oracle AI Database Assistant using OCI Generative AI (LLM).

DOAG Nürenberg Closing

This year’s DOAG Konferenz is a special one: it is the last edition in Nürnberg, after 15 years in this city. I was there for most of these editions, and it really feels like the end of a chapter. 15 years of stories, meetings and sharing For me, DOAG in Nürnberg was never just a conference. It is three days… 

MongoDB DMK 2.7.0 : point-in-time recovery, 9.0 support and auto-upgrade

In this blog, I will present the new features introduced with the latest release (2.7.0) of the MongoDB DMK. The DMK is a set of standardized tools that aims at easing the work of DBAs. It embeds the best practices of dbi in common scripts across all the database servers of an organization. dbi services provides the DMK (Database Management… 

Using Oracle Transparent Data Encryption with Multitenant Databases

With the increased risk of a cyberattacks, the protection of one of your most valuable asset’s, your data, is vital. Data within the Oracle database is generally the most vital and/or sensitive data within the company. The best way to start protecting that data is with Transparent Data Encryption (TDE). Some of the benefits of using TDE are: TDE encrypts… 

Oracle RAC Interconnect Network best practice  MTU

Oracle Real Application cluster is clustering solution for high load database systems giving you possibility to load balance your application traffic and dynamically (online) scale our cluster by increasing or decreasing number of nodes. However, for proper working systems you should always follow official oracle recommendations for infrastructure requirements. If you are buying Oracle Appliances systems like Exadata/ODA they already… 

AI for free with Oracle

AI and Oracle for free? really? In this blog post I will describe a use-case with a free AI model provided by Oracle that can be used in the 26ai free edition. The use-case is: I have a table with additional infos about bands (country, genre, homepage, facebook, youtube, …). And I have a table with events (concerts, festivals) and… 

Avoid Oracle Passwords in cleartext with KeePass and Oracle Wallet

Interactive work How to avoid cleartext passwords with Oracle? In this post I will focus on databases with traditional accounts with username/password, and not on other authentication methods like kerberos (AD). For interactive work, it is not a problem, you can iteractively type the password At least on Linux, the sqlplus and rman tool will rewrite the commandline and hide… 

Json and Oracle 19c

What is JSON JSON (JavaScript Object Notation) is a lightweight text format for storing and exchanging structured data. The information is organized as key–value pairs and lists. Assume we have server certificates in json form: Or as a one-liner As we can see, that’s simple ASCII text. And the certificate is usually around 2KB. So that it easily fits in… 

Oracle RAC Clusterware upgrade 23.26.1 after 19.30 OC4J issue

If you planning to upgrade your Oracle RAC Clusterware from version 19.30 or higher to release 23.26.1 please be aware that this will not work as there is issue with de-supported qosmserver and OC4J resource come in 19.30 update. To avoid problem described below, install 23.26.4 which bypass this issue during upgrade. Always upgrade to version which was released the… 

Default autoRestart delay breaking GoldenGate extract

When analyzing a customer’s GoldenGate deployment after a server reboot, I found a weird extract, which reported RUNNING. However, it was not extracting anything at all. Its report files were full of ABENDING entries. Here is a description of the problem, and what could have avoided this. managedProcessSettings ADD EXTRACT/ADD REPLICAT over the REST API accepts a managedProcessSettings object. It…