Author Archives: Ronny Egner

Oracle 12c Release 1 has been released!   Yes, the new generation of Oracles new database platform has been released. You can download it from Oracle   Now as 12c Release 1 is release i am freed from the NDA … Continue reading →

A few months back i accidently set my global database name to “null”. As a result the database crashed with “ORA-00600: internal error code, arguments: [18062]”: SQL> update global_name set global_name=null; SQL> commit;   Starting background process QMNC Fri Oct … Continue reading →

During an Exadata upgrade at a customer the NEM module suddenly faulted after completing the compute node server upgrade. Checking the Hardware and Firmware compatibility yielded a message similar to: Firmware not supported. Required Version: NEM 5.7.0.0 To chec the … Continue reading →

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 →