本文主要是介绍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 升级笔记的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！
