11.2.0.4由11.2.0.1升级而来的。
11.2.0.4的ORACLE_HOME为/u01/app/oracle/product/11.2.0.4/db_1
12.1.0.2的ORACLE_HOME为/u01/app/oracle/product/12c/db_1
1. 不关闭DB和监听
2. 安装12.1.0.2软件,弹出netca窗口时选择cancel,这样就不会自动带出DBUA窗口了,见下面系列图
3. 关闭DB和监听
4. 修改oracle的.bash_profile文件中ORACLE_HOME的值,并source应用一下
5. 修改/ets/oratab将ORACLE_HOME的值
6. 拷贝原$ORACLE_HOME/network/admin/下的监听文件到新$ORACLE_HOME/network/admin/下面
7. 拷贝原$ORACLE_HOME/dbs/下文件到新$ORACLE_HOME/dbs/下
8. 升级INSTANCE(perl catctl.pl就是instance的升级脚本,执行完后会自动shutdown immediate,执行时间估计会超过30分钟,要保留足够的空间,因为之前升级脚本期间会产生大量的归档日志)
SQL>startup upgrade;
cd /u01/app/oracle/product/12c/db_1/rdbms/admin/
/u01/app/oracle/product/12c/db_1/perl/bin/perl catctl.pl -n 4 catupgrd.sql
9. 执行以下验证脚本(第三个脚本编译失效对象)
SQL>startup
SQL> select instance_name,status,version from v$instance;
SQL> @?/rdbms/admin/utlrp.sql
10.整个DB重新收集下统计信息
exec dbms_stats.gather_database_stats(estimate_percent=>null)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718512626iH9.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851273tC3s.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851290ip9s.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851304c4Cz.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851320J0Nb.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_147185133572Nt.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851352CAvJ.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851376dPqg.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851391DVLi.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851412SotH.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851430sRHZ.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851445ZINN.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851462z6z3.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851478dsdj.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851504AZzN.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_1471851528CoaF.jpg?x-oss-process=style/bb)
![](http://img.blog.itpub.net/blog/attachment/201608/22/30126024_14718515459bj3.jpg?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30126024/viewspace-2123800/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30126024/viewspace-2123800/