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 on AIX: How to find out the process memory usage
Calculating memory on Unix is tricky business. Especially when a complex software like Oracle Database has shared memory segments like SGA and Code Area. One might be convinced to use the following construction to calculate the overall memory footprint of Oracle processes running on this machine: ps -elf |egrep ” oracle* | ora_.*_* ” | […]
Speaking at COLLABORATE 14: “YOUR machine and MY database – a performing relationship!?”
I’m excited to announce that IOUG accepted my talk “YOUR machine and MY database – a performing relationship!?” for COLLABORATE 14 in Las Vegas. I’d love to see you there – for tech talk, gossip and meeting old and new friends! Abstract: Databases affect machines, machines affect databases. Optimizing one is pointless without knowing the […]
Oracle Datenbank Architektur – nicht nur für Einsteiger (DOAG Konferenz 2013)
Thanks everybody for attending my talk “Oracle Datenbank Architektur – nicht nur für Einsteiger” at DOAG Conference 2013. It was a great feeling to have a packed room there. As promised, here comes my presentation and whitepaper (both in German). OracleArchitektur-DOAG OracleArchitekturNichtNurFürEinsteiger_Klier Feedback is always appreciated! […]
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 […]
Martin Klier now on twitter
After ignoring the little bird telling things for quite a while, I decided to join the tweeters. Twitter might bring more color into my daily reading. 🙂 If you feel like, just follow me – @MartinKlierDBA […]
How to move a datafile as Oracle Managed File (OMF) before and after
Sometimes, you just have to move your data files away from where they sit. But when you love Oracle Managed Files as I do, you may want to have it being an OMF afterwards as well as before. Doing it the way you would have done it with ASM, fails. (RMAN> copy datafile 10 to […]
Oracle 12c: Change hostname for Grid Infrastructure / Oracle restart
Few days ago, we cloned a VM test system with ASM. Changing the hostname in this case is mandatory from our network, we have lots of issues if they are duplicate. But changing an Oracle Restart or generally, Grid Infrastructure setup’s hostname isn’t so easy – it’s written many configs. The only way is to […]
Oracle 12c New Features – Look at’s for 12.1.0.1.0
A new product … Last week I spent some days of intense investigation and testing the new database 12c. I found lots of great stuff (even about 11g 🙂 ), and some for sure will make it into a separate blog post. So these are just my notes of a very interesting couple of days, […]