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
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博客 ” ，链接：https://blog.itpub.net/14377/viewspace-1060301/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
