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 […]
Category: Cluster and RAC
What is a “RAC Battle”?
RAC Battle [ræk ˈbæt̬l̩] What is a “RAC Battle”? It is a format of presenting technology – two experts, battling against each other on pros and cons of Oracle Real Application Cluster. Björn Rost (Oracle ACE Director) and Martin Klier (Oracle ACE) will fight Wednesday November 18th, 2015 11 am Nürnberg CCN (DOAG Konferenz 2015) […]
Oracle dbms_workload_repository awr_global_report_text fails with ORA-06553 PLS-307
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 […]
How to create an Oracle AWR report with SQL and PL/SQL
AWR is a great tool (but needs diagnostics pack). It can create very useful reports for performace analysis over a given period. Most people will pull the AWR Report from the OS level, with ‘@?/rdbms/admin/awrrpt.sql” (or one of the other scripts there). But sometime it’s not possible to access a database server’s OS level, or […]
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 […]
Oracle 11.2 PSU2 Grid Infrastructure stack start … failed to complete at crsconfig_lib.pm line 11814
Oh, sometimes it’s just (own or close-people’s) PEBKAC that costs you time and gray hair… Patching 11.2.0.4.x to PSU2 on Linux was such an issue. Problem “opatch auto” with all comfort worked well, applied the patch, but re-starting the clusterware failed with: Starting CRS… Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been […]
Oracle Clusterware root.sh issue: USM driver install actions failed (oracleoks.ko)
As I already said in my last post about “Can’t install ohasd service“, setting up Oracle Clusterware 11.2.0.4 on SuSE Linux Enterprise Server (SLES) SP2 should work flawlessly, but sometimes it does not. 🙂 This time, it was about the USM drivers. USM driver install actions failed /u01/app/grid/11.2.0/perl/bin/perl -I/u01/app/grid/11.2.0/perl/lib -I/u01/app/grid/11.2.0/crs/install /u01/app/grid/11.2.0/crs/install/rootcrs.pl execution failed USM drivers […]
Oracle Clusterware root.sh fails: Can’t install ohasd service: Inappropriate ioctl for device crsconfig_lib.pm line 5427
Setting up Oracle Clusterware 11.2.0.4 on SuSE Linux Enterprise Server (SLES) SP2 should work flawlessly, but sometimes it does not. 🙂 It turned out that this would become a pair of blog entries. Second one is about “USM driver install actions failed (oracleoks.ko)“. But step by step. On Saturday morning, root.sh failed with the following […]
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 […]
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 […]