ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 记录:oracle10.2.0.1.0到10.2.0.4.0的过程(p6810189_10204_Linux-x86)

记录:oracle10.2.0.1.0到10.2.0.4.0的过程(p6810189_10204_Linux-x86)

原创 Linux操作系统 作者:denglt 时间:2011-12-08 16:47:36 0 删除 编辑
Red Hat Enterprise Linux Server release 5.5安装10g(10.2.0.1.0)后升级
 

[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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2010-11-04

  • 博文量
    118
  • 访问量
    763930