ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 升级到数据库到10.2.0.5.0版本

升级到数据库到10.2.0.5.0版本

原创 Linux操作系统 作者:yhj20041128001 时间:2013-03-18 08:56:28 0 删除 编辑
 
补丁:p8202632_10205_linux_x86-64.zip
 
1.export DISPLAY=localhost:0.0
2.xhost +
3../runInstaller
 
1.Start the database in the UPGRADE mode:
SQL> STARTUP UPGRADE
2.Set the system to spool results to a log file for later analysis:
SQL> SPOOL upgrade_info.log
3.Run the Pre-Upgrade Information Tool:
SQL> @/rdbms/admin/utlu102i.sql
4.Turn off the spooling of script. results to the log file:
SQL> SPOOL OFF
 

7.Enter the following SQL*Plus commands:
SQL> STARTUP UPGRADE
SQL> SPOOL patch.log
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SPOOL OFF
8.Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
This list provides the version and status of each SERVER component in the database.
9.If necessary, rerun the catupgrd.sql script. after correcting any problems.
10.Restart the database:
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
11.Run the utlrp.sql script. to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @?/rdbms/admin/utlrp.sql

12.Run the following command to check the status of all the components after the upgrade:
SQL>
col COMP_NAME for a35;
col VERSION for 99;
col STATUS for a10;
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
In the output of the preceding command, the status of all the components should be VALID for a successful upgrade.
13.If you are using the Oracle Recovery Manager catalog, enter the following command:
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG
 
杀死占用文件的进程
fuser -k /ummis/mmisprd/mmisprddb/bin/oracle

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23757700/viewspace-756365/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-09-17

  • 博文量
    163
  • 访问量
    356721