Articles Comments

AskDba.org Weblog » Unix

How To Discover Disk Name When LUN Number is Known (OEL5)

February 1st, 2010 | 2 Comments

I am creating 11gR2 RAC setup for one of my client. Following Oracle documentation for storage, I opted for Oracle ASM and asked storage team for new physical devices. Storage admin thus provided me with a set of LUNs instead of actual physical device names like /dev/sdcxxx. Now the major task is to get the actual device name associated with LUNs. In OEL4 this is easy to get by issuing # iscsi-ls -l This command will give output like: DEVICE DETAILS: --------------- LUN ID : 0 Vendor: DELL Model: MD3000i Rev: 0670 Type: Direct-Access ANSI SCSI revision: 05 page83 type3: 6001e4f0003fa9970000083c48573c94 page80: 383438303045500a Device: /dev/sdh LUN ID : 1 Vendor: … Read entire article »

Filed under: Unix, oracle

Failed dependencies error: lib* needed by unixODBC-devel-2.2.11-7.1.i386

August 2nd, 2009 | 4 Comments

While trying to install 11gR1 on Oracle Enterprise Linux (OEL5), runInstaller failed for unixODBC* packages. To solve the issue , I started following OTN article http://www.oracle.com/technology/pub/articles/smiley-11gr1-install.html When trying to install RPM from CD3, faced following errors for unixODBC* rpm #rpm -ivh compat-libstdc++-33* libaio-devel* sysstat* unixODBC* warning: compat-libstdc++-33-3.2.3-61.i386.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159 error: Failed dependencies: libboundparam.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libesoobS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libgtrtst.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libmimerS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libnn.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbccr.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcdrvcfg1S.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcdrvcfg2S.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcinst.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcminiS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbcnnS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbctxtS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 liboplodbcS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 liboraodbcS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libsapdbS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libtdsS.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libtemplate.so.1 is needed by unixODBC-devel-2.2.11-7.1.i386 unixODBC = 2.2.11-7.1 is needed by unixODBC-devel-2.2.11-7.1.i386 libodbc.so.1 is needed by … Read entire article »

Filed under: Unix, oracle

Use awk/sed in vi

July 2nd, 2009 | 3 Comments

Thought of sharing some useful info which can help you to do your work faster in vi.You can use awk/sed scripts in vi using following command in vi :%!scriptname Here the scriptname file should have execute privilges for user. I used this to create a useful script which I was doing by typing multiple substitution command in vi. e.g Your file contains list of table $cat t.lst BANK005 BJSTM BJS_ORG CHAINED_ROWS CORR_BAM CORR_CAM CORR_EIT CORR_GAC CORR_GAM CORR_ITC CORR_LDT CORR_LHT Create script (quotes)  with following command and give execute permission to user. sed -e “s/^/’/g” -e “s/$/’,/” $1|awk ‘{printf (“%s”,$0)}’|sed -e “s/^/(/g” -e “s/,$/)/g” open t.lst in vi and type :%!quotes ('BANK005','BJSTM','BJS_ORG','CHAINED_ROWS','CORR_BAM','CORR_CAM','CORR_EIT','CORR_GAC','CORR_GAM','CORR_ITC','CORR_LDT','CORR_LHT') Similarly if you wish to remove blank lines, have a file blank like awk ‘!NF==0 {print $0}’ $1 Blank lines can also be directly removed from vi using :g/^$/d Isn’t it cool.. … Read entire article »

Filed under: Unix