手机
当前位置:查字典教程网 >编程开发 >Oracle教程 >oracle单机10201upgrateto10205升级笔记
oracle单机10201upgrateto10205升级笔记
摘要:oracle单机10201upgrateto102051.Shutdownthedatabase:ForOracleRAC:$srvctls...

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单机10201upgrateto10205升级笔记】相关文章:

oracle 触发器 学习笔记

oracle细粒度审计使用

oracle 函数

oracle开发技术:溢出错误解决方法

oracle联机数据库备份详解

Oracle parameter可能值获取方法

Oracle学习笔记(五)

Oracle学习笔记(六)

Oracle触发器简单实现

Oracle date如何比较大小分析

精品推荐
分类导航