Monday, 5 October 2015

Microsoft Message Analyzer Tool - Free Download

Install and Configure:
1. Download MessageAnalyzer64.msi file from the above link and install. Installation is straight forward.
2. After installation, We have to configure a live trace session. https://technet.microsoft.com/en-us/library/jj659285.aspx
3. Communication on this link is encrypted. To decrypt the message we need to import rui.pfx file in the Analyzer tool. location of rui.pfx --> C:\ProgramData\VMware\VMware VirtualCenter\SSL\rui.pfx (Default passowrd - testpassword)https://technet.microsoft.com/en-us/library/Dn727244.aspx#BKMK_DecryptTraceData
4. Create a Capture filter to avoid unnecessary packets. At VC side requests from VCO are recceived at port 443, We can create a filter like this tcp.port==443 and *Address==<VCO IP Address> find more about creating filters at -https://technet.microsoft.com/en-us/library/JJ738055.aspx Above filter capture all incoming requests coming from VCO to VC on port 443.
5. Keep it running till issue stops occurring.

Tuesday, 5 May 2015

Oracle Kfed Utility to repair formatted asm disks

Error in Altering Data Group

ORA-15032: not all alterations performed
ORA-15040: diskgroup is incomplete
ORA-15042: ASM disk "13" is missing from group number "1" 


Problem Statement - Accidently formatted one of the member disk of the diskgroup using dd command
Impact - dd command formatted the disk thus losing the ASM header information and corrupting the whole diskgroup

Solution -

Repair the formatted disk with "kfed" utility provided by Oracle

cd $ORACLE_HOME/rdbms/lib
make -f ins* ikfed
$ORACLE_HOME/bin/kfed read /dev/rhdisk9
kfbh.endian:                          0 ; 0x000: 0x00
kfbh.hard:                            0 ; 0x001: 0x00
kfbh.type:                            0 ; 0x002: KFBTYP_INVALID
kfbh.datfmt:                          0 ; 0x003: 0x00
kfbh.block.blk:                       0 ; 0x004: blk=0
kfbh.block.obj:                       0 ; 0x008: file=0
kfbh.check:                           0 ; 0x00c: 0x00000000
kfbh.fcn.base:                        0 ; 0x010: 0x00000000
kfbh.fcn.wrap:                        0 ; 0x014: 0x00000000
kfbh.spare1:                          0 ; 0x018: 0x00000000
kfbh.spare2:                          0 ; 0x01c: 0x00000000
000000000 00000000 00000000 00000000 00000000  [................]
  Repeat 255 times
KFED-00322: Invalid content encountered during block traversal: [kfbtTraverseBlock][Invalid OSM block type][][0]


As you see disk /dev/rhdisk9 had issues since it was formatted. Now repair the disk using following command

$ORACLE_HOME/bin/kfed repair /dev/rhdisk9

Once it is done, you can mount the diskgroup and do the alterations on it.