首頁 >資料庫 >mysql教程 >oracle单机10201upgrateto10205升级笔记

oracle单机10201upgrateto10205升级笔记

WBOY
WBOY原創
2016-06-07 14:54:091130瀏覽

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