Infrastructure at your Service
It happens within the blink of an eye. A delete command was executed and half a second after you hit the enter button you knew it. That was a mistake. This is the scenario which leads to this blog entry in where I show you how you can get your files back if you are lucky…
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…
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…
By William Sescu 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…
By William Sescu 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…
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,…
By William Sescu 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…
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…
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…
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…
