[root@orcl]# unzip p6810189_10204_Linux-x86.zip
[root@orcl Disk1]# su - oracle
--关闭数据库,监听
[oracle@orcl Disk1]$ export DISPLAY=192.168.126.1:0.0
[oracle@orcl Disk1]$ ./runInstaller
根据图形界面提示一步步操作。。。
完成后:
[oracle@orcl Disk1]$ opatch lsinventory
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2011-12-08_16-03-24PM.log
Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2011-12-08_16-03-24PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
启动数据库:
[oracle@orcl Disk1]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Dec 8 16:04:25 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 243269632 bytes
Fixed Size 1266824 bytes
Variable Size 104860536 bytes
Database Buffers 134217728 bytes
Redo Buffers 2924544 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
查看Readme.html: 9.3.2 Manually Upgrading a Release 10.2 Database
执行如下脚本:
9.3.2.1 Run the Pre-Upgrade Information Tool
1) 1.Start the database in the UPGRADE mode:
SQL> STARTUP UPGRADE
2.Set the system to spool results to a log file for later analysis:
SQL> SPOOL upgrade_info.log
3.Run the Pre-Upgrade Information Tool:
SQL> @?/rdbms/admin/utlu102i.sql
4.Turn off the spooling of script. results to the log file:
SQL> SPOOL OFF
9.3.2.2 Upgrading a Release 10.2 Database
1. SQL> STARTUP UPGRADE
2. SQL> SPOOL patch.log
3. SQL> @?/rdbms/admin/catupgrd.sql
4. SQL> SPOOL OFF
正确无误后,重新启动数据库执行如下脚本
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP
SQL> @?/rdbms/admin/utlrp.sql
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/195110/viewspace-713010/ ,如需转载,请注明出处,否则将追究法律责任。