測試環境,oracle9i 快照重新整理失敗

在測試環境下,有一個快照重新整理JOB老是失敗,查不出原因.在作業系統下增加個任務治之.[@more@]

$ crontab -l
# 1 * * * * /u01/oracle/admin/gs12366/scripts/snapshot.sh
20 1 * * * /u01/oracle/admin/backupscripts/rman_sb_12366.sh
20 3 * * * /u01/oracle/admin/backupscripts/rman_wz_12366.sh
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /u01/oracle/admin/gs12366/scripts/mv_wsbs.sh
$
$
$ more mv_wsbs.sh
# 20080529 wsbs refresh mview sm_skskjdk_yhsbh
# add by

ORACLE_BASE=/u01/oracle;export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/9.2.0; export ORACLE_HOME
ORACLE_SID=gs12366; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH; export PATH
mydate=`date +'%Y%m%d'`
sqlplus wsbs/******* @/u01/oracle/admin/gs12366/scripts/mv_wsbs.sql >/u01/oracle/admin/gs12366/scripts/wsbs_log$mydate.txt

$ more mv_wsbs.sql
select to_char(sysdate,'yyyy-mm-dd:hh:mi:ss') from dual;
EXEC DBMS_SNAPSHOT.REFRESH('SM_SKSKJDK_YHSBH');
select to_char(sysdate,'yyyy-mm-dd:hh:mi:ss') from dual;
exit;
$

-- 檢查執行結果
select last_refresh_type,last_refresh_date from user_mviews where mview_name='SM_SKSKJDK_YHSBH'
more /u01/oracle/admin/gs12366/scripts/wsbs_log*.txt

-- 檢查預設環境變數
$ env |grep ORA
ORACLE_BASE=/u01/oracle
ORA_DB=/u01/oracle/product/9.2.0/dbs
ORACLE_SID=gs12366
ORACLE_TERM=vt100
ORA_NLS33=/u01/oracle/product/9.2.0/ocommon/nls/admin/data
ORACLE_HOME=/u01/oracle/product/9.2.0
$