About

Martin Klier

usn-it.de

Lecture “Highly available Communications Server” (Oracle Database) at DOAG conference 2007

Hi, I’ll give a lecture about high availability with Oracle RAC and Dataguard at DOAG Conference 2007 (annual conference of the German Oracle User’s Group). The talk will be in German. (“Ein hochverfügbarer Kommunikationsserver mit RAC, ASM, redundant shared media und DataGuard”) When? Thursday, November 22nd 2007 1300hrs Where? CCN CongressCenter Nürnberg Ost Messezentrum D-90471 […]

read more

Solaris SMF (Service Management Facility) introduction

Hi, Solaris is great. I found out as I purchased an used Fujitsu Siemens Primepower 400 some time ago. Now, here is a new category: Solaris, and most time it will mean Solaris 10. Solaris IS cool – not at least because of its stable and self-healing system service management, called “SMF” (Service Management Facility), […]

read more

Scheduler hangs in Oracle Database 10g

Hi, sometimes the 10g scheduler refuses to start jobs any more. I do not know why at the moment, but as a workaround you can just kill -9 the “coordinator job queue (CJQ0)” process from OS level. The process will be named like “ora_cjq0_SID” in a RAC. PMON does a restart of the coordinator after […]

read more

How to fail over a client transparently in a dataguard switchover/failover scenario

Hi, with using dataguard (Oracle’s hot/cold standby database solution) you have the challenge to make a failover or a roleswitch between the primary and the standby database transparent to the clients. If you don’t, you will have a (partially) loss of service: Clients tnsnames.ora’s will need reconfiguration or the application has to use another TNS […]

read more

Job exchange for Linux/OSS

Hi, this idea looks good to me: http://www.linux-lancers.com/de/ It’s a free job platform for Linux and OSS – I think the world needs things like this. Please let me know whether it works or not. Good luck, Usn […]

read more

run Cisco VPN client as non-root-user

Hello, if you want to run the vpnclient as non-root-user (very desirable), you probably will get privsep: unable to drop privileges: group set failed. since the cvpnd needs to be run with root privileges. Just give it the setuid root-Flag: chmod 4111 /opt/cisco-vpnclient/bin/cvpnd and have fun with yout user-built VPN tunnel. Regards, Usn […]

read more

new GNU bash forum rising

Hi, TheBonsai started a brand-new bash forum at http://forum.bash-hackers.org. Since I know him as a real skilled bash poweruser it should be fun to learn from the site. Just have a look. Yours, Usn […]

read more

Apache 2.2 – “unable to include potential exec”

Hi, recently I’ve seen ugly error pages (e.g.for 404 or 403) on my Apache 2.2 server: The supplemental text blocks have been there, but instead of header, footer and spaces “[an error occured while processing this directive]” was shown. For these accesses, the Apache error.log showed “unable to include potential exec ‘include/top.html’ in parsed file […]

read more

Prepare IPtables for the Cisco VPN Client

Hi out there, installing the Cisco VPN Client 4.8.00 should be no problem (just run “vpninstall” with kernel headers installed). But running it from the notebook in an insecure environment needs a host firewall on the mobile device. I love setting the default policies of a chain to “DROP”! But the VPN Client communicates via […]

read more

How to create a self-signed OpenSSL certificate

Hi folx, if you want to create a self-signed certificate with OpenSSL (useful for encryption-only purposes, e.g. your own mailserver) just do the following: openssl req -x509 -nodes -days 365 -subj ‘/C=DE/ST=Bayern/L=Munich/CN=www.example.com’ -newkey rsa:2048 -keyout key4cert.pem -out cert.pem It means: “-nodes” makes the key unencrypted “-days” makes it valid for n days “-subj” provides your […]

read more

Lost, deleted or corrupted a voting disk (quorum) in Oracle RAC 10.2 ?

Hi Folx, whenever you lost, deleted or corrupted a quorum aka voting disk in Oracle Real Application Cluster (RAC) 10.2, you have three options: 1) Reinstall your Clusterware, see Metalink Note 279793.1 2) Replay a backup taken with “dd if=/dev/votingdisk of=/backup/votingfile bs=4k” 3) Have a look at Metalink Note 399482.1 and the RAC Administration and […]

read more

How to move or add a controlfile when ASM is involved

Hi folx, sometimes, you may want to add or move a controlfile. On OS file system, this is no problem. Just “shutdown immediate”, change the CONTROL_FILES init parameter, copy or move the controlfile, and startup again. With ASM involved this is not possible, since the ASM does not allow direct move or copy commands. You […]

read more

Grid Control Agent install without Metalink Access

Hi folx, if you ever need to install Grid Control Agent 10g, there will be no option to avoid configuration of your Metalink Access Data. But you may want to avoid this. The trick is simple: Just decline the License Agreement in the middle of the runInstaller process. The function of agent will be installed, […]

read more

Asterisk at Usn’s

Hi, Asterisk PBX is a very smart telephone system for home, office and enterprise use. In December 2006 I had to decide between purchasing a new ISDN/analogous system for about 2 external ISDN- and 20 internal extension lines or trying something new, even cheaper. The Pros and Contras of Asterisk for me have been: […]

read more

Just another blog?

Hi folx, you may think: “Just another blog?” – and you may be right. But I had the intention to make notes about my IT work – why not publishing them? So this blog will provide hints and config snippets out of my daily life. I hope, here you can find what you are looking […]

read more