Usn's IT Blog

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…

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

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

   Read more…

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…

“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 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!
Usn