Shulou(Shulou.com)06/01 Report--

Export ORACLE_BASE=/opt/oracle

Export ORACLE_HOME=/opt/oracle/product/11gR1/db

Export ORACLE_SID=ORA

LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$ORACLE_HOME/rdbms/lib

Export LD_LIBRARY_PATH

SHLIB_PATH=$ORACLE_HOME/lib32:$ORACLE_HOME/rdbms/lib32

Export SHLIB_PATH

# Set shell search paths:

Export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH:/usr/local/bin

# CLASSPATH must include the following JRE locations:

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

Export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

Export DBCA_RAW_CONFIG=/opt/oracle/rawdevpath

Export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

Export LANG=C

Export LC_CTYPE=C

Day= `date-d "1 days ago"'+% Y% m% d``

Month= `date-d "1 days ago"'+% Y% m'`

Para1= `ps-ef | grep oracle | grep pmon | grep-v grep | awk'{print $8}'`; if [!-n "$para1"]; then exit; fi

# sqlplus-s / as sysdba / home/oracle/shell/daily/dailyswitch/dailyswitch_$ {Day}

Cat / home/oracle/shell/daily/tmp_dailyswitch.lst | grep. > > / home/oracle/shell/daily/dailyswitch/dailyswitch_$ {Day}

Echo

"DTIME,PORTID,ROUTERID,INTERBANDWIDTH,INBYTES,INSINGLEPKG,INLOSTPKG,INERRPKG,OUTBYTES,OUTSINGLEPKG,OUTLOSTPKG,OUTERRPKG,INB

ROADCASTPKG,OUTBROADCASTPKG,UNKNOWNPORTLOSTPKG "> / home/oracle/shell/daily/dailyroute/dailyroute_$ {Day}

Cat / home/oracle/shell/daily/tmp_dailyroute.lst | grep. > > / home/oracle/shell/daily/dailyroute/dailyroute_$ {Day}

Exit 0

Open the excel table by selecting a comma as the delimiter.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.