Oracle

Removing rpm with dnf implies removing systemd

On an Oracle Linux 8, I installed a new package and did not pay attention that dnf used an old Oracle Linux 7 repository. Trying to remove it again, I was getting following error: Error:Problem: The operation would result in(…)

Oracle Linux – Unfinished DB8actions remaining

I have been recently facing following error when using yum/dnf: There are unfinished DB8actions remaining. You might consider running yum-complete-DB8action, or "yum-complete-DB8action --cleanup-only" and "yum history redo last", first to finish them. If those don't work you'll have to try(…)

Oracle database linux service not working properly after Oracle Linux upgrade

After performing an in-place Oracle linux upgrade I could realize that the oracle service was unusable. I would like to share with you the reason and how to resolve it.

Upgrading Oracle Linux when running Oracle databases

I recently had to upgrade an Oracle Linux production server running 19.30 Oracle databases for one of our customer. In this post, I will share with you the full set of steps that need to be carried out to run(…)

Oracle: Failed to create Cloud Base DB Service DB-System with RU 19.32.

Issue I recently had to create a 19c Oracle Database on the Base Database Service on Oracle@Azure. Creating the DB-System failed with the following error: Launch DbSystem failed. Reason : DCS-10001:Internal error encountered: Failed to download the fast clone.DcsException{errorHttpCode=InternalError,(…)

Oracle GenAI – Ask EM – Install and configure an Oracle Management agent on OEM 24ai

In order to be able to test the GenAI Ask EM functionality of OEM 24ai, and after I have first installed an OEM platform from OCI MarketPlace, I have been installing and configuring an Oracle Management agent on one of(…)

Oracle GenAI – Ask EM – Deploy Oracle Enterprise Manager 24ai from Marketplace

I have been looking to study and test what Oracle GenAI Ask EM assistant, also called now Oracle AI database assistant, can offer. This generative AI assistant is directly integrated into Oracle Enterprise Manager 24ai. Before being able to look(…)

GoldenGate Trail Purge Task Fails with “OGG-12111: JSON element ‘/csn’ does not match any schemas”

Since the beginning of the year, I had the opportunity to upgrade many GoldenGate setups to 26ai. On two of them, I was facing an issue regarding purge tasks that I could not solve. Since it took quite some(…)

LOB Replication With GoldenGate and Importance of Primary Keys

Every time I work on database migrations with GoldenGate, I have the same talks with application teams about missing primary keys. Especially when it comes to LOB replication with GoldenGate. In a previous blog, I(…)

GoldenGate Row Identification: Misconceptions and Solutions

GoldenGate is a powerful replication tool, but it is so versatile that you should always check whether what you intend to do is supported or not. Oracle provides a few interesting scripts and views to check your environments before(…)