shell循环读取oracle数据,shell 脚本读多个oracle_sid

shell 脚本读多个oracle_sid， 并连接数据库的脚本[@more@]#! /bin/ksh

set -x

export oratab_file=/var/opt/oracle/oratab

export ORACLE_HOME=/u01/app/oracle/product/11.1.0

export PATH=$ORACLE_HOME/bin:$PATH

export SHL_DIR=/u01/app/oracle/dba/ora_shells

awk -F: '/^[^#].*:.*:*/ {print $1}' ${oratab_file} |

while read sid_line

do

echo $ORACLE_SID

export ORACLE_SID=${sid_line}

sqlplus /nolog > ca.log << EOF

connect / as sysdba

insert into system.db_growth

(select owner,sum(bytes)/1024/1024,sysdate,'${ORACLE_SID}' from dba_segments group by owner);

exit

EOF

done

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14377/viewspace-1060301/，如需转载，请注明出处，否则将追究法律责任。