oracle单机10201upgrateto10205升级笔记

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