Monthly Archives: November 2008

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).

http://www.oracle.com/technology/products/forms/htdocs/10gR2/clientsod_forms10gR2.html

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

Installation / configuration Webutil 10.2.0.2 on Linux

Webutil installation / configurationĀ  on Application Server 10.2.0.2 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 10.1.2.0.2

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

Installing Grid Control 10.2.0.4

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

install-grid-control_10.2.0.4

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