11.2.0.1直接安装的
原ORACLE_HOME:/u01/app/oracle/product/11.2.0.1/db_1
新ORACLE_HOME: /u01/app/oracle/product/11.2.0.4/db_1
1. 下载11.2.0.4 的Patchset文件,只需要其中的第1、2两个就可以。
2. 备份DB,rman备份DB就够了,哪些安装目录不需要,因为不会丢失
3. 不关闭DB和监听
4. 安装patchset包,出现NETCA窗口不要关闭,会自动出现DBUA的窗口(此窗口执行时间非常长,期间产生较多归档日志)
期间不会出现选择字符集、内存等选项,因为我们相当于仅仅安装一个新版本的oracle软件而已,字符集内存等选项是在创建DB的过程中才会有的,也就是我们选择安装并创建DB才会有字符集内存的选项
5. 修改oracle的.bash_profile文件中ORACLE_HOME的值,并source应用一下
6. 修改/ets/oratab将ORACLE_HOME的值
7. Sqlplus / as sysdb就可以看到DB正常升级到11.20.0.4了,lsnrctl status发现Listener Parameter File还是来自原来的文件,重启监听就可以了
8. 整个DB重新收集下统计信息
exec dbms_stats.gather_database_stats(estimate_percent=>null)![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849243NLN6.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718492683Pxo.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849294HB0h.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849318JlpR.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849338UCRn.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718493575878.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849378UcCI.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718494007TfX.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_147184941736Fi.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718494418pfD.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849458rC5t.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718494775Vlp.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718494940001.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849514mh4Z.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718495389G3l.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849555oevV.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849577H2PH.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_147184960544H3.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718496247HKK.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718496428o88.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849661Zqcx.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718496810B34.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849698Yn72.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849715X9nS.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718497309AfI.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471849748nbIj.jpg?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30126024/viewspace-2123797/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30126024/viewspace-2123797/