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

The main function of the program script is to send mail through the process package included with oracle to monitor the execution of ETL:

ORACLE_SID=orcl

ORACLE_BASE=/opt/oracle

ORACLE_HOME=/opt/oracle/product/10.2.0

Export ORACLE_SID ORACLE_BASE ORACLE_HOME

PWD_DIR=/home/oracle/shell

SQLPLUS=$ {ORACLE_HOME} / bin/sqlplus

CONFIG_INI=$ {PWD_DIR} / ini/config.ini

While read gameuser

Do

Echo ${gameuser}

Echo ${SQLPLUS}

Cd ${PWD_DIR}

${SQLPLUS} ${gameuser}

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.