将oracle10.2.0.1 升级至10.2.0.4.docx

将oracle10.2.0.1 升级至10.2.0.4 一、单实例环境,全时长一个半钟多, 详细步骤如下:1.停止所有oracle相关进程：[oracle@linux~] $ lsnrctlLSNRCTL for Linux: Version 9.2.0.4.0 - Production on 15-JUN-2009 16:01:36Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.Welcome to LSNRCTL, type help for information.LSNRCTLstop――关闭监听LSNRCTL start――开起监听[oracle@linux~] sqlplus /nologSQL 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.shRunning Oracle10 root.sh script...The following environment variables are set as:ORACLE_OWNER= oracleORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1Enter 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]: yCopying dbhome to /usr/local/bin ...The file oraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: yCopying oraenv to /usr/local/bin ...The file coraenv already exists in /usr/local/bin. Overwrite it? (y/n) [n]: yCopying coraenv to /usr/local/bin ...Entries will be added to the /etc/oratab file as needed byDatabase Configuration Assistant when a database is createdFinished running generic part of root.sh script.Now product-specific root actions will be performed.返回安装界面如图：Ok,到此ORACLE补丁已经安装完成，先不要启动数据库，还需要升级数据库才行。重要：升级数据库，按说明文档，安装完成后手动升级数据库：1、以oracle用户登陆[oracle@jsslinux dbs]$ sqlplus /nologSQL connect /as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Tue Mar 9 15:14:18 2010Copyright (c) 1982, 2007, Oracle. All Rights Reserved.2、以升级模式启动数据库SQL startup upgradeORACLE 例程已经启动。数据库装载完毕。数据库已经打开