4數(shù)據(jù)庫部署說明書（方式二）

1、鐵路局運(yùn)輸信息集成平臺（1.0）及集中式現(xiàn)在車系統(tǒng)培訓(xùn)資料鐵路局運(yùn)輸信息集成平臺（1.0）及集中式現(xiàn)在車系統(tǒng)數(shù)據(jù)庫部署說明書（方式二）目 錄 TOC o 1-3 h z u HYPERLINK l _Toc357905256 1文檔介紹 PAGEREF _Toc357905256 h 1 HYPERLINK l _Toc357905257 1.1目的 PAGEREF _Toc357905257 h 1 HYPERLINK l _Toc357905258 1.2范圍 PAGEREF _Toc357905258 h 1 HYPERLINK l _Toc357905259 1.3讀者對象 PAGER

2、EF _Toc357905259 h 1 HYPERLINK l _Toc357905260 1.4參考文檔 PAGEREF _Toc357905260 h 1 HYPERLINK l _Toc357905261 1.5術(shù)語與縮寫解釋 PAGEREF _Toc357905261 h 1 HYPERLINK l _Toc357905262 2檢查修改網(wǎng)路配置文件 PAGEREF _Toc357905262 h 1 HYPERLINK l _Toc357905263 3創(chuàng)建貨票視圖 PAGEREF _Toc357905263 h 2 HYPERLINK l _Toc357905264 4創(chuàng)建用戶，

3、給用戶授權(quán) PAGEREF _Toc357905264 h 3 HYPERLINK l _Toc357905265 5導(dǎo)入數(shù)據(jù)庫 PAGEREF _Toc357905265 h 3 HYPERLINK l _Toc357905266 5.1導(dǎo)入數(shù)據(jù)庫結(jié)構(gòu) PAGEREF _Toc357905266 h 3 HYPERLINK l _Toc357905267 5.2導(dǎo)入字典數(shù)據(jù) PAGEREF _Toc357905267 h 3 HYPERLINK l _Toc357905268 5.3導(dǎo)入其他數(shù)據(jù) PAGEREF _Toc357905268 h 3 HYPERLINK l _Toc357905

4、269 5.4修改DG_JM表 PAGEREF _Toc357905269 h 3 HYPERLINK l _Toc357905270 6初始化數(shù)據(jù)庫 PAGEREF _Toc357905270 h 3 HYPERLINK l _Toc357905271 7修正數(shù)據(jù)庫 PAGEREF _Toc357905271 h 3 HYPERLINK l _Toc357905272 8安裝啟動數(shù)據(jù)庫任務(wù) PAGEREF _Toc357905272 h 3 HYPERLINK l _Toc357905273 8.1定期清理業(yè)務(wù)數(shù)據(jù) PAGEREF _Toc357905273 h 3 HYPERLINK l

5、_Toc357905274 8.2定期清理作業(yè)數(shù)據(jù) PAGEREF _Toc357905274 h 4 HYPERLINK l _Toc357905275 8.3定期清理歷史數(shù)據(jù) PAGEREF _Toc357905275 h 4 HYPERLINK l _Toc357905276 8.4分界口交換列車數(shù)據(jù) PAGEREF _Toc357905276 h 4 HYPERLINK l _Toc357905277 8.5ATIS記錄車輛基本數(shù)據(jù) PAGEREF _Toc357905277 h 4 HYPERLINK l _Toc357905278 8.6列車運(yùn)行線實時服務(wù) PAGEREF _Toc

6、357905278 h 4 PAGE 4文檔介紹目的該文檔是對鐵路局運(yùn)輸信息集成平臺及集中式現(xiàn)在車系統(tǒng)數(shù)據(jù)庫部署過程的基本描述，對系統(tǒng)實施過程中的主要工作內(nèi)容和標(biāo)準(zhǔn)進(jìn)行描述，是系統(tǒng)實施、測試、驗收和維護(hù)的重要依據(jù)。范圍描述前期需要準(zhǔn)備的基礎(chǔ)資料；定義系統(tǒng)實施所需文檔；描述實施過程及標(biāo)準(zhǔn)； 讀者對象本文檔預(yù)期的讀者有：系統(tǒng)實施人員、測試人員、維護(hù)人員和后期開發(fā)人員等。參考文檔數(shù)據(jù)結(jié)構(gòu)及存儲過程說明書數(shù)據(jù)庫部署說明書術(shù)語與縮寫解釋縮寫、術(shù)語解 釋檢查修改網(wǎng)路配置文件Set命令檢查數(shù)據(jù)庫環(huán)境。配置數(shù)據(jù)庫配置文件： /oracle/app/oracle/11.2/network/admin/tnsna

7、mes.ora（修改內(nèi)容：對應(yīng)應(yīng)用系統(tǒng)的HOST與SERVICE_NAME的值，連接串名稱不變）#貨調(diào)系統(tǒng)HD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*)(PORT = 1521) ) (CONNECT_DATA = (SERVICE_NAME = lj*) )#TD結(jié)合系統(tǒng)TD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(

8、HOST = 10.*.*.*)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*)(PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =td*) )#路局確報、車號識別、貨票系統(tǒng)ATIS = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*

9、)(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =atis*) )#貨運(yùn)計劃系統(tǒng)HYJH = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*)(PORT = 1521) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.*.*.*)(PORT = 1521) ) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = hy*) )創(chuàng)

10、建貨票視圖修改hpapp.sql文件內(nèi)相應(yīng)的局碼。以hpapp用戶登錄貨票數(shù)據(jù)庫，執(zhí)行創(chuàng)建視圖sql文件：hpapp.sql創(chuàng)建用戶，給用戶授權(quán)以system用戶登錄，編輯并執(zhí)行user.Sql文件，創(chuàng)建XC、LJXC、TJ、XCJUMP用戶。執(zhí)行用戶授權(quán)sql文件：grant.sql導(dǎo)入數(shù)據(jù)庫導(dǎo)入數(shù)據(jù)庫結(jié)構(gòu)Imp xc/xc file = structure full=y導(dǎo)入字典數(shù)據(jù)Imp xc/xc file = dictionary tables=* compress=n ignore=y commit=y導(dǎo)入其他數(shù)據(jù)Imp xc/xc file = xc tables=* compre

11、ss=n ignore=y commit=yImp xc/xc file = dic_def tables=* compress=n ignore=y commit=yImp xcjump/xcjump file = xcjump tables=* compress=n ignore=y commit=yImp tj/tj file = tjstructure tables=* compress=n ignore=y commit=yImp tj/tj file = tjdictionary tables=* compress=n ignore=y commit=y修改DG_JM表將本局行的字段YL1的值置L初始化數(shù)據(jù)庫登錄XC用戶執(zhí)行用戶字典sql文件：xc_s_init_data.sql執(zhí)行atis.sql文件添加分界口AEI設(shè)備：atis.sql修正數(shù)據(jù)庫 修正數(shù)據(jù)庫鏈路，編譯視圖、同義詞、函數(shù)、存儲過程、包（有錯誤的部分）安裝啟動數(shù)據(jù)庫任務(wù)定期清理業(yè)務(wù)數(shù)據(jù)if to_char(sysdate,hh24mi) between 0900 and 1700 then apppkg.cr_bs_data; end if;定期清理作業(yè)數(shù)據(jù)if to_char(sysdate,hh24mi) between 0900 and 1700 then cr_job_data_t; end