All articles

Does pg_upgrade in check mode raises a failure when the old cluster is running?

Today I had the pleasure to have Bruce Momjian in my session about PostgreSQL Upgrade Best Practices at the IT Tage 2017 in Frankfurt. While browsing through the various options you(…)

SQL Server Tips: an orphan user owns a database role

A few days ago, I conduct an audit to detect all orphan’s windows accounts in a database and I was surprise to have an error during the drop user query.   The first step is to find all orphan’s windows(…)

How to reduce the size of an LVM partition formatted with xfs filesystem on CentOS7?

DISCLAIMER: I know it exists other solutions to do it Pre-requisites: – a virtual machine (or not) with CentOS7 installed – a free disk or partition I use a VBox machine and I added a 5GiB hard disk(…)

Naming of archivelog files with non existing top level archivelog directory

In Oracle 12.2 an archive log directory is accepted, if top level directory does not exist: oracle@localhost:/u01/app/oracle/product/12.2.0/dbhome_1/dbs/ [DMK] ls -l /u02/oradata/DMK/ total 2267920 drwxr-xr-x. 2 oracle dba        96 Dec  6 05:36 arch ... Now database accepts(…)

No journal messages available before the last reboot of your CentOS/RHEL system?

As you probably noticed RedHat as well as CentOS switched to systemd with version 7 of their operating system release. This also means that instead of looking at /var/log/messages you are supposed to use(…)

Alfresco – Unable to move/rename a file/folder using AOS

When playing with the AOS implementation, a colleague of mine faced an interesting issue where he just wasn’t able to move or rename any files or folders. The creation and deletion were working properly but he was unable to move(…)

WebLogic – SSO/Atn/Atz – 403 Forbidden, another issue

Earlier today, I posted another blog with almost the same title but the similarities stop here. The thing is that when you access your application, there aren’t much error(…)

WebLogic – SSO/Atn/Atz – 403 Forbidden, a first issue

In a previous blog, I explained how it was possible to enable the SSO/Atn/Atz (SSO/Authentication/Authorization) debug logs in order to troubleshoot an issue. In this blog, I will(…)

Transfer redo in async-mode to the Gold/Master copy of the Production DB for ACFS snapshots

If you store your databases on the cluster filesystem ACFS you may use the provided Perl-script gDBClone from OTN to clone databases or create snapshot databases. It is an interesting approach to create clones from the Production DB(…)

How to rename an existing Fusion Middleware WebLogic Domain

Some times it happens that we need to rename an existing fusion Middleware WebLogic domain. I was asked to do such on a Fusion Middleware Reports & Forms environment. I took some time to check how this can be(…)