| 基于64位Windows 2003和Oracle 10g RAC的“军卫一号”数据库的升级 |
| |
| 引用本文： | 程跃斌,林亚忠.基于64位Windows 2003和Oracle 10g RAC的“军卫一号”数据库的升级[J].医疗卫生装备,2010,31(10):68-70. |
| |
| 作者姓名： | 程跃斌 林亚忠 |
| |
| 作者单位： | 解放军175医院,厦门大学附属东南医院信息科,福建漳州,363000 |
| |
| 摘 要： | 目的：完成＂军卫一号＂数据库平台升级,解决服务器负载过重及数据库并发连接数过多导致数据库无法连接的难题。方法：操作系统升级为Windows 2003（64位）,Oracle数据库从8.17升级为10g（64位）,并建立RAC,通过多进程、分用户的导出/导入模式完成数据迁移。结果：实现了＂军卫一号＂数据库的高性能和高可用性。结论：基于64位Windows平台、将数据库从Oracle 8.17升级为64位10g RAC是一个投入少、效益高的好办法。
|
| 关 键 词： | Oracle RAC 军卫一号 升级 |
Database Upgrade of No.1 Military Medical Project Based on Windows 2003 and Oracle 10g RAC(64bit) |
| |
| CHENG Yue-bin,LIN Ya-zhong.Database Upgrade of No.1 Military Medical Project Based on Windows 2003 and Oracle 10g RAC(64bit)[J].Chinese Medical Equipment Journal,2010,31(10):68-70. |
| |
| Authors: | CHENG Yue-bin LIN Ya-zhong |
| |
| Institution: | (The 175th Hospital of PLA,the Affiliated Southeast Hospital of Xiamen University,Zhangzhou 363000,Fujian Province,China) |
| |
| Abstract: | Objective To complete database platform upgrade of No.1 Military Medical Project,which can improve the server performance and settle database connection failures caused by too many connections.Methods The operation system was upgraded to Windows 2003（64bit） and Oracle database from 8.17 to 10g RAC（64bit） with RAC being established and data transferred by export/import method according to users with multiprocessing.Results Improved database performance and availability of No.1 Military Medical Project was achieved.Conclusion Upgrading No.1 Military Medical Project database from Oracle 8.17 to 10g RAC（64bit） based on windows platform（64bit） is a proper method of producing high benefit with small investment. |
| |
| Keywords: | Oracle RAC |
| 本文献已被 维普 万方数据 等数据库收录！ |
