Author Archives: Ronny Egner

Since i haven´t found this on the web: When you try to create a table with MDSYS.SGO_GEORASTER and you´re receiving an ORA-00902: invalid datapye try the following: SQL> @create_tab.sql         “GEORASTER” “MDSYS”.”SDO_GEORASTER” ,                             * ERROR at line 12: ORA-00902: … Continue reading →

Some days back i setup a new server for a customer of mine. Installation and patching ran fine, cluster was stable – no issues. Then suddenly the cluster started to act strange. Commands did not work anymore; after a reboot … Continue reading →

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 →