Infrastructure at your Service

Category

Operation systems

Grégory Steulet

FIO (Flexible I/O) – a benchmark tool for any operating system

By | Operation systems | No Comments

I have just attended an interesting session held by Martin Nash (@mpnsh) at UKOUG 14 – Liverpool: “The least an Oracle DBA Should Know about Linux Administration” . During this session I had the opportunity to discover some interesting commands and tools such as FIO (Flexible I/O). FIO is a workload generator that can be used both for benchmark and stress/hardware verification. FIO has support for 19 different types of I/O engines (sync, mmap, libaio, posixaio,…

Read More
Stéphane Savorgnano

Windows Server 2012 R2: solving .NET Framework 3.5 installation problems

By | Operation systems | 25 Comments

I faced a problem at a customer site last week when I tried to install the .NET Framework 3.5 – a prerequisite for installing SQL Server 2012 on a Windows Server 2012 R2. I opened the Server Manager and then navigated to the Manage, Add Roles and Features section: I selected the .NET Framework 3.5 Features option: I specified an alternate source path: … and surprise! Even though an ISO of Windows Server 2012 R2…

Read More
David Barbarin

SQL Server failover cluster, VSphere, & SCSI-3 reservation nightmares

By | Operation systems | No Comments

When I have to install a virtualized SQL Server FCI at a customer place as an SQL Server consultant, the virtualized environment usally is ready. I guess this is the same for most part of the database consulting people. Since we therefore lack practice, I have to admit that we do not always know the good configuration settings to apply to the virtualized layer in order to correctly run our SQL Server FCI architecture. A…

Read More
Oracle Team

Linux: how to monitor the nofile limit

By | Operation systems, Oracle | One Comment

By Franck Pachot . In a previous post I explained how to measure the number of processes that are generated when a fork() or clone() call checks the nproc limit. There is another limit in /etc/limits.conf – or in /etc/limits.d – that is displayed by ‘ulimit -n’. It’s the number of open files – ‘nofile’ – and here again we need to know what kind of files are counted. nofile ‘nofile’ is another limit that…

Read More
Oracle Team

Oracle Grid Infrastructure 12c: Binaries installation

By | Operation systems | One Comment

In a previous article, I have shown how to configure two servers in order to deploy a two-nodes 12c cluster. This time, I am going to describe the Grid Infrastructure 12c installation process using Oracle Universal Installer (OUI). We assume that cluvfy tool has returned no errors (see previous blog). Install Grid Infrastructure Connect as grid and launch the Oracle Universal Installer (OUI) from /software/grid: $ /software/grid/runInstaller.sh Starting Oracle Universal Installer… Checking Temp space: must…

Read More
Oracle Team

Oracle Grid Infrastructure 12c: prerequisites for installation

By | Operation systems | 8 Comments

Grid infrastructure 12c has recently been released. In this posting, I will show that the installation prerequisites are quite similar between Grid Infrastructure 11g and 12c. We will see parts of them during a review for the deployment of Grid Infrastructure on a two nodes RAC database cluster. Server hardware requirements Let’s see the hardware part. Grid infrastructure 12.1 Grid infrastructure 11.2 Minimal size for /tmp 1 GB 1 GB Minimal size for Grid infrastructure…

Read More
Oracle Team

Oracle Database 12c: Grid Infrastructure, quoi de neuf?

By | Operation systems | One Comment

A la lecture du New Features Guide, on trouve dans le chapitre sur Grid Infrastructure beaucoup de nouvelles fonctionnalités pour Grid Infrastructure, ASM et ACFS, mais l’événement est l’annonce d’une grosse évolution dans l’architecture du cluster. Flex Cluster En effet, cette version 12c introduit une nouvelle architecture nommée Flex Cluster dont voici un aperçu: Schema Oracle documentation Les objectifs annoncés sont “évolutivité, flexibilité et facilité de gestion”. Ainsi, nous pourrons choisir l’organisation “topologie” de notre…

Read More
Oracle Team

Oracle RAC 11.2.0.2: A disturbing loop in a “ohasd” startup script

By | Operation systems | No Comments

Last February, I performed an operating system rolling upgrade on a four-nodes RAC cluster (11.2.0.2). I then faced a strange problem when restarting the operating system… The first step of the procedure was to stop all Grid Infrastructure and Database services running on the first node as well as to disable Cluster and ASM autostart. The following command is supposed to prevent Oracle High Availability Service (OHAS) to be run at operating system startup: #…

Read More
Middleware Team

Boot sequence for all Linux-based operating systems

By | Operation systems | No Comments

In this bog posting, I will present a boot sequence that works for all Linux-based operating systems – from switching on the power to the login screen.   7 steps There are 7 steps for Linux startup: Power on Obviously, first of all, you have to switch on your computer, then: Each sub process will execute the following one It is the same process for all Linux distributions Close to BSD and Unix style from…

Read More