Infrastructure at your Service

Category Archives: Operation systems

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
Nicolas Penot

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

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

After having worked with OVM on various architectures I can say that it is a good technology to easily build virtualized environments for production applications. Because it is based on XEN and has simple ways to deal with existing storage (FC, ISCSI, NFS, …) and networking solution (bond, lacp, …) it is a robust and convenient way to virtualized IT infrastructures keeping “bare-metal” performance. Besides, it is an hard partitioning technology which is compliant with…

 
Read More
Oracle Team

Oracle Linux 7 – How to audit changes to a trusted file such as /etc/passwd or /etc/shadow

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

Linux auditing is quite powerful and a lot of different use cases might be handled via the auditing framework. However, in this blog I would like to show you, how to audit changes on trusted files, like /etc/passwd or /etc/shadow. Of course, you are not limited to these files. You can audit whatever you want. Maybe the sqlnet.ora, the /etc/oratab or Oracle wallets are of more interest in your environment. Before we start, we got…

 
Read More
David Hueber

ODA – 32GB template but got a database with 16GB SGA???

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

I got an interesting question today from a customer which created a database on ODA. He selected the template odb-04 which shows 32GB Memory but got a database with a 16GB SGA… Is it due to the PGA size, a limitation in the system, the huge pages usage which is reached or even a bug?  

 
Read More

OEL 7 – How to disable IPv6 on Oracle Linux 7 – Follow Up

By | Operation systems | No Comments

This is a follow up to the Blog were I explained how to disable IPv6 on Oracle Linux 7. If you have done all the steps which I have explained here http://blog.dbi-services.com/oel-7-how-to-disable-ipv6-on-oracle-linux-7/  then you have already IPv6 successfully disabled. However, some tools require some special attention afterwards if you want to avoid some ugly warning or error messages. There are so many tools that can use IPv4 and IPv6, but it is impossible to mention…

 
Read More

Linux – Securing your important files with XFS extendend attributes

By | Operation systems | No Comments

Let’s say, the tnsnames.ora is a quite important file on your system, and you want to make sure that you notice when someone changes the file. Taking a look at the modification time of that file would be good idea, or not? Per default, the ls -l command show only the (mtime) modification time. In my case, I know that the tnsnames.ora was changed on “Feb 9 11:24″. oracle@dbidg03:/u01/app/oracle/network/admin/ [rdbms112] ls -l tnsnames.ora -rw-r–r– 1…

 
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
David Barbarin

Dealing with WSFC 2016 quarantine state and availability groups

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

I was playing with my lab environment which includes Windows 2016 and SQL Server 2016 and I noticed an interesting scenario while testing cluster node failures. After simulating some network outage scenarios, I was not able to bring back my cluster node online immediately by using traditional way. A quick look at the cluster manager led me to notice something new: A quarantined state value … interesting! But what does it mean exactly? In respect…

 
Read More
Oracle Team

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
Oracle Team

OEL 7 – How to disable IPv6 on Oracle Linux 7

By | Operation systems | 3 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