Infrastructure at your Service

Linux/UNIX Archives - Blog dbi services

Natascha Karfich

Part 2 – vagrant up – get your Oracle infrastructure up an running

By | Database Administration & Monitoring | 3 Comments

Last week in the first part of this blog we have seen a short introduction how to setup an Oracle Infrastructure with Vagrant and Ansible. Remember all the files for this example are available here https://github.com/nkadbi/oracle-db-12c-vagrant-ansible Get the example code: git clone https://github.com/nkadbi/oracle-db-12c-vagrant-ansible If you have prepared your environment with Ansible, Vagrant and Oracle Virtual Box installed – and provided the Oracle software zip files – than you can just start to build your Test…

 
Read More
Natascha Karfich

vagrant up – get your Oracle infrastructure up an running

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

By using Vagrant to manage your Virtual Machines and Ansible for configuration management and provisioning you can easily automate the setup of your whole test environment in a standardized way. If you have never heard about Ansible and Vagrant I try to give you an idea with the following very short  summary. There is a lot of good information available about Ansible and Vagrant. Please check the provided links at the end of this blog…

 
Read More
William Sescu

OEL 7 – Project Quotas on Oracle Homes with XFS on Oracle Linux 7

By | Operation systems | No Comments

User and group quotas do exist for quite a while for all kind of file systems, like ext4 or vxfs and maybe many others. However, for my use case, I do need quotas for different directories on the same file system. My mount point is /u01 and in that file system, I do have different Oracle Homes which belong to the same user, oracle. However, I do not want that my 11.2.0.4 Oracle Home influences…

 
Read More
William Sescu

OEL 7 – How to disable IPv6 on Oracle Linux 7

By | Operation systems | 2 Comments

In case you are not interested in IPv6, you can use the following HowTo to disable it on Oracle Linux 7. Unless you have something very very special on your System, these 10 Steps should do it. First of all, check if IPv6 is active at all Add the disable_ipv6 = 1 entries to the /etc/sysctl.conf file Disable IPv6 in all /etc/sysconfig/network-scripts/ifcfg-* files, e.g. Disable IPv6 in /etc/sysconfig/network Remove the “::1″ line from the /etc/hosts…

 
Read More
Stéphane Haby

SQL Server on Linux in Azure

By | Technology Survey | No Comments

I’m pleased to announce that Microsoft gives now the opportunity to choose Linux as a new operating system for SQL Server. To try this new version, you can find in the Cloud Azure a new template in the marketplace. In the search bar, tape “SQL Server vnext” and you’ll find the “SQL Server vNext on Red Hat Enterprise Linux 7.2”. Follow all “classic” steps to create your new VM SQL Server on Linux: First step,…

 
Read More
William Sescu

Oracle – Suspending/Resuming an Oracle PID with “oradebug suspend/resume” or the OS kill command

By | Database Administration & Monitoring | No Comments

Sometimes, if you kick off a huge load or transformation job, your Archive Destination might run full, faster than your RMAN backup job cleans up the destination. To avoid an Archiver Stuck in such situations, the “oradebug suspend/resume” can be helpful, or the UNIX kill command. Usually, the “oradebug suspend” and the UNIX kill command work quite well. Before kicking off you SQL script, get all the information you need from your session. select s.username as Username,…

 
Read More
Pierre Ochsenbein

Shrinking Oracle VM VirtualBox with Zerofree

By | Hardware & Storage, Operation systems | No Comments

In this blog I would like to talk about Shrinking a Virtual Machine with Oracle databases and MySQL which is install. Unfortunately, whilst Virtual Box will dynamically expand the hard drive as it’s required, it won’t dynamically shrink it again if you free up space in the VM. The good news is You can shrink a dynamic Virtual Box disk image and so reduce the size of your VM infrastructure. I have use the Zerofree…

 
Read More
Pierre Ochsenbein

VM Linux – Device not found : Network unreachable

By | Database Administration & Monitoring, Operation systems | No Comments

Recently I exported an Oracle Virtual Box VM as an “.ova” file. When the file was imported again I faced issues with the network devices inside the VM. This post is about what I experienced and how I resolved it. In my example I have two networks devices configured for the VM in the Virtual Box: When I logged in I found that eth0 and eth1 are not available: [root@MYSQL ~]# ifconfig lo Link encap:Local…

 
Read More
Saïd Mendi

Linux – How to check the exit status of several piped commands

By | Operation systems | No Comments

As piping in bash commands is common and very usefull, controling the exit status of each piped commands in bash scripting can be vital, especially for backups. I was checking by a customer the backups of a critical MySQL instance and was surprised even stunned that the return status of all of them was always  successfull when tested but physically on disk, the dumps were all empty. No valid backups since a long time meaning…

 
Read More
Georges Grey

Linux Serververwaltung mit Puppet leichtgemacht

By | Operation systems | No Comments

Mit Puppet die Linux-Server verwalten   Sind mehrere Linux-Server vorhanden, dann entsteht sofort ein Aufwand die unzähligen Konfigurationen ( ntp, chrony, dns, users, groups, services etc.) zu administrieren. Jeder Administrator möchte möglichst alle Server auf die gleiche Weise konfiguriert haben, die gleichen Konfigurationen. Puppet ist ein Werkzeug um genau diese Tätigkeiten zu automatisieren. Das erfolgt mit Manifesten (Definitionen). Die Funktionalität ist vergleichbar mit Policys in der Windowswelt. Diese Manifeste beschreiben den soll Zustand des Systems,…

 
Read More