基于Oracle数据库升级方法的研究

Research of Database Upgrade Method Based on Oracle

目的:论述升级Oracle数据库中的思路和具体实施步骤。方法:使用Oracle数据库自带的工具EXP、IMP实现数据库的全库导入导出,完成数据库的完整升级。结果:实现了我院数据库由Oracle8i升级到Oracle10g,为我院后续PACS的实施和RAC技术的应用奠定基础。结论:由于每所医院实际应用环境的不同和复杂性,在升级Oracle数据库前一定要做好测试工作,针对不同的前端应用环境设置相应的参数,升级后服务器性能提升明显。

Objective To discuss the ideas and specific implementation steps of Oracle database upgrading. Mothods By using the EXP and IMP which are provided by the Oracle database, import and export of entire database are implemented and complete database upgrading. Results The database is upgraded form Oracle 8i to Oracle 10g, which is the foundation of our hospital follow-up implementation of PACS and RAC technology. Conclusion Because the environment of practical application is different and complex, the Oracle database must test before the upgrading; the appropriate parameters are set according to different front-end application environment, and then enhance server performance significantly.