oracle 10201 升级到10205
之前做过的一个升级,今天整理了整理文档,算是一种回忆吧!
因为oracle 10gr2是没办法直接升级到11gr2的,所以先来了这个升级,详细原因见下图:
1. 准备工作
1.1 临时增加shared pool和java pool的大小
确保参数shared_pool_size和java_pool_size至少为150M大小,保证catupgrd.sql(10g)升级脚本运行正常(9i版本中是catpatch.sql)
[oracle@ZHUANHU ~]$ sqlplus / as sysdba
SQL>startup
SQL>alter system set shared_pool_size='150M' scope=spfile;
SQL> alter system set java_pool_size='150M' scope=spfile;
SQL>shutdown immediate
1.2 备份oracle软件,备份数据库
[oracle@ZHUANHU ~]$ cp -r $ORACLE_HOME /bk/oracle_product_bak/
[oracle@ZHUANHU ~]$ tar -czvf /bk/oracle_db_bak/oracle_DB_backup.tar.gz /oradata
1.3 停掉监听,OEM,ISQLPLUS等
[oracle@ZHUANHU ~]$ lsnrctl stop
[oracle@ZHUANHU ~]$ emctl stop dbconsole
[oracle@ZHUANHU ~]$ isqlplusctl stop
1.4 上传补丁包
将p8202632_10205_LINUX.zip上传到/bk并解压:
[root@ZHUANHU ~]$ cd /bk
[root@ZHUANHU bk]$ unzip p8202632_10205_Linux-x86-64.zip
[root@ZHUANHU bk]# su - oracle
[oracle@ZHUANHU ~]$ ls /bk/Disk1/
install patch_note.htm response runInstaller stage
[oracle@ZHUANHU ~]$ export LANG