手机
当前位置:查字典教程网 >编程开发 >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 date如何比较大小分析

oracle如何恢复被覆盖的存储过程

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

在Oracle 10g中如何获得索引建议

Oracle动态交叉表生成

Oracle触发器简单实现

oracle 删除重复数据

关于oracle外键引用与goldengate

Oracle学习笔记(五)

Oracle学习笔记(六)

精品推荐
分类导航