yqsh log 20090829 - 20090901

      基本把人行返还的数据导入到ORACLE数据库里了，电脑崩溃蓝屏，错误代码0x0000008e，周日回北京，周一到公司检测，结果发现内存崩溃了，换了个内存条，周二晚上快11点了才返回yqsh，大客开了6个多小时。

 

 

      批量处理路径：

 

      192.168.200.116/dhcc_batch/db_batch/cc_batch/qyzx/bin/cpp_exe

 

 

 

--

 

#!/bin/sh
clear
MAIN_PATH_LOGS='/home/app/dhcc_batch/db_batch/cc_batch/qyzx/logs'
 MAIN_PATH_EXE='/home/app/dhcc_batch/main_batch'
#执行批量程序的目录
BIN='/home/app/dhcc_batch/db_batch/cc_batch/qyzx/bin'

#备份数据的位置
DUMP='/home/app/dhcc_batch/itpdata/creditcorp'

 
echo "                                                  "
echo "      --------------------------------------------"
echo "      *          企业征信系统批量开始            *"
echo "      --------------------------------------------"
echo "                                                  "

cd $BIN
#取当天日期
 
sqlplus -s itp/itp << ! | read TXDAY
set heading off
set tab off
set feedback off
set pagesize 0
set linesize 800
 select sys_date from com_sys_parm;

!
sleep 2

 echo "当前系统时间:"$TXDAY

 
#CCP第 一 步
 
 echo "                                                                            "
 echo "      ----------------------------------------------------------------------"
 echo "      批量前企业征信系统数据备份:文件名 CCPexpdat2."$TXDAY          
 echo "      ----------------------------------------------------------------------"
 sleep 2
 cd $DUMP
 rm -f ./exp_ccp2.log
 rm -f ./CCPexpdat2.$TXDAY.PLQ*
 sleep 2
 exp itp/itp file=./CCPexpdat2.$TXDAY.PLQ compress=y tables=CC_BANK_ACCEPT,CC_BANK_ACCEPT_RE,CC_BAOHAN_BO,CC_BAR_MONEY,CC_BATCH_ERROR,CC_BCTL,CC_BILL_DIS,CC_BILL_DIS_BAK,CC_BILL_DIS_RE,CC_BORROWER_INFO,CC_BS_INFO,CC_CASH_FLUX,CC_CASH_FLUX_INFO,CC_COLREGS,CC_CR_BARGAIN,CC_DBILL_EXPS,CC_DBILL_RETURN,CC_DICTIONARYS,CC_DUEBILL_INFO,CC_ELSE_GIN,CC_ENSURE_BAR,CC_ERRREGS,CC_EXT_CAPITAL,CC_FEEDBACKS,CC_FIELDREGS,CC_FINANCE_CON,CC_FIN_BO,CC_FIN_EXP,CC_FIN_MONEY,CC_FIN_PROTO,CC_FIN_RETURN,CC_GAIN_ASSIGN,CC_IMPAWN_BAR,CC_INC_INFO,CC_KEEP_MG,CC_KEYINFO,CC_LACK_INFO,CC_LAW_INFO,CC_LEGAL_FAMILY,CC_MAF_INFO,CC_MESSAGEINFOS,CC_OUT_CAPITAL,CC_PLEDGE_BAR,CC_RECORDREGS,CC_REG_CAPITAL,CC_REPORTFILES,CC_SERIALNO,CC_STATISTICS,CC_STOCK,CC_SUPER_MAN,CC_SYSLOG_INFO,CC_TABLEREGS,CC_TEMP,CC_TICK_BO,CC_TRUST_BO grants=y log=./exp_ccp2.log
 
 
 #modify by zl 20080219 判断CCP批量前备份成功否
 if [ "$?" -ne "0" ]
  then
   
   echo "                                                                            "
    echo "      ----------------------------------------------------------------------"
    echo "      批量前企业征信系统数据备份失败:文件名 CCPexpdat2."$TXDAY        
    echo "      ----------------------------------------------------------------------"
    exit 1
  else
   
    gzip CCPexpdat2.$TXDAY.PLQ
   echo "                                                                            "
    echo "      ----------------------------------------------------------------------"
    echo "      批量前企业征信系统数据备份成功:文件名 CCPexpdat2."$TXDAY       
    echo "      ----------------------------------------------------------------------"
 fi
 

#这里不设断点了 应该也不会出错
echo "                                                                            "
echo "      ----------------------------------------------------------------------"
echo "      批量前清处 企业征信流水表  cc_serialno                "
echo "      ----------------------------------------------------------------------"
sleep 2
#清处 企业征信流水表
 
sqlplus -s itp/itp << !
set heading off
set tab off
set feedback off
set pagesize 0
set linesize 800
delete cc_serialno;

!
sleep 2

