当前位置:Gxlcms > mysql > oracle单机10201upgrateto10205升级笔记

oracle单机10201upgrateto10205升级笔记

时间:2021-07-01 10:21:17 帮助过:35人阅读

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

人气教程排行