本帖最后由 paulyi 于 2014-2-9 14:06 编辑

oracle 11g 11.1.0.6.0数据库升级到11g 11.1.0.7.0 for aix 5L操作步骤

1.运行收集信息工具,里面会记录相关信息,比如用到的系统表空间是否足够

[list=1]

[*]Start the database, either in normal mode or in upgrade mode:
SQL> STARTUPor
SQL> STARTUP UPGRADE
[*]Set the system to spool results to a log file for later analysis:
SQL> SPOOL upgrade_info.log
[*]Run the Pre-Upgrade Information Tool:
SQL> @?/rdbms/admin/utlu111i.sql
[*]Turn off the spooling of script. results to the log file:
SQL> SPOOL OFF
输出的信息如下:
Oracle Database 11.1 Pre-Upgrade Information Tool 06-15-2007 09:14:02.
**********************************************************************
......

2.运行升级软件
关闭数据库和监听,如果还有asm,dbconsole都要关闭
运行清理内存,释放相关进程命令
/usr/sbin/slibclean
xhost +
su - ora11g
export Display=ip地址:0.0
cd /soft/11gpatch/Disk1
./runInstaller

3.升级数据库
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF

4.编译失效对象
SQL> @?/rdbms/admin/utlrp.sql

5.检查是否升级成功用以下脚本
SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;