Author Archives: Ronny Egner

I just came accross a situation where multipathed devices were not discovered correctly. The device itself was discovered but the disks partitions were missing. It turned out there are two bugs in OEL 5.8. The first one is related to … Continue reading →

When setting up a RMAN backup to tape i encountered the following issue on a Oracle 9.2 database (not sure if it applies to older database versions; i´d say no…): RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: … Continue reading →

In case you locked yourself out of the Networker you can add a user from the command line with the following command:   nsraddadmin -u “user=administrator, host=machine1”

  Just a short how to rename grid disks (and keep the size). In the example below the grid disks name contained a typo ‘FALSH02’ and had to be renamed to ‘FLASH02’: dcli -c exadata01cel01 -l root “cellcli -e drop … Continue reading →

Today i ran into a good example for really really bad error messages: Imagine a tablespace with 720 datafiles (approx 22 TB in total size) which should be transported via transportable tablespace. For this you created a plain, new 11.2 … Continue reading →

Sine i need to check the maximum size of tablespace with autoextend enabled i write the following query: set linesize 100 set pagesize 100 select                 a.tablespace_name,                 round(SUM(a.bytes)/(1024*1024*1024)) CURRENT_GB,                 round(SUM(decode(b.maxextend, null, A.BYTES/(1024*1024*1024), b.maxextend*8192/(1024*1024*1024)))) MAX_GB,                 (SUM(a.bytes)/(1024*1024*1024) – round(c.Free/1024/1024/1024)) … Continue reading →

This is a short post about how to configure iSCSI multipathing using Nexenta. I let it is neccessary to document it since the documentation is rather spare about it. In my lab setup i had a machine with two physically … Continue reading →

Starting with the Oracle Unbreakable Enterprise Linux Kernel (UEK) the ASMlib drivers are now included in the kernel. This means that updating the kernel does not require installing the appropriate kernel modules as well. In addition to the kernel modules … Continue reading →