Monthly Archives: March 2010

Error while loading shared libraries: libcap.so.1: cannot open shared object file

Oracle 11gR2 Grid, on SLES 11 (x86_64), 2.6.27.19-5 When I executed, root.sh on first node, it failed with “/oragrid/bin/clscfg.bin: error while loading shared libraries: libcap.so.1: cannot open shared object file: No such file or directory” error # /oragrid/root.sh Running Oracle … Continue reading

Posted in Oracle Software Install / Deinstall | Tagged | 4 Comments

ASM – Removing disk with HUNG state

Diskgroup with different redundancies HIGHDG – HIGH redundancy NORMDG – NORMAL redundancy DATA – EXTERNAL redundancy FRA – EXTERNAL redundancy NOTE: HIGHDG & NORMDG, both of these DG’s had only one disk in each failgroup SQL> select group_number, path, name, … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment

ASM – CANDIDATE or FORMER disks show FREE_MB as 0

Solaris 10 update 8, with Oracle 10gR2 (10.2.0.4) ================================= Normally in Solaris when we prepare a disk for ASM use, a. we format the disk b. create hog partition c. change permission to oracle:dba & use the disk I did … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | 1 Comment

ASM – Rebalancing multiple diskgroups at same time

I wanted to rebalance 2 diskgroups at the same time on an standalone ASM instance. So I issueed 2 rebalance commands as following SQL> ALTER DISKGROUP TESTDG REBALANCE POWER 10 / SQL> ALTER DISKGROUP FRA REBALANCE POWER 10 / To … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment

ASM localconfig and clsclisten: Permission denied

I was manually trying to create ASM instance. I executed the $ORACLE_HOME/bin/localconfig add, but the ocssd process was not coming up. When I checked the /oracle/log/dbserv01/cssd/ocssd.log, found following errors like Permission denied, listening failed etc. [ CSSD]2010-01-18 03:05:59.373 >USER: Copyright … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment

Manual ASM instance creation

There are some situations, when we cannot use dbca GUI to create the ASM instance. Following procedure describes the manual ASM instance creation process Step 1 ====== Create the required directory structure (this will change for 10g & 11g) oracle$> … Continue reading

Posted in Oracle Automatic Storage Management | Tagged | Leave a comment

Network essentials for Oracle RAC DBA

For Oracle RAC install one is expected to know about basic Network related stuff, which will help in troubling shooting some basic stuff. NOTE: Applicable to Solaris only, other *nix will have equivalent commands. 1. How to check available network … Continue reading

Posted in Oracle Real Application Cluster | Tagged | 1 Comment