Author Archives: Ronny Egner

When doing performance analysis the current network throughput is often interesting. The following nice script display that – even without any root permissions. #!/bin/sh # usage: netvolmon DEV [INTERVAL] DEV=$1 IVAL=${2:-5} getrxtx() { kstat -p “*:*:$1:*bytes64” | awk ‘{print $2}’ … Continue reading →

Today i had a smaller problem registering a newly created database in a rman catalog. The only unusual thing was that the database was using a unicode character set. RMAN failed with:   [oracle@rac02a ~]$ rman target / catalog rman/rman@rman … Continue reading →

When dealing with large databases it might be neccessary to have more than 512 LUNs attached to the server. Most Linux distributions default to 512 luns max. This gets even worse with multipathing where each path is represented as a … Continue reading →

Somethimes – especially on RACs – it is required to synchronize permissions on an ORACLE_HOME  running on one node with the permissions running on the other node.   Today i had the problem that after a patch all permissions were … Continue reading →

Hi just discovered another flaw when having the workaround for CVE-2012-3132 in place. If you try to compile invalid database objects it will fail with: SQL> @$ORACLE_HOME/rdbms/admin/utlrp SELECT dbms_registry_sys.time_stamp(‘utlrp_bgn’) as timestamp from dual * ERROR at line 1: ORA-04045: errors … Continue reading →

The query: select   rtime as time,   sn.snap_id,   ts.name,   round(tablespace_size*tsb.block_size/1024/1024,0) SIZE_MB,   round(tablespace_maxsize*tsb.block_size/1024/1024,0) MAXSIZE_MB,   round(tablespace_usedsize *tsb.block_size/1024/1024,0) USEDSIZE_MB from   dba_hist_tbspc_space_usage tsu,   v$tablespace ts,   dba_hist_snapshot sn,   dba_tablespaces tsb where   tsu.tablespace_id=ts.ts#   and sn.snap_id= … Continue reading →

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 →