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 […]
Category: Oracle
What’s the difference between Larry Ellison and god?
Lecture “Basics of database technology” in German
Hi, today I’ll give a lecture about the “Basics of database technology” in German language for our Linux User Group Mitterteich (http://lug-mitterteich.de.vu) See the Handout and the Block handling overview. Regards Usn […]
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 […]
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 […]
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, […]