Infrastructure at your Service

Tag

Migration Archives - Blog dbi services

Clemens Bleile

Oracle autoupgrade on Windows and plugin to a Container DB with virtual accounts

By | Oracle | No Comments

In a project I recently had to upgrade an Oracle 12.2.-DB to 19.9. and at the same time migrate from the non-container architecture to the container architecture. The interesting part here is to do this on Windows. Actually both steps (upgrade and plugin) are possible using the autoupgrade tool , which is the preferred tool to do Oracle upgrades today. Before doing the upgrade at the customer, I performed 2 tests in my personal environment:…

Read More
Jérôme Dubar

A typical ODA project (and why I love Oracle Database Appliance)

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | No Comments

Introduction You can say everything about Oracle infrastructure possibilities but nothing compares to experience based on the realization of real projects. I did quite a lot of ODA projects during the past years (on other platforms too), and I would like to tell you why I trust this solution. And for that, I will tell you the story of one of my latest ODA project. Before choosing ODAs A serious audit of the current infrastructure…

Read More
Morgan Patou

Documentum – Some things to take care of when migrating/upgrading

By | Application integration & Middleware, Entreprise content management | No Comments

Over the years I have been working with Documentum, I participated in many migrations and/or upgrades. Just like everything else, this obviously builds up some experience but what if you are pretty new to Documentum and it is your first time working on one? Sure, there is the Documentation from OpenText, which is several dozens of pages (~140, depending on versions) of intense fun so prepare a lot of coffee, you will definitively need some….

Read More
Franck Pachot

Some myths about PostgreSQL vs. Oracle

By | Oracle, Postgres | One Comment

By Franck Pachot . I originally wrote this as a comment on the following post that you may find on internet: https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/ but my comment was not published (many links in it… I suppose it has been flagged as spam?) so I put it there. You should never take any decision on what you read on the internet without verifying. It is totally valid to consider a move to Open Source databases, but doing it…

Read More
Daniel Westermann

Migrating an Oracle instance to AWS Aurora – 4 – AWS DMS Change Data Capture (CDC)

By | Database Administration & Monitoring | No Comments

This is the last post in this little series about migrating on Oracle instance to AWS Aurora with PostgreSQL compatibility. For the previous one you can check here, here and here. In this post we’ll look at how you can configure change data capture so that changes on the source Oracle instance are automatically replicated to the target Aurora instance. In a real life migration this is what you probably need as long down times…

Read More
Daniel Westermann

Migrating an Oracle instance to AWS Aurora – 3 – Data replication with AWS DMS

By | Database Administration & Monitoring | No Comments

If you followed the last two posts in this little series (here and here) this is the current status of this demo migration project: We have converted the Oracle SH schema and applied it to the target AWS Aurora with PostgreSQL compatibility instance. This worked quite well but a few objects (mostly PL/SQL procedures) would need manual actions. The next and final step is to replicate the data from Oracle to the Aurora instance using…

Read More
Jérôme Dubar

Speed up datapump export for migrating big databases

By | Database Administration & Monitoring, Database management, Hardware & Storage, Oracle | 3 Comments

Introduction Big Oracle databases (several TB) are still tough to migrate to another version on a new server. For most of them, you’ll probably use RMAN restore or Data Guard, but datapump is always a cleaner way to migrate. With datapump, you can easily migrate to a new filesystem (ASM for example), rethink your tablespace organization, reorganize all the segments, exclude unneeded components, etc. All of these tasks in one operation. But datapump export can…

Read More
Jérôme Dubar

Focus on 19c NOW!

By | Database Administration & Monitoring, Database management, Oracle | 2 Comments

Introduction For years, Oracle used the same mechanism for database versioning. A major version, represented by the first number. And then a release number, 1 for the very first edition, and a mature and reliable release 2 for production databases. Both of them having patchsets (the last number) and regular patchset updates (the date optionally displayed at the end) to remove bugs and to increase security. Jumping from release 1 to release 2 required a…

Read More
Marc Wagner

Migrating Oracle database from windows to ODA

By | Database Administration & Monitoring, Oracle | 2 Comments

Nowadays I have been working on an interesting customer project where I had to migrate windows oracle standard databases to ODA. The ODAs are X7-2M Models, running version 18.5. This version is coming with Red Hat Enterprise Linx 6.10 (Santiago). Both windows databases and target ODA databases are running PSU 11.2.0.4.190115. But this would definitively also be working for oracle 12c and oracle 18c databases. The databases are licensed with Standard Edition, so migrating through…

Read More