My last post was about generating AWR reports from SQL – not a very complicated case. “But” – little word, big meaning. And suddenly we get a strange error message. In my example, I was especially interested in a Real Application Cluster’s “global” report. The subprogram call for that purpose is dbms_workload_repository.awr_global_report_text(), accepting the DBID, begin […]
Tag: cluster
Martin Klier in DOAG.tv Interview: Oracle Standard Edition
A while ago, DOAG.tv interviewed me about Oracle’s Standard Edition and database system migrations. The material was published just recently, so I’d like to share it. Enjoy, and if there are questions, just let me know! http://www.doag.org/home/aktuelle-news/article/oracle-database-standard-edition-versus-enterprise-edition.html I have to add a corrigenda: SE RAC is not – at least not at the moment – limited […]
DOAG Presentation: Oracle Standard Edition RAC
Wednesday last week, I had a presentation for my regional Oracle Users Group (DOAG Regio Nürnberg). The month before I was asked to display the difference between Enterprise Edition and Standard Edition RACs. Here comes the presentation (German), for questions and suggestions just let me know. Stay highly available Martin Klier […]
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 srvctl does not remove EONS despite it’s documented (PRKO-2013)
srvctl in Oracle Grid Infrastructure 11g Release 2 has at least one discrepancy between docs and functionality. I saw EONS consuming lots of memory in a non-database grid installation, and wanted to get rid of it. (The eONS is used by Oracle Enterprise Manager to receive notification of change in status of components managed by […]
Oracle Grid Infrastructure: UDEV fixing ORA-15081: failed to submit an I/O operation to a disk
If you plan to install Oracle products, be prepared for surprise of random kind. 🙂 The new Grid Infrastructure is no exception of this rule: I tried to install it on a SuSE Linux Enterprise Server (SLES) 10. Quick facts about the setup: SLES 10 SP 2 64bit Oracle Grid Infrastructure 11.2.0.1 x86_64 all devices […]