Using Oracle KFOD utility

KFOD is another utility which is very helpful in troubleshooting the ASM disk related issues. I did not find much documentation around this utility, but I guess which is not needed. It is pretty straight forward to use. We can see the syntax of this utility by entering kfod -h.

We can mainly use this utility to check disk, diskgroup related statistics without actually connecting to ASM instance. This utility is available in GRID infrastructure home (not RDBMS home).

Following are few examples, how we can use this utility

-> Enter kfod, it will show you ASM instance name and the ASM HOME

$ kfod
——————————————————————————–
ORACLE_SID ORACLE_HOME
========================================================     
+ASM /oracle/10gr2

In case of RAC environment

$ kfod
——————————————————————————–
 Disk          Size Path                                     User     Group
========================================================
   1:       5112 Mb /dev/rdsk/c2t50060E800564F700d5s6        oragrid  oinstall
——————————————————————————–
ORACLE_SID ORACLE_HOME
========================================================    
+ASM2 /oragrid/11.2
+ASM1 /oragrid/11.2

-> Check the available disks for ASM use

$ kfod  a=’/dev/rdsk/c3*’ d=all
——————————————————————————–
 Disk          Size Path
========================================================
   1:      10222 Mb /dev/rdsk/c3t50060E800564F774d41s6
   2:     254929 Mb /dev/rdsk/c3t50060E800564F774d42s6
   3:     254917 Mb /dev/rdsk/c3t50060E800564F774d43s6
   4:     254917 Mb /dev/rdsk/c3t50060E800564F774d44s6
   5:     254917 Mb /dev/rdsk/c3t50060E800564F774d45s6
——————————————————————————–
ORACLE_SID ORACLE_HOME
========================================================     
+ASM /oracle/10gr2

-> Check diskgroup

$ kfod op=groups
——————————————————————————–
Group          Size          Free Redundancy Name
========================================================

   1:      20448 Mb      18250 Mb     NORMAL DG1
   2:      25540 Mb      22245 Mb       HIGH DG2
   3:       5112 Mb       3913 Mb     EXTERN FRA
   4:      10224 Mb       6614 Mb     EXTERN DG3
  
-> Check diskgroup and disk statistics   

$ kfod ds=true di=all
——————————————————————————–
 Disk          Size Path                                     Disk Group   User     Group
========================================================
   1:       5112 Mb /dev/rdsk/c3t50060E800564F700d18s6       EXTDG        oragrid  oinstall
   2:       5112 Mb /dev/rdsk/c3t50060E800564F700d19s6       EXTDG        oragrid  oinstall
   3:       5112 Mb /dev/rdsk/c3t50060E800564F700d33s6       NORMDG       oragrid  oinstall
   4:       5112 Mb /dev/rdsk/c3t50060E800564F700d36s6       NORMDG       oragrid  oinstall
   5:       5112 Mb /dev/rdsk/c3t50060E800564F700d37s6       NORMDG       oragrid  oinstall
   6:       5112 Mb /dev/rdsk/c3t50060E800564F700d47s6       NORMDG       oragrid  oinstall
   7:       5112 Mb /dev/rdsk/c3t50060E800564F700d4s6        FRA          oragrid  oinstall
   8:       5108 Mb /dev/rdsk/c3t50060E800564F700d53s6       HIGHDG       oragrid  oinstall
   9:       5108 Mb /dev/rdsk/c3t50060E800564F700d54s6       HIGHDG       oragrid  oinstall
  10:       5108 Mb /dev/rdsk/c3t50060E800564F700d55s6       HIGHDG       oragrid  oinstall
  11:       5108 Mb /dev/rdsk/c3t50060E800564F700d58s6       HIGHDG       oragrid  oinstall
  12:       5108 Mb /dev/rdsk/c3t50060E800564F700d59s6       HIGHDG       oragrid  oinstall
  13:       5112 Mb /dev/rdsk/c3t50060E800564F700d5s6        #            oragrid  oinstall
——————————————————————————–
ORACLE_SID ORACLE_HOME
========================================================     +ASM2 /oragrid/11.2
+ASM1 /oragrid/11.2
Advertisements
This entry was posted in Oracle Automatic Storage Management and tagged . Bookmark the permalink.

6 Responses to Using Oracle KFOD utility

  1. Pingback: Other DBA Related « Center Point for Oracle DBA & Kuwait Info

  2. idris says:

    great … short , brief but fantastic

  3. charlesdschultz says:

    I also recently discovered KFOD and like it a lot; provides a lot of useful information to a non-root user.

    Any idea how to install it as a standalone? I tried to copy the binary and the libraries, but must not have copied everything I need so far.

  4. Yes, I know that. My question is how to get it as standalone. The Provisioning utility of Enterprise Manager pushes out KFOD to target nodes, but in my case it is failing. Since I can observe that KFOD can be pushed as a standalone, I want to manually install KFOD on the target node and run it. The whole point of using the Provisioning pack is *NOT* to install the Oracle Software manually.

    And yes, I have filed numerous SRs already. :)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s