After working at A.T.U Auto-Teile-Unger headquarters for over six years, there’s a new challenge calling on January 1st, 2009, and hopefully, it’s for a long time again. I guess it’s a good time to look back: […]
Year: 2008
Single Sign On for Apache 2.2 and Active Directory 2003 R2 with SuSE 10.2, mod_auth_kerb and MIT Kerberos
Hi, this is a small howto out of my needs, suggestions are always welcome! Assumptions for this paper You know and basically follow http://www.grolmsnet.de/kerbtut, but there are some facts missing/wrong. 2003R2 KDC’s are 10.0.0.1 and 10.0.0.2 (DNS: dc1.example.com and dc2.example.com) Kerberos Realm for ADS is ADS.EXAMPLE.COM (upper case required!) Web server (hostname.domain) is webhostname.server.example.com DNS […]
Oracle: Remove scheduler jobs in a loop
If there are too much scheduler jobs in an Oracle database, the CJQ process may die unexpectedly. This has nothing to do with job history, not, it’s the number of jobs known to the system. In my experience, the critical number is somewhere around 32.000 in 10.2 64bit. By the way, that’s the solution for […]
Internationalization fever
“Because God got angry at some point in time, computer programmers are forced to deal with localisation and internationalisation.” (From a typo3 tutorial.) That’s a cool sentence, and the point I laughed about it is gone long time ago. The last days I spent with i18n for my “Usn’s web site (http://www.usn-online.de)“. (I don’t consider […]
This site is not tested with Internet Explorer(c) :)
Have you heard of the “Not tested in IE initiative“? If your site matches this criteria, use one of these images there. Regards Usn […]
Oracle: How to stop a (MTS) dispatcher process – mad behaviour of ALTER SYSTEM
Manually stopping a dispatcher process is one of the things I have to look up each time, since it’s needed not that often. And, the word “dispatcher” does not appear in the command line! 🙂 alter system shutdown immediate ‘D000’; where “D000” is the dispatcher process name selected from v$dispatchers or gv$dispatchers. (In the latter […]
Switch workspace on command line
Sometimes, it’s nice to change the current windowmanager workspace on command line, for example if you desire to start a application exactly HERE or THERE. For KDE you may want to do it with “kstart”. But a tool like kstart might not be available for your windowmanager, so have a look at “wmctrl” as well: […]
Oracle 10g Data warehouse ORION benchmark, size 20TB, 1200MB per second
During the last days, I have had the opportunity to test and benchmark a data warehousing hardware, that’s really fast for its money. It’s not suitable for real/available production, since it depends on disk striping over a bunch of components, but I considered it as a good way to push the limits a bit. Result: […]
Attended “Reactive Performance Management” with Craig Shallahamer
Monday and today (Tuesday) I attended a 2-days Oracle University class with Craig Shallahamer from OraPub, taking place in Munich. Honestly, I have had no expectations at all, so there has been nothing to be crestfallen or to be fulfilled. I just was looking forward to the one or other hint how to find the […]
memlock config for Debian Lenny
Hi, today I tried to start Oracle XE with parameters “pre_paged_sga=true” and “lock_sga=true” on my Debian Lenny toybox. But Lenny has had a rather strict and really sticky value for the user’s maximum amount of pinned memory (ulimit -l) value: 32 (kb). First attempt, change /etc/security/limits.conf: oracle – memlock 1073741824 Result: Nothing, “ulimit -l” as […]