About

Martin Klier

usn-it.de

Oracle 10gR2 Clusterware on Novell/SuSE SLES10 on multipath devices

Hi RAC-DBAs, installing the Oracle Clusterware CRS 10.2 on SLES10 with its multipath devices can be tricky. Background: The tool formatting the OCR disks, clsfmt.bin, is buggy concerning multipath / device mapper devices and you will see root.sh fail and clsfmt spit out errors like: clsfmt: Failure trying to resize OCR file from … bytes […]

read more

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

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

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