Posts

Showing posts from December, 2007

df emulation in ASM - asmbdf

When talking ASM between DBAs and System guys I had to let them "see" the new filesystem in the way they are used to.
I parsed the output of asmcmd utility to be as close as it can be to the command in Unix/Linux, I called it asmbdf:

#!/bin/ksh

export user=oracle
export ORACLE_HOME=`grep ASM /etc/oratab | cut -d: -f2`
export PATH=$PATH:~$user/dba/scripts/bin:$ORACLE_HOME/bin
export ORACLE_SID=`grep ASM /etc/oratab | cut -d: -f1`

asmcmd lsdg | \
awk '{
if ( FNR == 1 )
{
printf "%-20s %10s %10s %10s %10s %-20s\n","Filesystem","Size","Used","Avail","Use%","Mounted on"
}
if ( FNR > 1 )
{
if ( $2 == "EXTERN" ) { REDUNDENCY=1 }
if ( $2 == "NORMAL" ) { REDUNDENCY=2 }
if ( $2 == "HIGH" ) { REDUNDENCY=3 }
printf "%-20s %10d %10d %10d %10.2f%% %-20s\n",$(NF),($8/REDUNDENCY)*1024,(($8-$9)/REDUNDENCY)*1024,($9/REDUNDENCY)*1024,($8-$9)…

Fixing & Registering ORACLE_HOMES in Central Inventory

Central Inventory location is determined by oraInst.loc located in:
HP/Solaris /var/opt/oracle/oraInst.locLinux/etc/oraInst.locWindows\\HKEY_LOCAL_MACHINE\Software\Oracle\inst_locTo check if all oracle homes are registered within the Central Inventory run the following command:
${ORACLE_HOME}/oui/bin/opatch lsinventory -all
Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Oracle Home : /software/oracle/OEM10gR2/agent10g
Central Inventory : /software/oracle/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 10.2.0.3.0
OUI version : 10.2.0.3.0
OUI location : /software/oracle/OEM10gR2/agent10g/oui
Log file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/opatch/opatch....log

Lsinventory Output file location : /software/oracle/OEM10gR2/agent10g/cfgtoollogs/....lsinventory.....txt
----------------------------------...
List of Oracle Homes:
Name Location