Infrastructure at your Service

David Hueber

ODA X7-2S/M 12.2.1.2.0: update-repository fails after re-image

By | Database Administration & Monitoring, Hardware & Storage | No Comments
 

 While playing with a brand new ODA X7-2M, I faced a strange behaviour after re-imaging the ODA with the latest version 12.2.1.2.0. Basically after re-imaging and doing the configure-firstnet the next step is to import the GI clone in the repository before creating the appliance. Unfortunately this command fails with an error DCS-10001:Internal error encountered: Fail to start hand shake to localhost:7070. Why not having a look on how to fix it…

Read More
Jérôme Dubar

One command database upgrade on ODA

By | Database Administration & Monitoring | No Comments
 

 The 12.2 finally arrived on ODA and is now available on all generations. Modern ODAs are now supporting 11.2.0.4, 12.1.0.2 and 12.2.0.1 database engines, and these 3 versions can work together without any problem. You probably plan to upgrade some old databases to the latest engine, at least those still running on 11.2. As you may know, 11.2  is no more supported with premier support since January 2015: it’s time to think about an upgrade….

Read More
David Hueber

ODA 12.2.1.2.0 – VLAN Management

By | Database Administration & Monitoring | No Comments
 

 Virtual Local Area Network (VLAN) have become since several years a standard in enterprise class networks. Most enterprises are now segregating their network, especially for security reasons, between server and user or prod and test or applications and backup and aso. In the new release of ODA we finally get the support for VLAN on the bare metal platform. This article will briefly demonstrate how these are managed using ODAADMCLI.

Read More
Franck Pachot

18c Read Only Oracle Home

By | Oracle | No Comments
 

 This is the big new feature of Oracle 18c about database software installation. Something that was needed for decades for the ease of software deployment. Piet de Visser raised this to Oracle a long time ago, and we were talking about that recently when discussing this new excitement to deploy software in Docker containers. Docker containers are by definition immutable images. You need a Read Only Oracle Home, all the immutable files (configuration, logs, database)…

Read More
Daniel Westermann

My personal journey with Linux on the desktop

By | Database Administration & Monitoring | No Comments
 

 My Linux experience started back in 1999 when we needed a router for our ISDN connection in our shared apartment when we were students. I don’t remember the hardware we used for that but I am sure at that time it was a SUSE operating system. Not sure about the version, but based on this it must have been version 4 something or 5 something. The KDE desktop environment looked liked this in version 1…

Read More
Daniel Westermann

What you can do when your Veritas cluster shows interfaces as down

By | Database Administration & Monitoring | No Comments
 

 Recently we had the situation that the Veritas cluster (InfoScale 7.3) showed interfaces as down on the two RedHat 7.3 nodes. This e.g. can happen when you change hardware. Although all service groups were up and running this is a situation you usually want to avoid as you never know what happens when the cluster is in such a state. When you have something like this: [root@xxxxx-node1 ~]$ lltstat -nvv | head LLT node information:…

Read More
Clemens Bleile

CPUs: Cores versus Threads on an Oracle Server

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

 When doing a performance review I often do talk with the DBA about the CPU utilization of the server. How reliable is the server CPU utilization with tools like top or the host CPU utilization in the AWR-report? E.g. on an Linux Intel x86-64 server with 8 Cores and 16 logical CPUs (Intel Hyperthreading), what does a utilization of 50% mean? As I had an ODA X7-M in a test lab available, I thought I’ll…

Read More
Michael Hein

Duplex RMAN backups between disk and tape

By | Database Administration & Monitoring | No Comments
 

 Below a workaround is shown how to “duplex” archivelog backups between disk and tape: Backup on disk (normal way): backup device type disk archivelog all;   Immediately  backup on tape: backup device type sbt archivelog until time ‘sysdate’ not backed up 2 times;   This backup command backs up all archivelogs, that are not backed up twice, so all which are backed up with the first command. As in the first backup command a logfile…

Read More
Stéphane Savorgnano

SQL Server Management Studio 17.4: Vulnerability Assessment

By | Database Administration & Monitoring | No Comments
 

 SQL Server Management Studio is a well know integrated environment used to manage SQL Server infrastructure. This new version 17.4 can support SQL Server from 2008 up to 2017. It enhances existing features like Showplan, XE Profiler (complete list here) but also add an interesting one which is the Vulnerability Assessment. Vulnerability Assessment will scan a database in order to help you to track security holes and deviations. Rules to define those deviations are based…

Read More
Mouhamadou Diaw

Backup and Restore PostgreSQL with PgBackRest II

By | Database Administration & Monitoring | No Comments
 

 In a precedent blog I shown a basic utilization of PgBackRest which is a tool to backup and restore PostgreSQL databases. In this blog I am going to talk some useful features of this tool. In practical examples we will see some tasks we can do with this tool. Of course the official documentation remains the best source of knowledges. Encryption Nowadays encryption of backups is very critical and is mandatory for many companies. PgBackRest…

Read More
Franck Pachot

(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=YES)(LOAD_BALANCE=NO)

By | Oracle | No Comments
 

 Do you have complex connection strings with DESCRIPTION_LIST, DESCRIPTION, ADDRESS_LIST, ADDRESS and a nice combination of FAILOVER and LOAD_BALANCE? You probably checked the documentation, telling you that FAILOVER=YES is the default at all levels, but LOAD_BALANCE=YES is the default only for DESCRIPTION_LIST. But when disaster recovery and availability is concerned, the documentation is not sufficient. I want to test it. And here is how I do it.

Read More
Franck Pachot

Full page logging in Postgres and Oracle

By | Oracle, Postgres | One Comment
 

 In my opinion, the volume of logging (aka redo log, aka xlog, aka WAL) is the most important factor for OLTP performance, availability and scalability, for several reasons: This is the only structure where disk latency is a mandatory component of response time This is a big part of the total volume of backups This is sequential by nature, and very difficult to scale by parallelizing In this post, I look at the volume of…

Read More