Sometimes, a DBA has to write an externally called wrapper script for various Oracle-supplied commands accepting password inputs. A prominent and simple example is SQL*plus (sqlplus). The Problem The process list shows all parameters of a command that’s currently executed. wrapper1.sh Accepts all connection infos on the command line: #!/bin/bash cmdstring=”sqlplus ${1}/${2}@${3}” echo “Executed command: […]
Category: Linux / Unix
My experiences with the penguin and his colleagues.
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 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 […]
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 […]
Oracle: RHEL6 and Oracle Enterprise Linux 6 certified for Database 11.2.0.3
Hi Linux-DBAs, Red Hat Enterprise Linux 6 and Oracle Enterprise Linux 6 are now certified for Oracle Database 11.2.0.3. Please see this link: https://support.oracle.com/CSP/main/article?cmd=show&id=1441282.1&type=NOT Best regards Martin […]
DOAG Conference 2011 – Impressions and Look-at’s
Once again this year, the German Oracle Users Group has its annual conference and exhibition in Nuremberg. (DOAG Konferenz und Ausstellung 2011, Nürnberg). Being there is nearly a must for Oracle guys in German speaking countries. As usual, here comes my unordered, incomplete and ad-hoc list of things I wrote down to have a closer […]
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 […]
Linux Network bonding – setup guide
After looking up Linux bonding stuff for the thrid time, I planned to write an article aubout it. But there are lots of good blog posts on this, so just click here at unixfoo: Linux Network bonding – setup guide (strange link, I know, but it works) Hope it helps for you next high avaliability […]