try this scripts : [oracle@db-35 tools]$ cat crstat #!/usr/bin/ksh # # Sample 10g CRS resource status query script # # Description: # - Returns formatted version of crs_stat -t, in tabular # format, with the complete rsc names and filtering keywords # - The argument, $RSC_KEY, is optional and if passed to the script, will # limit the output to HA resources whose names match $RSC_KEY. # Requirements: # - $ORA_CRS_HOME should be set in your environment RSC_KEY=$1 QSTAT=-u AWK=/bin/awk # if not available use /usr/bin/awk # Table header:echo "" $AWK \ 'BEGIN {printf "%-45s %-10s %-18s\n", "HA Resource", "Target", "State"; printf "%-45s %-10s %-18s\n", "-----------", "------", "-----";}' # Table body: $ORA_CRS_HOME/bin/crs_stat $QSTAT | $AWK \ 'BEGIN { FS="="; state = 0; } $1~/NAME/ && $2~/'$RSC_KEY'/ {appname = $2; state=1}; state == 0 {next;} $1~/TARGET/ && state == 1 {apptarget = $2; state=2;} $1~/STATE/ && state == 2 {appstate = $2; state=3;} state == 3 {printf "%-45s %-10s %-18s\n", appname, apptarget, appstate; state=0;}' eg: [oracle@db-35 tools]$ crstat HA Resource Target State ----------- ------ ----- ora.db-35.ASM1.asm ONLINE ONLINE on db-35 ora.db-35.LISTENER_DB-35.lsnr ONLINE ONLINE on db-35 ora.db-35.gsd ONLINE ONLINE on db-35 ora.db-35.ons ONLINE ONLINE on db-35 ora.db-35.vip ONLINE ONLINE on db-35 ora.db-36.ASM2.asm ONLINE ONLINE on db-36 ora.db-36.LISTENER_DB-36.lsnr ONLINE ONLINE on db-36 ora.db-36.gsd ONLINE ONLINE on db-36 ora.db-36.ons ONLINE ONLINE on db-36 ora.db-36.vip ONLINE ONLINE on db-36 ora.item.db ONLINE ONLINE on db-35 ora.item.item1.inst ONLINE ONLINE on db-35 ora.item.item2.inst ONLINE ONLINE on db-36 2012/7/9 Taylor, Chris David <ChrisDavid.Taylor@xxxxxxxxxxxxxxx> > So, why does "crs_stat -t" formatting not adjust correctly to my terminal > size? > (I'm using the default gnome-terminal in Oracle Linux so any suggestions > along that line are also appreciated) > > $ crs_stat -t > > Name Type Target State Host > ------------------------------------------------------------ > ora.GRID.dg ora....up.type ONLINE ONLINE rac1 > ora....ER.lsnr ora....er.type ONLINE ONLINE rac1 > ora....N1.lsnr ora....er.type ONLINE ONLINE rac2 > ora....N2.lsnr ora....er.type ONLINE ONLINE rac1 > ora....N3.lsnr ora....er.type ONLINE ONLINE rac1 > ora.asm ora.asm.type ONLINE ONLINE rac1 > ora.cvu ora.cvu.type ONLINE ONLINE rac1 > ora.gsd ora.gsd.type OFFLINE OFFLINE > ora....network ora....rk.type ONLINE ONLINE rac1 > .. > .. > > I downloaded > http://blog.enkitec.com/wp-content/uploads/2012/04/crsstat.v1.2.1.zipwritten > by Paul Elbow @ Enkitec but it seems (to me) that I should be able > to set up my default user profile so that crs_stat -t always displays > correctly but perhaps I'm mistaken. > > I don't understand why crs_stat is formatting so badly. > > Chris Taylor > > "Quality is never an accident; it is always the result of intelligent > effort." > -- John Ruskin (English Writer 1819-1900) > > Any views and/or opinions expressed herein are my own and do not > necessarily reflect the views of Ingram Industries, its affiliates, its > subsidiaries or its employees. > > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Phone: +86 13918046970 Email & Gtalk: ylouis83@xxxxxxxxx Personal Blog: http://www.vmcd.org -- //www.freelists.org/webpage/oracle-l