Archive for 2008

New job in 2009 – looking back at A.T.U

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:

Read more…

By Martin Klier in Oracle  .::. Read Comments (2)

Single Sign On for Apache 2.2 and Active Directory 2003 R2 with SuSE 10.2, mod_auth_kerb and MIT Kerberos

this is a small howto out of my needs, suggestions are always welcome!

  1. Assumptions for this paper
    1. You know and basically follow, but there are some facts missing/wrong.
    2. 2003R2 KDC’s are and (DNS: and
    3. Kerberos Realm for ADS is ADS.EXAMPLE.COM (upper case required!)
    4. Web server (hostname.domain) is
    5. DNS and reverse DNS on and for the machine in FQDN works, verified with “dig” and “dig -x”

    Read more…

By Martin Klier in Linux / Unix  .::. Read Comments (2)

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 this post here.

That’s a PL/SQL script to remove them subsequently, this example focuses on jobs of type ‘ONCE’ and a special user, but it should be no trouble to change the query on dba_scheduler_jobs in a way you need it for your situation.

Read more…

By Martin Klier in Oracle  .::. (Add your comment)

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 (“. (I don’t consider this IT blog being a homepage, it’s more or less a public note pad.)

Let me tell you, typo3 is ugly, i18n is ugly, and my unnamed (non-Oracle) web database backend is ugly as well. Without the help-to-help-myself from Maxi (typo3) and TheBonsai (general coding), it would have been a complete mess and waste of time. But sometimes, a quick, customized explanation (aka personal tutorial) immensely speeds up the process. Poor olde brain. :)

Thanks a lot, guys!

By Martin Klier in About this blog  .::. (Add your comment)

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.


By Martin Klier in Community,Humor  .::. (Add your comment)

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 case, be careful to issue the stop command on the correct instance!

Furthermore, the command “ALTER SYSTEM SET DISPATCHERS=” has a mad behaviour, if you are using a multi-threaded server setup and you are configuring the DISPATCHERS init parameter in the appropriate way. Let me give you an example (mind to remove the CR/LF, alter system won’t like them):
Read more…

By Martin Klier in Oracle  .::. (Add your comment)

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:

Have fun

By Martin Klier in Linux / Unix  .::. (Add your comment)

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: A throughput of about 1200MB/s and nearly 1200 iops. Period. You may quickly want to see detailed results on the bottom of the page, but for fully understanding of the results look up the setup as well.
Read more…

By Martin Klier in Hardware,Linux / Unix,Oracle  .::. Read Comments (3)

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.

Craig Challahamer 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 reason of slow databases – the class tilte looked promising in this context. But lets report in chronological order. Read more…

By Martin Klier in Oracle  .::. Read Comment (1)

memlock config for Debian Lenny


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 user newly logged-in user oracle still shows “32”.

After researching for a while, it became clear that there has to be something fishy with using the “su” command, the “ulimit -a” output has been different in several points, compared with a native console login. Debian project philosophy “make it hard” struck again: Look up /etc/pam.d/su, and find, that there is a block:

# Sets up user limits, please uncomment and read /etc/security/limits.conf
# to enable this functionality.
# (Replaces the use of /etc/limits in old login)
# session    required

Needless to say, it worked after uncommenting the last line. And, keep in mind, it depends on a well configured limits.conf. But why, for sake, do I have to change that for my hobby distribution?

With pain in the backside and a bit frustration,

By Martin Klier in Linux / Unix,Oracle  .::. Read Comment (1)

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.