Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Grégory Steulet

Oracle Licensing (R)evolution

By | Database Administration & Monitoring | No Comments

In 2015 I wrote a blog named “All you need to know about Oracle Database licensing with VMware”. This blog generated lots of comments and hopefully helped some DBAs and IT Managers understanding the potential issues that they can face in case of Oracle LMS Audit. In 2 years I made some new experiences related to Oracle LMS audit and I’d like to share those experiences with you to provide you up to date information….

 
Read More
Mouhamadou Diaw

Online datafile move in a 12c dataguard environment

By | Database Administration & Monitoring | No Comments

Oracle 12c introduces moving online datafile. One question we might ask is what about moving datafile online in a dataguard environment. In this blog we will do some tests Below our configuration, we are using oracle 12.2 DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 8 seconds ago) DGMGRL> The StandbyFileManagement property is set to auto…

 
Read More
Mouhamadou Diaw

Oracle 12.2 Dataguard : PDB Flashback on the Primary

By | Database Administration & Monitoring | No Comments

The last day I was discussing with one colleague about database flashback for a pluggable database in a dataguard environment. I did some tests and I present results in this blog. Below our broker configuration. Oracle 12.2 is used. DGMGRL> show configuration; Configuration – MYCONT_DR Protection Mode: MaxPerformance Members: MYCONT_SITE – Primary database MYCONT_SITE1 – Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 35 seconds ago) DGMGRL> The primary database has the…

 
Read More
Nicolas Penot

Automate OVM deployment for a production ready Oracle RAC 12.2 architecture – (part 02)

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

In this post we are going to deploy a R.A.C system ready to run production load with near-zero knowledge with R.A.C, Oracle cluster nor Oracle database. We are going to use the “Deploy Cluster Tool” which is provide by Oracle to perform Oracle deployment of many kind of database architectures you may need like Oracle single instance, Oracle Restart or Oracle R.A.C. This tool permits you to choose if you want an Enterprise Edition or…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | 2 Comments

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 have for upgrading there was one slide where I claimed that the old cluster needs to be down before you run pg_upgrade in check mode as you will hit a (non-critical) failure message otherwise. Lets see if that really is the case or I…

 
Read More
Stéphane Haby

SQL Server Tips: an orphan user owns a database role

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

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 accounts in a database USE [dbi_database] GO /*Step1: Search the orphan user */ SELECT * FROM sys.database_principals a LEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid WHERE b.sid IS NULL AND a.type In (‘U’,…

 
Read More
Soufiane Benmalek

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

By | Database Administration & Monitoring | No Comments

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 We list the disk and partition to check if our new hard is added. [root@deploy ~]$ lsblk NAME MAJ:MIN RM SIZE RO TYPE MOUNTPOINT sda 8:0 0 20G 0 disk ├─sda1 8:1 0 1G 0 part /boot…

 
Read More
Michael Hein

Naming of archivelog files with non existing top level archivelog directory

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

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 this non existing archivelog destination: SQL> alter system set log_archive_dest_3=’LOCATION=/u02/oradata/DMK/arch/arch2′; System altered. But not this: SQL> alter system set log_archive_dest_4=’LOCATION=/u02/oradata/DMK/arch/arch2/arch4′; alter system set log_archive_dest_4=’LOCATION=/u02/oradata/DMK/arch/arch2/arch4′ * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid…

 
Read More
Daniel Westermann

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

By | Database Administration & Monitoring | No Comments

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 journcalctl to browse the messages of the operating system. One issue with that is that messages before the last reboot of your system will not be available, which is probably not want you want.  

 
Read More
Nicolas Jardot

DOAG 2017: Automation in progress

By | Database Administration & Monitoring, Oracle | 5 Comments

A week ago, I had the chance to be speaker at the DOAG Konferenz 2017 in Nürnberg. It’s sometimes hard to find time to be at the conferences because the end of year is quite busy at customers. But it’s also important because it’s time for sharing. I can share what I’m working on about automation and patching and I can also see how other people are doing. And it was great for me this…

 
Read More