在Metalink上下载Oracle的补丁集,通常需要知道补丁号码。
有朋友整理了补丁号列表,这个很有点用处,收录一下备忘:
9.2.0.4 = 3095277
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809(9i最终)
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
10.2.0.3 = 5337014
10.2.0.4 =
Oracle提供一个站点可以用于通过ftp下载Oracle的所有Patch,这个站点是updates.oracle.com。
我们可以在命令行登录,当然需要一个Metalink帐号认证:
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>ftp updates.oracle.com
Connected to bigip-updates-test-adc.oracle.com.
220 FTP server ready.
User (bigip-updates-test-adc.oracle.comnone)): greatfinish@hotmail.com
331 Username OK, please send password.
Password:
230-
230- Welcome to the Oracle Patch Download FTP Server
230-
230- For detailed help, use command "quote site help".
230
ftp> ls
200 PORT command OK.
150 Opening data connection for file listing.
226-Listing complete. Data connection has been closed.
226-It is the policy of this server to deny all
226-requests to list from the root directory.
226-Only directories with names which match
226 bug numbers exist and there are too many to be listed.
ftp> cd 4547809
250 Changed directory OK.
ftp> ls
200 PORT command OK.
150 Opening data connection for file listing.
p4547809_92080_AIX64-5L.zip
p4547809_92080_AXP.zip
p4547809_92080_HP64.zip
p4547809_92080_HPUX-IA64.zip
p4547809_92080_LINUX.zip
p4547809_92080_Linux-IA64.zip
p4547809_92080_Linux-x86-64.zip
p4547809_92080_MVS.zip
p4547809_92080_SOLARIS.zip
p4547809_92080_SOLARIS64.zip
p4547809_92080_TRU64.zip
p4547809_92080_WINNT.zip
p4547809_92080_WINNT64.zip
226 Listing complete. Data connection has been closed.
ftp: 收到 360 字节,用时 6.89Seconds 0.05Kbytes/sec.
ftp> binary
200 TYPE changed to I.
ftp> get p4547809_92080_WINNT.zip
200 PORT command OK.
150 Opening BINARY mode data connection for file p4547809_92080_WINNT.zip.
426-File retrieval error: Broken pipe
426 Data connection has been closed.
ftp: 收到 7106760 字节,用时 1696.09Seconds 4.19Kbytes/sec.
ftp> bye
上周在大庆客户现场,帮助用户将3个数据库从Oracle 9.0.1.0升级到Oracle 9.2.0.8,现在已经很少有人在使用Oracle 9.0版本的数据库了。
而9.2.0.8是Oracle 9i的最后一个修正补丁,使用9i的用户可以开始考虑评估将9i迁移到Oracle10g了。
为了方便,将9.2.0.8 及常用的 10.2.0.4 的补丁下载地址列举在这里,如果没有Metalink帐号,你可以通过迅雷来尝试下载这些Patch.
Oracle 9.2.0.8 及 10.2.0.4 Patch地址
oracle 9208 patch:
ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_AXP.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX-S390.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_TRU64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip
oracle 10.2.0.4 patch:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip
-The End-