Category Archives: Oracle in general

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 →

I just migrated my Ubuntu iSCSI storage server to Ubuntu 12.04 which ships with a new iSCSI implementation: LIO (linux-iscsi.org). Aside from the fact that this project lacks a HUGE amount of documentation I want to share this problem with … Continue reading →

Just a short note: When doing a “duplicate from active database” with a larger amount of channels you need to set the PROCESSES setting in your parameter file to a reasonable high value (i.e. 500). Otherwise the duplicate will fail … Continue reading →

Oracle just released a statement which states the immediate availability and support using Oracle database 11g R2 with Oracle Enterprise Linux 6.   You can read the official announce here.

I just played with 11.2.0.3.0 patchset on Linux x86_64 (in my testcase Oracle Enterprise Linux 5.6) and tried to install a 11.2.0.2.0 database on it. It fails with: PRVF-5300: Failed to retrieve active version for CRS on this node The … Continue reading →