首页 >数据库 >mysql教程 >oracle单机10201upgrateto10205升级笔记

oracle单机10201upgrateto10205升级笔记

WBOY
WBOY原创
2016-06-07 14:54:091131浏览

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

  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

声明:
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn