Why Oracle 23ai from Exadata? With Oracle Database 23ai being postponed to a later date (“tba”) in November 2024, and many people not being part of the Oracle Beta Program, it might be useful to install a regular database 23ai (not the Developer Free Edition), but of course for testing purposes only! This has to […]
Category: Cluster and RAC
Oracle gridSetup.sh Fails with Error Code 255
Bash Error 255 Sometimes you have to apply a RU when launching Oracle 19c gridSetup.sh to install Oracle Grid Infrastructure or Oracle restart. For example when you install it in its vanilla 19.3 version on Oracle Linux 8. OL8 did not exist when they made 19.3, so some of its specials (like verifying group/user existence) […]
Make Linux Disk IDs Visible for UDEV (in VMware)
VMware is a factor Times and syntaxes change, so it’s time to refresh an old blog post a bit. Especially VMware has established its place in the Oracle world, and it can be tricky to map disk IDs directly into the VM. Many sources recommend to use the SCSI addresses, but I learned to never […]
Oracle on Windows: ASM instance terminated by LMON / ORA-27300 IPC_TCPConnectCheck failed with status -1
Recently I had an issue with a two-node Grid Infrastructure on Windows 2012R2. After an infrastructure-caused cluster restart (irresponsible SAN hardware patching 🙂 ), everything was running on Node 2, and Node 1 could not join the cluster any more. No easy solution: On CSSD level, there was no issue (network and disk heartbeat worked, […]
Oracle on SLES12 SP2 – Avoiding Cgroup Task Limit
Once upon a time, there was an Oracle RAC cluster 12.2.0.1 on SUSE Linux Enterprise Server (SLES) 12 SP2, that did not do well. Its database and ASM instances used to fail with: ORA-27300: OS system dependent operation:fork failed with status: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred at: skgpspawn3 Of […]
Oracle RAC 12.2 on SLES12 – How to disable Hardware Lock Elision Support
The Problem In the last week, I had to set up an Oracle RAC (and thus, the Clusterware) version 12.2.0.1 on SuSE Linux Enterprise Server 12 SP2 (SLES12 Sp2). The gridSetup.sh failed latest in root.sh of the first node with a kinda non-intuitive error: CRS-5804: Communication error with agent process CRS-4000: Command Start failed, or […]
Oracle RAC 12.2 High Load on CPU from gdb when Node Missing
Recently I had to battle a new issue with the quite-new Oracle Database RAC Version 12.2.0.1 on Linux x86_64. The idea of RAC is, to compensate the loss of a node or service by restarting services on other nodes. But in my case, when one node in a two-node-Cluster was down (or the crs stack […]
Oracle 11g unable to extend datafile but ASM disk group shows free space
Sometimes Oracle Database 11gR2 complains about not being able to extend a (lob) segment with ORA-1691, but ASM monitoring based on USABLE_FILE_MB did not fire. Adding a new data file fails with ASM ORA-15041. I was under the impression this behaviour of ASM deserved some explanation. Situation Database Alert Log complains with ORA-1691: ORA-1691: unable to extend lobsegment MYUSER.SYS_LOB0013128030C00003$$ […]
Looking forward to speaking at COLLABORATE16 IOUG Forum
Yes, I did it again, submitted and got two papers accepted – speaking at COLLABORATE16 in Las Vegas (#C16LV) is always a highlight of the year! This time, it will be: The Bad One In Your Crop – SQL Tuning Analysis For DBAs 4:30 PM–5:30 PM Apr 11, 2016, Palm-A Oracle Core: 12c InMemory Column […]
Featured by Oracle Magazine
The Oracle Magazine featured me in its January / February 2016 issue. I really feel honoured and would like to say thank you for the opportunity! For details, please see the Performing Databases Blog post about the publication. […]
DOAG noon2noon RAC & Dataguard – Quick Report
There’s always something to learn – for example about Oracle RAC (Real Application Clusters) and Dataguard. And the old-school frontal teaching concept is boring, and more important, ineffective after a few hours of passive listening. So the German Oracle Users Group DOAG organized a “noon2noon” event: “Oracle RAC and Dataguard” this week in Würzburg (January 2 1st-22nd 2016). It was the […]
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 […]
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 […]