Lutz Haake | Freelance Oracle Consultant

How to use booleans in SQL and avoid ORA-00904

Try this: select true from dual; ORA-00904: "TRUE": ungültiger Bezeichner The reason behind this behavior is that…
How to fix a broken windows update

I needed to reactivate a windows 7 computer, which had been sitting on the shelf for about 6 months. It refused…
How to include time zone and daylight saving settings in scheduler jobs

In case one needs to include time zone and daylight savings information in a job schedule, it…
Logon problems in OMS12C

Logging on as sysman to the OMS console fails, apparently due to incorrect username/password. Rebooting the…
How to work around ORA-01489

Aggregating a large number of objects into one string can lead to ORA-01489, due to the 4000…
Real-Time SQL Monitoring — Statement Not Appearing

http://oracledoug.com/serendipity/index.php?/archives/1642-Real-Time-SQL-Monitoring-Statement-Not-Appearing.html
Windows 7 system backup fails with error code 0x81000033

This may happen due to a full “system reserved partition”. Solution: 1. go to system management —…
How to disable data vault — the right way

I needed to disable DV for a OMS upgrade. This recipe applies to 11gR2 on UNIX. 1) Stop…
How to resolve ORA-27211: Failed to load Media Management Library

Error stack: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of…
A powerful way to analyze log switches

A powerful way to analyze your log switch frequency is offered by this script. define granularity='DD'…