Linux 下Oracle 10.2.0.1升级到10.2.0.4

1、下载补丁安装包

ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip

2、以DBA身份登录现有DBMS

sqlplus /nolog

conn /as sysdba

3、关闭数据库

shutdown immediate;

4、关闭对外服务

lsnrctl stop

emctl stop dbconsole

isqlplusctl stop

5、安装

unzip p6810189_10204_Linux-x86.zip

cd Disk1

./runInstaller

6、如遇以下

Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2

Failed <<<<

vim /etc/redhat-release

改为

Red Hat Enterprise Linux Server release 4 (Tikanga)

7、安装完成后

sqlplus /nolog

connect /as sysdba

startup upgrade;

SPOOL patch.log

@?/rdbms/admin/catupgrd.sql 等好久......

SPOOL OFF

shutdown immediate

startup

@?/rdbms/admin/utlrp.sql 等好久......

shutdown immediate;

startup

8、查看最新版本

select * from v$version;

select comp_name,version from dba_registry;

SQL> quit

9、开启对外服务

emctl start dbconsole

isqlplusctl start

lsnrctl start

10、OK，如果想用浏览器访问，如下

http://ip:1158/em (访问OEM)

http://ip:5560/isqlplus (访问isqlplus)

http://ip:5560/isqlplus/dba (访问isqlplus dba)

主要参考：

http://www.aixchina.net/home/space.php?uid=12963&do=blog&id=25764

http://blog.sina.com.cn/s/blog_465a4a1e0100royk.html

收藏于 2011-07-09