您现在的位置: 万盛学电脑网 >> 程序编程 >> 数据库 >> oracle教程 >> 正文

oracle单机10201upgrateto10205升级笔记

作者:佚名    责任编辑:admin    更新时间:2022-06-22

   oracle 单机10201 upgrate to 10205

  1.Shut down the database:

  For Oracle RAC:

  $ srvctl stop database -d db_name

  For Single Instance:

  SQL> CONNECT SYS AS SYSOPER

  Enter password: SYS_password

  SQL> SHUTDOWN

  2.

  emctl stop dbconsole

  lsnrctl stop

  isqlplusctl stop

  3.$ export DISPLAY=localhost:0.0

  ./runInstaller

  4.

  Start the database in the UPGRADE mode:

  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/utlu102i.sql

  Turn off the spooling of script results to the log file:

  SQL> SPOOL OFF

  5.

  Enter the following SQL*Plus commands:

  SQL> STARTUP UPGRADE

  SQL> SPOOL patch.log

  SQL> @?/rdbms/admin/catupgrd.sql

  SQL> SPOOL OFF

  6.

  Restart the database:

  SQL> SHUTDOWN IMMEDIATE

  SQL> STARTUP

  7.

  SQL> @?/rdbms/admin/utlrp.sql

  8.

  SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY

  9.