将oracle10.2.0.1升级至10.2.0.4讲述.docx

将oracle10.2.0.1 升级至10.2.0.4 一、单实例环境,全时长一个半钟多, 详细步骤如下: 1.停止所有oracle相关进程： [oracle@linux~] $ lsnrctl LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 15-JUN-2009 16:01:36 Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved. Welcome to LSNRCTL, type help for information. LSNRCTLstop ――关闭监听 LSNRCTL start ――开起监听 [oracle@linux~] sqlplus /nolog SQL connect /as sysdba ----- 需要用此用户关闭 Connected. sql shutdown immediate; －－关闭数据库 shutdown abort; －－强制关数据库 2、网络搜索下载p6810189_10204_Linux-x86补丁包上传到oracle服务器 ，解压、安装 [oracle@ linux~]$ unzip p6810189_10204_Linux-x86.zip //解压后生成Disk1 目录 [oracle@linux~] cd Disk1 [oracle@linux~] export LC_CTYPE=C.iso88591 (语言转换不然运行./runInstaller会乱码） －－进入图型界面安装ORACLE补丁程序 [oracle@linux Disk1~]$ ./runInstaller ――安装ORACLE补丁 －－按照提示升级 指定原来ORACE的安装路径安装 打开一个操作终端窗口： [oracle@linux ~] su root 密码：****** 执行提示的脚本，本例中：[root@linux ~]# [root@linux ~]# /home/app/oracle/product/10.2.0/db_1/root.sh Running Oracle10 root.sh script... The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1 Enter the full pathname of the local bin directory: [/usr/local/bin]: The file dbhome already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying dbhome to /usr/local/bin ... The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying oraenv to /usr/local/bin ... The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: y Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root.sh script. Now product-specific root actions will be performed. 返回安装界面如图： Ok,到此ORACLE补丁已经安装完成，先不要启动数据库，还需要升级数据库才行。 重要：升级数据库，按说明文档，安装完成后 手动升级数据库： 1、以oracle用户登陆 [oracle@jsslinux dbs]$ sqlplus /nolog SQL connect /as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 9 15:14:18 2010 Copyright (c) 1982, 2007, Oracle. All Rights