Infrastructure at your Service

Category Archives: Operation systems

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
William Sescu

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
William Sescu

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 | No Comments

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
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 | No 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
Nathan Courtine

Manage Azure in PowerShell (RM)

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

Azure offers two deployment models for cloud components: Resource Manager (RM) and Classic deployment model. Newer and more easier to manage, Microsoft recommends to use the Resource Manager. Even if these two models can exist at the same time in Azure, they are different and managed differently: in PowerShell cmdlets are specific to RM. In order to be able to communicate with Azure from On-Premises in PowerShell, you need to download and install the Azure…

 
Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box Analyzer (OSWBBA)

By | Operation systems | No Comments

Following my last blog post about OSWatcher, I will present in this one OSWatcher Black Box Analyzer (OSWBBA), which is the tool that you can use to display graphically the data collected by OSWBB. This tool is a Java utility and exists since OSWatcher version 4.0.0. It permits to create graphs and complete HTML reports containing collected OS statistics.   OSWBBA require no installation. It is embedded in the OSWatcher home directory. To start the…

 
Read More
Joël Cattin

OTN Appreciation Day : OSWatcher Black Box (OSWBB)

By | Operation systems | No Comments

In this post, I will present a usefull and easy-to-use Oracle tool : OSWatcher. What is it ? OSWatcher Black Box (OSWBB), for its full name, is a free Oracle Tool which will help you to diagnose performance issues on the OS side. Of course, it will not solve the issue for you, but it gives a system health state at a given moment. OSWBB is multi-platforms supported (AIX, Solaris, HP-UX, Linux and Windows) and…

 
Read More