#CCP第 二 步
 
 echo "      ------------------------          "
 echo "      往返企业征信系统抓取数据          "
 echo "      ------------------------          "
 cd $BIN
 sleep 2
 qyzx
 #modify by zl 20080219 判断CCP执行qyzx成功否
 if [ "$?" -ne "0" ]
  then
  
   #CCP执行qyzx失败
   echo" ----------------------------"
   echo" ---企业征信批量失败    -----"
   echo" ----------------------------"
    exit 1
  else
    sleep 2
    echo" --------------------------------"
    echo" *      企业征信批量成功        *"
    echo" --------------------------------" 
 fi
 

 
sleep 2

#CCP第 三 步  --不在这里执行，在Mis换日中执行
 
 # cd $BIN
  #echo "                                                                            "
  #echo "      ----------------------------------------------------------------------"
  #echo "      批量后企业征信系统换日                        "
  #echo "      ----------------------------------------------------------------------"
 # sleep 2
 #fx_huanri.sh
 

#CCP第 四 步
 
 echo "                                                                            "
 echo "      ----------------------------------------------------------------------"
 echo "      批量后企业征信系统数据备份:文件名 CCPexpdat3."$TXDAY          
 echo "      ----------------------------------------------------------------------"
 sleep 2
 cd $DUMP
 rm -f ./exp_ccp3.log
 rm -f ./CCPexpdat3.$TXDAY.PLH*
 sleep 2
 exp itp/itp file=./CCPexpdat3.$TXDAY.PLH tables=CC_BANK_ACCEPT,CC_BANK_ACCEPT_RE,CC_BAOHAN_BO,CC_BAR_MONEY,CC_BATCH_ERROR,CC_BCTL,CC_BILL_DIS,CC_BILL_DIS_BAK,CC_BILL_DIS_RE,CC_BORROWER_INFO,CC_BS_INFO,CC_CASH_FLUX,CC_CASH_FLUX_INFO,CC_COLREGS,CC_CR_BARGAIN,CC_DBILL_EXPS,CC_DBILL_RETURN,CC_DICTIONARYS,CC_DUEBILL_INFO,CC_ELSE_GIN,CC_ENSURE_BAR,CC_ERRREGS,CC_EXT_CAPITAL,CC_FEEDBACKS,CC_FIELDREGS,CC_FINANCE_CON,CC_FIN_BO,CC_FIN_EXP,CC_FIN_MONEY,CC_FIN_PROTO,CC_FIN_RETURN,CC_GAIN_ASSIGN,CC_IMPAWN_BAR,CC_INC_INFO,CC_KEEP_MG,CC_KEYINFO,CC_LACK_INFO,CC_LAW_INFO,CC_LEGAL_FAMILY,CC_MAF_INFO,CC_MESSAGEINFOS,CC_OUT_CAPITAL,CC_PLEDGE_BAR,CC_RECORDREGS,CC_REG_CAPITAL,CC_REPORTFILES,CC_SERIALNO,CC_STATISTICS,CC_STOCK,CC_SUPER_MAN,CC_SYSLOG_INFO,CC_TABLEREGS,CC_TEMP,CC_TICK_BO,CC_TRUST_BO compress=y grants=y log=./exp_ccp3.log
 #modify by zl 20080219 判断CCP批量后数据备份成功否
 if [ "$?" -ne "0" ]
  then
   echo"---------------------------------------------------------------------"
    echo"-------批量后企业征信系统数据备份失败:文件名 CCPexpdat3."$TXDAY
    echo"---------------------------------------------------------------------"
    exit 1
  else
   gzip CCPexpdat3.$TXDAY.PLH
    echo"---------------------------------------------------------------------"
    echo"-------批量后企业征信系统数据备份成功:文件名 CCPexpdat3."$TXDAY
    echo"---------------------------------------------------------------------"
 fi
 

sleep 2
#暂时不上报客户基本信息表
 
sqlplus -s itp/itp << !
set heading off
set tab off
set feedback off
set pagesize 0
set linesize 800
update cc_borrower_info SET rpt_type='0' where rpt_type!='0';
UPDATE cc_cr_bargain a SET a.NAME= ( SELECT b.ch_name FROM cc_borrower_info b WHERE a.credit_no=b.credit_no);
UPDATE cc_pledge_bar SET pledge_desc=REPLACE(pledge_desc ,'㎡' ,'平方米') WHERE pledge_desc LIKE '%㎡%';
!
cd $MAIN_PATH_EXE
 handle_batch_ment.sh CCP to FXMONEY A to A $TXDAY
sleep 2

#echo "                                   "
#echo "      -----------------------------"
#echo "      *    企业征信批量成功结束   *"
#echo "      -----------------------------"
#echo "--------------------------------------------"
#echo "************* 启动tomcat **************"
#echo "      --------------------------------------------"
#startup.sh

 

 

--