oracle 单机10201 upgrate to 10205 升级笔记



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.

oracle 单机10201 upgrate to 10205 升级笔记,古老的榕树,5-wow.com

郑重声明:本站内容如果来自互联网及其他传播媒体,其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享,并不代表本站赞同其观点和对其真实性负责,也不构成任何其他建议。