Demands of Automation You can easily create an Oracle Data Guard Standby Database with the Database Configuration Assistant DBCA. That’s especially interesting if you have automation at work, and are not keen on configuring stuff all over the place. This is available in version 19c upwards. DBCA uses RMAN DUPLICATE FOR STANDBY with an auxiliary […]
Tag: ASM
How to disable Oracle ACFS drivers / registry resource
Sometimes an installed ACFS can cause trouble, especially if we don’t or can’t use it (e.g. when not using an UEK Linux kernel, like with SuSE Linux Enterprise Server SLES). There’s lots of documentation how to create and maintain ACFS file systems, but how to get rid of ACFS at all wasn’t so easy to […]
Oracle Grid Infrastructure / ASM – ERROR: failed to update diskgroup resource ora.DATA.dg
Recently, when installing a database on a grid infrastructure, dbca failed with the message that it wasn’t able to establish the dependency between the database and the corresponding grid infrastructure resource of the DATA ASM disk group I was using for my data files. Its name would have been “ora.DATA.dg”. (ERROR: failed to establish dependency […]
Upgrading Oracle Clusterware: [INS-40406] The installer detects no existing Oracle Grid Infrastructure software on the system
Upgrading Oracle Grid Infrastructure 11.2 (it’s just another marketing name for the Oracle Clusterware, formerly known as Cluster Ready Services CRS) usually is easy: The runInstaller offers an upgrade mode, and discovers nodes and versions without further effort. But what, if not? The message will be “[INS-40406] The installer detects no existing Oracle Grid Infrastructure […]
Oracle Clusterware 11.2: ASM crashes at startup
These days, a customer’s Oracle Clusterware (2 nodes) crashed one ASM instance at every startup. More Facts: It was not possible to start it manually, too. The CSSD was running. For obvious reasons, CRSD did not start. The other ASM instance in the cluster recognized CLUSTER RECONFIGURATION for a short period of time. The ASM […]
Oracle Grid Infrastructure: How to recover from a messed up ASM/CSSD diskstring
Oracle Grid Infrastructure 11.2 with voting files and OCR in an ASM diskgroup can be a little tricky if you mess up the voting file voodoo. You know the basic situation? With Oracle Grid Infrastructure aka Oracle Clusterware, we are storing your cluster quorum and config repository (OCR) into a disk group. But CSSD needs […]
Oracle ASM / CloudFS licensing policy
Sad to see, at least from June 1st 2011 the new Grid Infrastructure ASM features “ACFS” (ASM cluster file system) and “ADVM” (ASM dynamic volume manager) are now licensed as “Cluster FIle System” (ClusterFS). As far as I can see from the Technology Global Price List, it’s US$ 5000 per CPU, US$ 1100 perpetual. Alternatively, […]
Oracle ASM quote of the week
Please, do yourself a favour and NEVER EVER use ASM on Windows! “Dear Sir, obviously I forgot to put a file system on drives E:, F: and G: of the DB machine. I did this now, and hope you excuse the delay. Best regards John Doe Windows Server Administrator” /* no comment */ Martin […]
Oracle Grid Infrastructure 11gR2: How to clean up to repeat root.sh
To clean up a tilted installation of Oracle Grid Infrastructure isn’t that intuitive. I had to do it today, and this is my collection what to do and what to read. It’s made for repeating root.sh, that’s not allowed to run twice or more times without cleaning up in between. So first have a look […]
DOAG Konferenz 2009: Impressions Day 3 (final)
Thursday 19th was the last day of DOAG Confernce 2009. Compared with the second day, the program was much more dense: For my (DBA) profile there have been several hours, where more that one talk would have been appropriate. This list is, what I collected during the day. […]