Simple Scripting for your Exalogic Storage
- by Trond Strømme
As part of my job in Oracle ACS (Advanced Customer Services) I'm handling lots of different systems and customers. Among the recent systems I worked with have been Oracle's Exalogic engineered systems. One of the things I'd never had much exposure to as a system developer/architect/middleware guy/Java dude has been storage; outside of consuming it for my photography needs.. Well, I'm always ready for a new challenge...
I'd downloaded the 7000 series storage simulator when it was released in the good old Sun days, found it fun and instructive to play around with, but as I never touched storage in any way (besides consuming it..) I forgot about it. A couple of years ago when I started working with Exalogic engineered systems it again came into light as an invaluable learning and testing tool for the embedded storage in an Exalogic; Oracle's Sun ZFS Storage 7320 Appliance.
aaaanyway... I've been "booted" into a part-time role as the interim storage/system admin/middleware/Java guy for a client and found I needed to create the occasional report or summary or whatever.. of what's using the storage in the 7320 (as default configured for an Exalogic, 40T of disk in a mirrored configuration, yielding 18T of actual space.)
Reading the nice documentation and some articles on the Oracle Technology Network I saw great possibilities with the embedded ECMAScript3/JavaScript engine in the 7000 series.
In my personal opinion anyone who's dealing with Exalogic administration, or exposed to any of the 7000 series of storage appliances and servers that Oracle offers should have a VirtualBox instance of it kicking around. For development and testing it's a fantastic tool. (It can save you from explaining (most) of the embarrassing FAILS you can do if you test something in a production system to your management...)
So download, and install.
A small sidestep, if after firing up the 7000 series simulator in VirtualBox you've forgotten what it's IP address is, the following will sort you out if you log in directly via the running VirtualBox VM.
So in my case I can ssh to 192.168.56.101 or point a browser to https://192.168.56.101:215 to log into the storage appliance.
One simple way of executing a script on the 7320 is to ssh to the device and redirecting a file with the script in it to ssh.
ssh [email protected] < myscript.js
One question I got from my client and the people who will take over the systems was: "how can we see the quotas and allocations for all projects/shares in one easy go so we don't have to go navigating around in the BUI for all the hundreds of shares the 7320 is hosting just to check if anything is running dry?"
Easy!
JavaScript time, VirtualBox and emacs!
//NOTE! this script is available 'as is' It has ben run on a couple of 7320's, (running 2010.08.17.3.0,1-1.25 &
// 2011.04.24.1.0,1-1.8) a 7420 and the VB image, but I personally
//offer no guarantee whatsoever that it won't make your server topple, catch fire or in any way go pear shaped..
//run at your own risk or learn from my code and or mistakes..
script
run('cd /');
run('shares');
//get all projects:
proj = list();
function spaceToGig(bytes){
return bytes/1073741824; //convert bytes to GB
}
function fullInPercent(quota, space_data){
tmp = (space_data/quota)*100;
return tmp;
}
//print header, slightly good looking
printf(" %s/%-15s %8s(GB) %7s(GB) %5s(GB) %7s(GB) %3s\n","Project", "Share","Quota","Ref", "Snap", "Total","%full");
printf("-------------------------------------------------------------------------------\n")
//for each project, get all shares. check for quota and calculate percentage and human readable figures..
for (i=0;i<proj.length;i++){
run('select ' + proj[i]);
//get all shares for a project
var pshares = list();
//for each share get quota properties
for (j=0;j<pshares.length;j++){
run('select ' + pshares[j]);
quota = get('quota');
//properties associated with a share or inherited from a project
spaceData = get('space_data');
spaceSnap = get('space_snapshots');
spaceTotal = get('space_total');
if(quota>0){ //has quota
printf(" %s/%-15s \t%4.2fGB\t%.2fGB\t%.2fGB\t%.2fGB\t%5.2f%%\n",proj[i], pshares[j],spaceToGig(quota),spaceToGig(spaceData),spaceToGig(spaceSnap),spaceToGig(spaceTotal),fullInPercent(quota,spaceTotal));
}else{ //no quota
printf(" %s/%-15s \t%8s\t%.2fGB\t%.2fGB\t%.2fGB\t%s\n",proj[i],pshares[j], "N/A", spaceToGig(spaceData),spaceToGig(spaceSnap),spaceToGig(spaceTotal),"N/A");
}
run('cd ..');
}
run('done');
}
The resulting output should look something like this:
Project/Share Quota(GB) Ref(GB) Snap(GB) Total(GB) %full
-------------------------------------------------------------------------------
ACSExalogicSystem/domains N/A 0.04GB 0.00GB 0.04GB N/A
ACSExalogicSystem/logs N/A 0.01GB 0.00GB 0.01GB N/A
ACSExalogicSystem/nodemgrs N/A 0.00GB 0.00GB 0.00GB N/A
ACSExalogicSystem/stores N/A 0.04GB 0.00GB 0.04GB N/A
***_dev/FMW_***_1 133GB 4.24GB 0.01GB 4.25GB 3.19%
***_dev/FMW_***_2 N/A 4.25GB 0.01GB 4.26GB N/A
***_dev/applications 10GB 0.00GB 0.00GB 0.00GB 0.00%
***_dev/domains 50GB 10.75GB 3.55GB 14.30GB 28.61%
***_dev/logs 20GB 0.32GB 0.01GB 0.33GB 1.66%
***_dev/softwaredepot 20GB 4.15GB 0.00GB 4.15GB 20.73%
***_dev/stores 20GB 0.01GB 0.00GB 0.01GB 0.05%
###_dev/FMW_###_1 400GB 17.63GB 0.12GB 17.75GB 4.44%
###_dev/applications N/A 0.00GB 0.00GB 0.00GB N/A
###_dev/domains 120GB 14.21GB 5.53GB 19.74GB 16.45%
###_dev/logs 15GB 0.00GB 0.00GB 0.00GB 0.00%
###_dev/softwaredepot 250GB 73.55GB 0.02GB 73.57GB 29.43%
…snip
My apologies if the output is a bit mis-aligned here and there, I only bothered making it look good, not perfect :/ I also removed some of the project names (*,#)
