Hangende dbms_scheduler jobs na database down

Een datawarehouse-achtige database heeft zo’n 278 scheduler_jobs lopen. Database gaat down voor onderhoud, blijft een avondje uit. Na opstarten van de database blijkt dat de next_run_date van de meeste jobs kleiner is dan de sysdate, en de jobs niets meer doen.


By | November 25th, 2008|Categories: Database, RAC|0 Comments

Forms-certificatie (10gR2-10.2.x) versus browsers

Vroeger kon je op Metalink eenvoudig certificatie matrices vinden. Deze niet, staat (na speurwerk) weer op OTN: welke versie van welke browser is gecertificeerd  tegen welke versie van form (of andersom).


By | November 20th, 2008|Categories: App. Server|0 Comments

Installation / configuration Webutil on Linux

Webutil installation / configuration  on Application Server at  Suse Linux 9, 64-bits. Combination of several notes:

374128.1 – howto install webutil on oas under Linux/Unix.

333385.1 – Kickstarting WebUtil 1.06 in Developer Suite


By | November 14th, 2008|Categories: App. Server|Tags: , |10 Comments

Installing Grid Control

Redelijk gedoe met versies. Basis: Suse Linux 9, 32-bits. Agents op Suse Linux: versie 9 en 10, 64-bits.


By | November 14th, 2008|Categories: grid control|Tags: , |0 Comments

Backup database shell-script with RMAN

A proper backup is the base for a well and relaxed administration of yout databases.What follows is a backup-script which I use for several customers. It’s backing up all in the same directory and I tested the restore frequently.

There’s however one drawback: I copied the script through word- or notepad apparently, so take care of the (double) quotes used in the script. You may have to re-type them.


By | November 14th, 2008|Categories: RMAN|Tags: , |0 Comments