by Maciej Tokar | Nov 24, 2016 | ASM, Installation, Linux, Oracle 12c R1, Other, Real Application Cluster
This is sixth part of my RAC lab series. I will show you step by step how to prepare your OEL 7.x OS for GI and RAC installation. VM with OEL 7.2 in part 3 of the series will be used to show this. RAC lab Part 1 – Installing the Ubuntu 16.04 desktop RAC lab Part 2 –...
by Maciej Tokar | Nov 23, 2016 | ASM, Installation, Linux, Other, Real Application Cluster
This is fifth part of my RAC lab series. I will show you steps to install Oracle Enteprise Linux 7.x on the VM prepared in part 3. RAC lab Part 1 – Installing the Ubuntu 16.04 desktop RAC lab Part 2 – Virtualbox installation and configuration RAC lab Part 3 – VMs...
by Maciej Tokar | Nov 21, 2016 | Installation, Oracle 12c R1, Other, Real Application Cluster, Redhat 7
This is third Part of my RAC lab series guiding me and you step by step in the process of building of a fully usable RAC environment for tests and learning. This third part will show you how to create virtual machines accordingly to the specification required for our...
by Maciej Tokar | Sep 9, 2016 | ASM, Linux, Oracle Database, Other, Redhat 7
This post is quite simple, but may help some of you in the process of discovering and adding new disks to ASM diskgroups on linux servers. I tend to treat my blog as a place to keep some procedures, commands and howtos for a future reference. My memory is not perfect,...
by Maciej Tokar | Aug 17, 2016 | Oracle 11g R2, Oracle 12c R1, Oracle Database, Other
Playing recently a little with one of the databases having as a task improvement of its overall performance I had noticed a group of queries with hundreds of child cursors. Let me show you one of them. Looks more or less like this – logic doesn’t matter at...
by Maciej Tokar | Jul 18, 2016 | Oracle 11g R2, Oracle Database, Other, Patching
I was playing with the query published by Syed Jaffar Hussain to list installed patches using DBMS_QOPATCH package that I described here http://dba24.pl/2016/07/12/how-to-list-the-db-patch-details-in-sql/. Unfortunately I came across some problems and would like to...