In my previous posts about the first RAC Grid Infrastructure Patchset I document a few issues I encountered that were worth noting. But where things work as advertised I am more than happy to document it too. In a way, the January 2014 GI PSU works as you’d hope it would (at least in my lab for my 2 node cluster).
I have a 2 node RAC cluster that hasn’t previously been patched. (more...)
I was actually hoping I had already written enough about applying the PSU for 184.108.40.206.0 but today I tried to apply the patch to my Oracle Restart home in my lab VM and guess what-it wasn’t as automatic as I thought.
I must have performed the classic copy & paste error and applied the patch to the GRID_HOME only. Please don’t do this! The README clearly states you can but if (more...)
I have already written about RAC/Grid Infrastructure related patching of 220.127.116.11.0 to 18.104.22.168.1, aka the October 2013 PSU for the database.
This post is a follow-up for pure RDBMS-only installations. I initially thought it wasn’t worth blogging about it (and hence the (more...)
In the Oracle technical universe, it seems that the end of the calendar year is always eventful. First there’s OpenWorld: obviously significant for official announcements and insight into Oracle’s strategy. It’s also the week when many top engineers around the world meet up in San Francisco to catch up over (more...)
This blogpost is about how to print the system call arguments of a system call catches in gdb. The reason is I spend quite some time on searching for this, and working around this, so writing it in a blogpost might help others who spend their time in the gdb (more...)
In my blogpost When the oracle wait interface isn’t enough I showed how a simple asynchronous direct path scan of a table was spending more than 99% of it’s time on CPU, and that perf showed me that 68% (of the total elapsed time) was spent on a spinlock unlock (more...)
This is a quick writeup of an oddity I found while trying to install the vmwareware tools in an Oracle Linux host with the UEK3 kernel enabled (which is by default).
This is what is encountered during the vmware tools installation dialog when running vmwaretools.pl:
Searching for a valid (more...)
This method applies to RHEL; let’s first install the VNC Server. Through yum command # yum install tigervnc-server Or Through RPM command First, locate and mount your RHEL 6.3 install media. [root@oraerp ~]# cd “/media/RHEL_6.3 x86_64 Disc 1/Packages” [root@oraerp Packages]# pwd /media/RHEL_6.3 x86_64 Disc 1/Packages Install (more...)
This post also applies to non-Exadata systems as hard drives work the same way in other storage arrays too – just the commands you would use for extracting the disk-level metrics would be different.
I just noticed that one of our Exadatas had a disk put into “predictive failure” mode (more...)
Recently we noticed that imageinfo was displaying the following information at a customers site. Imageinfo was not displaying data i suspected, so a quick little blogpost about what was going on there.
[root@dm01db01 ~]# dcli -g /opt/oracle.SupportTools/onecommand/dbs_group -l root "imageinfo | grep 'Image version'"
dm01db01: Image version: 11.2. (more...)
If like me, and a couple of others I’ve spoken to recently, you were not previously aware of “sudo -s” then you might be interested to know that you can save yourself two keystokes by switching from:
sudo su -
From the man page:
The -s (shell) (more...)
I will be presenting on two topics at the UKOUG Tech13 conference in Manchester.
Goodbye KVM… Hello KVM - Monday (2nd December) @ 16:50 in Exchange 7 (45 mins) - If you use virtualisation in your “home lab”, but have never considered KVM then this session is aimed at you.
Pitfalls, Pain (more...)
It's just under a week to go before the doors open for the UKOUG Tech13 conference and the adjoining OakTable World UK 2013 sessions, so I thought I would write a very short blog post about what I will be doing there, where I'll be, and what I'm looking forward (more...)
Oracle has done a great job with the wait interface. It has given us the opportunity to profile the time spend in Oracle processes, by keeping track of CPU time and waits (which is time spend not running on CPU). With every new version Oracle has enhanced the wait interface, (more...)
I installed OSWatcher on Linux and want to Start OSWatcher Black Box (OSWBB) every system boot. I suggest you download package on Oracle Support - How To Start OSWatcher Black Box (OSWBB) Every System Boot (Doc ID 580513.1)
. If not? You might write simple script.Install:
[oracle@test12c ~]$ pwd
Recently I am involved in a project which requires a lot of data to be extracted from Oracle. The size of the data was so huge that the filesystems filled up. Compressing the output (using tar j (bzip2) or z (gzip)) is an obvious solution, but this can only be (more...)
For medium to large size projects the network setup can be quite complex, especially if it involves several external partners or third-party networks (VPN, MPLS etc).
Normally network changes are done by network engineers that do not have access to the servers and therefore cannot verify the changes they make.
I just learned something new yesterday when demoing large page use on Linux during my AOT seminar.
I had 512 x 2MB hugepages configured in Linux ( 1024 MB ). So I set the USE_LARGE_PAGES = TRUE (it actually is the default anyway in 22.214.171.124+). This allows (more...)
When you are administering an Exadata or more Exadata’s, you probably have multiple databases running on different database or “computing” nodes. In order to understand what kind of IO you are doing, you can look inside the statistics of your database, and look in the data dictionary what that instance (more...)