Database Administration & Monitoring

User Session lost using ADF Application

In one of my missions, I was involved in a new Fusion Middleware 12C (12.2.1.2) installation with an ADF application and an Oracle report server instance deployments . This infrastructure is protected using an Access Manager Single Sign on(…)

EDB containers for OpenShift 2.3 – PEM integration

This blog refers to an older version of EDB's Postgres on Kubernetes offering that is no longer available. A few days ago EnterpriseDB announced the availability of version 2.3 of the EDB containers for OpenShift. The main new feature in(…)

Connecting to Azure SQL Managed Instance from on-premise network

A couple of weeks ago, I wrote up about my first immersion into the SQL Server managed instances (SQLMIs), a new deployment model of Azure SQL Database which provides near 100% compatibility with the latest SQL Server(…)

SCAN listener does not know about service

When trying to connect to a database via SCAN listener in a RAC environment with sqlplus, an ORA-12514 error is thrown. Tnsping can resolve the connect string. Whereas connecting to the same database over node listener with sqlplus succeeds. One(…)

Dbvisit 8 Standby Daemon on Windows

By Mouhamadou Diaw In this previous blog, we have installed Dbvisit standby for Windows on both servers. We suppose that the database is created and that the standby is configured (see this blog). The steps are(…)

Install Dbvisit 8 on Windows

By Mouhamadou Diaw In a previous blog we described how to install dbvisit standby in a Linux box. In this article I am going to describe the installation on a Windows machine. We are using(…)

SQL Server Tips: Drop a database-user attached to a service…

Few weeks ago, I have a little issue when I try to drop a database-user without login Unfortunately, I do a little mistake at the beginning… I receive like every morning a report if all AD logins (computers, groups,(…)

RMAN PITR recover table Oracle 12c

At one client’s site, I had to restore a table someone had partially deleted one week before. Before Oracle 12c, we had to duplicate the target database to another server, and then to export and import data to the(…)

Deploying SQL Server on MiniShift / RedHat OpenShift

Currently we begin to see customer adopting containerization for SQL Server databases (mainly driven by CI/CD and DevOps trends). A lot of them are using RedHat OpenShift as container management platform. From my side, I didn’t(…)

Oracle 18c DataGuard with Nologging Mode

By Mouhamadou Diaw With Oracle 18c database nologging has been extended with two new modes: Standby Nologging for Load Performance and Standby Nologging for Data Availability. These modes provide better support for use in an Oracle Active Data Guard environment(…)