Infrastructure at your Service

 
Jean-Philippe Clapot

dbi services at AWS re:Invent 2021 : day 2

By | AWS, Cloud, Kubernetes, Technology Survey | No Comments

For my day 1 recap, please jump here. For the second day of that conference, I decided first to attend the keynote of Adam Selipsky, CEO of Amazon Web Services. Lots of annoucements as always covering various area and services. For instance : AWS Lake Formation, new Row and cell-level security, transactions for governed tables, a AWS Private 5G service allowing users to create their own private mobile network, a new AWS Mainframe Modernization service,…

Read More
Morgan Patou

Alfresco – Share Clustering fail with ‘Ignored XML validation warning’, again

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

In a previous blog, I mentioned an issue that I faced when upgrading an Alfresco Content Services 5.2 to 6.1 on a VM with no internet access. The solution was simply to change one of the schema “URL” so that it can fallback to local references, meaning that it will try to check and find the schema definition inside the jar files present in the classpath. When upgrading this exact same VM from 6.1 to…

Read More
Jean-Philippe Clapot

dbi services at AWS re:Invent 2021 : day 1

By | AWS, Cloud, Technology Survey | No Comments

This year, dbi services attends the AWS re:Invent 2021 conference, in Las Vegas. In the current global health situation, this event has a bit of a unexpected flavor as the previous edition was organized virtually. Having in-person such amazing event is very great ! (yes, we even tried to draw the dbi services logo on that chalkboard 😉 ) Across 3 different beautiful and shiny places, numerous events are organized (1447 listed on the catalog…

Read More
Nicolas Jardot

AWS re:Invent 2021 – A busy day to start

By | AWS, Technology Survey | No Comments

This week, I consider myself lucky I’m working with AWS at customer and at dbi since few years now and I consider myself lucky to attend the conference in person. At re:Invent, there are different types of content so you can adapt your schedule. I personally tried this year to get some diversity, I started the week with a workshop on EKS. As we can imagine, workshop sessions are really the kind of place where…

Read More
Daniel Westermann

PostgresBuild2021 – questions feedback (1)

By | Database Administration & Monitoring | 2 Comments

PostgresBuild2021 is currently ongoing and as usual, I had questions after my talk I could not immediately answer. One of the best ways to learn, is to present a topic. There are for sure questions you never thought about. The topic of my talk was “An introduction to server side programming” and I wanted to give people easy examples about how to write procedures and functions in PostgreSQL. It was not about control structures like…

Read More
Daniel Westermann

Open source monitoring solutions (1) – Zabbix server setup

By | Database Administration & Monitoring | No Comments

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious way is trying to integrate into the existing solution. If nothing is there already, you have plenty of choices. You can find some of them on this blog, but the list is quite old. Usually, PostgreSQL is not…

Read More
Jérôme Dubar

ODA 19.12: How can you manage DB Systems with odacli?

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

Introduction As virtualization is available for all ODAs now, you could ask yourself if it’s a good idea to use this virtualization or not. Databases can be created as bare metal, but also within a DB System for better isolation. And both can be used on the same ODA. If you’re looking for how to deploy an ODA with KVM virtualization, please have a look at my previous blogpost here. What is a DB System?…

Read More
Morgan Patou

Alfresco – Custom Share action not working after disabling WebDAV servlet

By | Application integration & Middleware, Enterprise content management | 3 Comments

On an Alfresco upgrade project I was working on recently, I faced an interesting issue where post upgrade, one of my custom Share action wasn’t working anymore. This action was used to create folder links for use on an external interface. When applied on a document, it would create a link to the parent folder for example and when applied on a folder, it would link to itself. Generated link could then be used from…

Read More
Jérôme Dubar

5 things that aren’t true about RMAN

By | Database management, Oracle | No Comments

Introduction RMAN backups are not a hot topic today. This is because it didn’t evolve that much in 12c/18c/19c, and most of the databases are now protected by a good backup strategy since years, and no changes are needed. Furthermore, Disaster Recovery solutions are more and more deployed, and all the flashback technologies embeded in the database are well known. This has pushed the need for RMAN restore to the very latest option in case…

Read More
Mouhamadou Diaw

Dbvisit 10 on Oracle Database Appliance

By | Database Administration & Monitoring, Database management, Operation systems, Oracle | No Comments

Dbvisit Standby can also be installed on Oracle Database Appliance (ODA). The installation is the same that on any other Linux box. I did an install of Dbvist 10 on an ODA 19.12 for a customer and in this blog I am describing the on an ODA steps. The configuration is below -The primary server is oda-prod-01 -The standby server is oda-dev-01 -The database name is ORCL Dbvisit should be installed on both servers (primary…

Read More
Christophe Cosme

SQL Server – Granting SQL Server permission to service SID

By | Database Administration & Monitoring, Database management, SQL Server | No Comments

Introduction We know that SQL Server itself is using it own SID NT SERVICE\MSSQL$ and NT SERVICE\SQLAGENT$ to grant permission to the database engine and the SQL agent services. But the same method can be used for other application services to acces and use the SQL Server instances. The enables to allow the access to the SQL instance when the service is running and avoid to use service account. There are many application using services…

Read More
Nabil Saoual

Control-M/EM Add a suffix to your jobs using mass update utility

By | Control-M, Database Administration & Monitoring | No Comments

Hi guys,and girls of course 😉 Sometimes we have to make some cleanup on our Control-m folders and also we have to keep them disabled (we never know if one day the can be used again by a new agent) so when the folder and the job are depending of one agent it is quite easy to do that ( by disabling the folder name and in our case adding a suffix e.g folder_disabled_from_12112021_request_222578) But…

Read More