Infrastructure at your Service

Category Archives: Database Administration & Monitoring

David Barbarin

Connecting to Azure SQL Managed Instance from on-premise network

By | Cloud, Database Administration & Monitoring | No Comments

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 on-premises Database Engine. In the previous blog post, to test a connection to this new service, I installed an Azure virtual machine on the same VNET (172.16.0.0/16) including SQL Server management studio. For testing purpose, we don’t need more,…

 
Read More
Mouhamadou Diaw

Oracle 18c: Cluster With Oracle ASM Filter Driver

By | Database Administration & Monitoring, Database management | One Comment

During the installation of Oracle Grid Infrastructure, you can optionally enable automated installation and configuration of Oracle ASM Filter Driver for your system with the Configure ASM Filter Driver check box on the Create ASM Disk Group wizard page. When you enable the Configure ASM Filter Driver box, an automated process for Oracle ASMFD is launched during Oracle Grid Infrastructure installation. If Oracle ASMLIB exists on your Linux system, then deinstall Oracle ASMLIB before installing…

 
Read More
Michael Hein

SCAN listener does not know about service

By | Database Administration & Monitoring | One Comment

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 possible reason could be, that the parameter remote_listener of the database to be connected is not set to SCAN listener of RAC cluster. So try to set remote_listener to SCAN_LISTENER_HOST:SCAN_LISTENER_PORT like (e.g. host is scan_host,…

 
Read More
Mouhamadou Diaw

Dbvisit 8 Standby Daemon on Windows

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

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 the same that on Linux except that the command is launched on a traditional DOS terminal or a PowerShell. We will not describe these steps (see here for more details). Dbvisit by default will neither send nor apply the archived log files….

 
Read More
Mouhamadou Diaw

Install Dbvisit 8 on Windows

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

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 dbvisit 8 and windows server 2016. The name of my servers are winserver1 and winserver2. The first thing you will have to do is to download dbvisit standby package here . A trial key will be sent to you. Before starting the installation…

 
Read More
Stéphane Haby

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

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

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, users) registered on SQL server instances are in the AD with the useful command sp_validatelogins This report indicates that a computer name dbi\server_name$ was no more in the AD. I drop the login without problem and…

 
Read More
Pierre Sicot

RMAN PITR recover table Oracle 12c

By | Database Administration & Monitoring | No Comments

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 target database. But depending on the database size, it could cost a lot of time, and as nobody knew when the delete action happened, it was more practical to use the rman recover table command in…

 
Read More
David Barbarin

Deploying SQL Server on MiniShift / RedHat OpenShift

By | Database Administration & Monitoring | No Comments

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 want to setup a complete OpenShift infrastructure on my lab to test only my SQL Server pod deployment on such infrastructure. I rather installed MiniShift that comes with one OpenShift node cluster which perfectly meets my requirements.    …

 
Read More
Mouhamadou Diaw

Oracle 18c DataGuard with Nologging Mode

By | Database Administration & Monitoring | 3 Comments

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 without significantly increasing the amount of redo generated. In the documentation we can find following definitions: FORCE LOGGING mode prevents any load operation from being performed in a nonlogged manner. This can slow down the load process because…

 
Read More
Marc Wagner

RMAN catalog upgrade, why, when and how

By | Database Administration & Monitoring | No Comments

One of our customer has been initially creating a RMAN catalog on an Oracle database release 12.1.0.2.0 and was now intending to register new Oracle 12.2.0.1.0 databases. Registering the databases will be failing with errors : PL/SQL package RCAT.DBMS_RCVCAT version 12.01.00.02 in RCVCAT database is too old RMAN-06429: RCVCAT database is not compatible with this version of RMAN  

 
Read More