基于64位Windows 2003和Oracle 10g RAC的“军卫一号”数据库的升级

Database Upgrade of No.1 Military Medical Project Based on Windows 2003 and Oracle 10g RAC(64bit)

目的:完成"军卫一号"数据库平台升级,解决服务器负载过重及数据库并发连接数过多导致数据库无法连接的难题。方法:操作系统升级为Windows 2003(64位),Oracle数据库从8.17升级为10g(64位),并建立RAC,通过多进程、分用户的导出/导入模式完成数据迁移。结果:实现了"军卫一号"数据库的高性能和高可用性。结论:基于64位Windows平台、将数据库从Oracle 8.17升级为64位10g RAC是一个投入少、效益高的好办法。

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.