Infrastructure at your Service

 
Morgan Patou

Documentum Upgrade – Castor is locked!

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

One of the best practices while doing upgrade of Documentum is to unlock the various repository objects before starting. This will make sure that if the upgrade process requires an update of some objects, then it will succeed and not cause you issues because you are missing some pieces. This also brings a second benefit: it means that if you ever see locked objects after the upgrade, then something probably went wrong somewhere.   In…

Read More
Franck Pachot

Oracle ACFS: “du” vs. “df” and “acfsutil info”

By | Oracle | No Comments

By Franck Pachot . This is a demo about Oracle ACFS snapshots, and how to understand the used and free space, as displayed by “df”, when there are modifications in the base parent or the snapshot children. The important concept to understand is that, when you take a snapshot, any modification to the child or parent will [[email protected] ~]$ asmcmd lsdg DATAC1 State Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files…

Read More
Olivier Spiesser

Microsoft Teams, Power Automate and Planner

By | Database Administration & Monitoring | No Comments

As we moved to Teams at dbi and one of our customers, automating tasks was a strong need. One of the tasks that could be automated is the creation of tasks in Microsoft Planner which does not support recurring tasks. Every 4 weeks, we are patching the environment. For everyone awareness and follow up, we need to publish these dates in the planning. As the pace of these tasks is known, it is a bit…

Read More
Marc Wagner

POUG 2020 Workshop Day 1

By | Oracle | No Comments

I had the opportunity to participate to POUG day 1 and wanted through this blog to share some of my feedback on the interesting sessions I could follow. First of all, I would like to mention the great introduction done by the staff team and the great organization. POUG staff team could adapt to the coronavirus situation and organized excellent POUG virtual days. Well done!

Read More
Mouhamadou Diaw

Oracle Data Guard RedoRoutes : What is Priority 8 ?

By | Database Administration & Monitoring, Oracle | No Comments

When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using the RedoRoutes property. Basically the RedoRoutes property has this format (redo_routing_rule_1) [(redo_routing_rule_n)] Where each routing rule contains a redo source field and a…

Read More
Franck Pachot

Oracle Autonomous Linux: cron’d ksplice and yum updates

By | Cloud, Database Administration & Monitoring, Oracle | No Comments

By Franck Pachot . Oracle Enterprise Linux (OEL) is a Linux distribution which is binary compatible with Red Hat Enterprise Linux (RHEL). However, unlike RHEL, OEL is open source, free to download, free to use, free to distribute, free to update and gets free bug fixes. And there are more frequent updates in OEL than in CentOS, the free base of RHEL. You can pay a subscription for additional support and features (like Ksplice or…

Read More
Lazhar Felahi

Oracle GoldenGate 19c: Cannot register Integrated EXTRACT due to ORA-44004

By | Application integration & Middleware, Database Administration & Monitoring, Oracle | No Comments

The global_name in an oracle database has a direct impact on the Golden Gate Extract process registration we need to do when we create an Integrated Extract. In my example below, I use Oracle GoldenGate MicroServices architecture but the same behaviour occurs with Oracle GoldenGate Classic architecture.   Let’s start with the creation of the Extract process by clicking on the plus button :   Choose Integrated Extract and click on Next button: Fulfill all…

Read More
Jérôme Dubar

Oracle Cloud basics for beginners

By | Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | 2 Comments

Introduction Cloud, Cloud, Cloud. Everyone is talking about the Cloud but a lot of people are still in the fog with Cloud technologies. Let’s talk about basic features of the Oracle Cloud, called OCI for Oracle Cloud Infrastructure. What is really OCI? OCI is physically a lot of servers in datacenters all around the world. These servers are not very different from the servers you probably have in your own datacenter. Some of these servers…

Read More
Daniel Westermann

Attaching your own CentOS 7 yum repository to AWS SSM

By | AWS, Database Administration & Monitoring | No Comments

From some blogs I’ve written in the past you might already know that we are using AWS SSM to patch and maintain the complete EC2 and onprem instances at one of our customers. The previous posts about that topic are here: Avoiding patching madness by using AWS SSM Avoiding patching madness by using AWS SSM A simple Terraform script to create an AWS EC2 playground Schedule reboots of your AWS instances and how that can…

Read More
Franck Pachot

The Oracle ACE program ♠ what it is not ♠

By | Database Administration & Monitoring | 4 Comments

By Franck Pachot . I had a few questions about the Oracle ACE program recently and I thought about putting some answers there. Of course, that’s only my point of view, there’s an official web page: https://www.oracle.com/technetwork/community/oracle-ace/index.html The program is flexible and open, with a large diversity of people, technologies, contributions, levels,… Then rather than explaining what it is, which would be limiting, I’ll rather tell you… what it is not. It is not a…

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