AIX shell工具集

fzm

谢谢楼主了。

mxin

[原创]13.收集系统信息
echo --------------------------------------`hostname`-------------------------------------------
prtconf
echo -----------lsvg;lsvg `lsvg -o`
echo "-----------lsvg -l ";lsvg -l `lsvg -o`
echo "-----------lslv lv ";lsvg -l `lsvg -o`|grep -v "LV NAME"|grep -v awk '{print "lslv "$1}'|sh
echo -----------df;df -k;lsfs
echo -------------netstat;netstat -in;netstat -i;netstat -r
echo -------------------ps;ps -efk;ps gu
echo ------------------lscfg;lscfg -vp
echo --------------lssrc;lssrc -a
echo ------------lsslot;lsslot -c pci
echo -------------lspv;lspv
echo -------------lslpp;lslpp -l
echo -------------lsattr; lsdev -C|awk '{print "echo ---"$1";lsattr -El " $1}'|sh
echo -------------prtconf -v;prtconf -v
echo -------------errpt; errpt ;errpt -a
echo -------------major; ls -al /dev/*
echo -------------hosts file; cat /etc/hosts
if [ `ps -ef|grep cluster|grep -v grep|wc -l` -ge 1 ] ;then
echo -------------HA INFO
/usr/es/sbin/cluster/utilities/cltopinfo -c;/usr/es/sbin/cluster/utilities/cltopinfo -n;/usr/es/sbin/cluster/utilities/clshowres -n
`hostname`;/usr/es/sbin/cluster/utilities/cldisp
fi

[ 本帖最后由 mxin 于 2006-9-21 16:03 编辑 ]

mxin

[原创]14.将多级子目录的权限放开
#chmod_dir.sh
echo for example::chmod_dir.sh rwx /home/mxin/mon
echo $1$2 >/tmp/chmod_dir.txt
cat /tmp/chmod_dir.txt|awk  -F / '{print "chmod  o+x /"$2";chmod o+x /"$2"/"$3";chmod o+x /"$2"/"$3"/"$4";chmod o+x /"$2"/"$3"/"$4"/"$5";chmod -R o+"$1" /"$2"/"$3"/"$4"/"$5"/"$6}'|sh

bluesq112

收了,
谢谢啦!

Weget

留名的哈

mxin

[原创]15.监控oracle是否有锁。
#mon_db_lock.sh
. .profile
cd  /home/mxin/mon
if [ `date +%H%M` = "0800" ]; then
echo 0 > warn_count
fi
warn_count=`cat warn_count`
sqlplus "/as sysdba" <<EOF
set feed off;
set heading off;
spool /tmp/db_lock.out1;
@mon_db_lock.sql
spool off;
exit
EOF
sleep 13
sqlplus "/as sysdba" <<EOF
set feed off;
set heading off;
spool /tmp/db_lock.out2;
@mon_db_lock.sql
spool off;
exit
EOF
sleep 27
sqlplus "/as sysdba" <<EOF
set feed off;
set heading off;
spool /tmp/db_lock.out3;
@mon_db_lock.sql
spool off;
exit
EOF
cat  /tmp/db_lock.out1|grep -v SQL|grep [0-9] >/tmp/mon_db_lock.out1
cat  /tmp/db_lock.out2|grep -v SQL|grep [0-9] >/tmp/mon_db_lock.out2
cat  /tmp/db_lock.out3|grep -v SQL|grep [0-9] >/tmp/mon_db_lock.out3
cat /tmp/mon_db_lock.out1|grep -v SQL|grep [0-9]|awk '{print "grep \""$0"\" /tmp/mon_db_lock.out2"}'|sh >/tmp/db_lock1
if [ `cat /tmp/db_lock1|wc -l` -gt 0 ] ; then
  cat /tmp/mon_db_lock.out2|grep -v SQL|grep [0-9]|awk '{print "grep \""$0"\" /tmp/mon_db_lock.out3"}'|sh >/tmp/db_lock2
  if [ `cat /tmp/db_lock2|wc -l` -gt 0 ] ; then
    cat /tmp/mon_db_lock.out3|grep -v SQL|grep [0-9]|awk '{print "grep \""$0"\" /tmp/mon_db_lock.out.old"}'|sh >/tmp/db_lock3
    if [ `cat /tmp/db_lock3|wc -l` -gt 0 ] ; then
    cat /tmp/db_lock3|awk '{print "wall  db lock-------\" "$0 "\"!!" }'|sh
    let warn_count=$warn_count+1
    fi
  fi
fi
cp /tmp/mon_db_lock.out3   /tmp/mon_db_lock.out.old
if [ $warn_count -gt 4 ] ; then
  beep.sh
  echo 0 > warn_count
fi



#mon_db_lock.sql


set linesize 256
col object_name  format a18
col object_id    format 99999999
col Locked_Mode  format a15
col SERIAL#      format 9999999
col session_id   format 999999
col oracle_username format a15
col os_user_name format a15
col process format 9999999

SELECT substr(b.object_name,1,1 object_name,a.object_id,
decode( a.locked_mode,
0, 'None', /* Mon Lock equivalent */
1, 'Null', /* N */
2, 'Row-S (SS)', /* L */
3, 'Row-X (SX)', /* R */
4, 'Share', /* S */
5, 'S/Row-X (SSX)', /* C */
6, 'Exclusive',
a.locked_mode) Locked_Mode, /* X */
session_id, SERIAL#,oracle_username, os_user_name, a.process
FROM v$LOCKED_OBJECT a, dba_OBJECTS b,v$session c
WHERE a.object_id = b.object_id and a.session_id=c.sid
/

mxin

[原创]16.监控oracle的表空间
# mon_ts_space.sh
cd  /home/oraprod
sqlplus "/as sysdba" <<EOF
set feed off;
set heading off;
spool /tmp/mon_ts_space.out;
@mon_ts_space.sql
exit
EOF
cat  /tmp/mon_ts_space.out|grep -v SQL|grep [0-9]|awk -f mon_ts_space.awk


# mon_ts_space.sql
select
   df.tablespace_name                          "Tablespace",
   (df.totalspace - fs.freespace)              "Used MB",
   fs.freespace                                "Free MB",
   df.totalspace                               "Total MB",
   round(100 * (fs.freespace / df.totalspace)) "Pct. Free"
from
   dba_tablespaces                               ts,
   (select tablespace_name,
        round(sum(bytes) / 1048576) TotalSpace
      from dba_data_files
      group by tablespace_name)                  df,
   (select tablespace_name,
        round(sum(bytes) / 1048576) FreeSpace
      from dba_free_space
      group by tablespace_name)                 fs
where
   ts.tablespace_name = fs.tablespace_name
and
   df.tablespace_name = fs.tablespace_name(+)
and
round(100 * (fs.freespace / df.totalspace)) <20
and df.tablespace_name not in ('APPS_UNDOTS1','TEMP');

[ 本帖最后由 mxin 于 2006-7-5 08:23 编辑 ]

sturm

sturm

sturm

),