安装10.2.0.1后需要安装patch:

1) 首先得打上patch set 10.2.0.4, 这个少说也解决了上千个bug吧; 参见metalink 401436.1(24-MAR-2009) 10.2.0.4 Patch Set - List of Bug Fixes by Problem Type.

2) 另外10.2.0.4版本已经也出现了很多bug了, 得把Oracle推荐的临时patch也打上, 少说也有上百个了; 参见metalink 756671.1(28-APR-2009) Oracle Recommended Patches -- Oracle Database, 里头包含generic, dataguard, CRS, RAC等方方面面的补丁bundle.

3) 最后还要把oracle每个季度发布的安全补丁集CPU也打上, 参见metalink 786800.1(14-APR-2009) Critical Patch Update April 2009 Patch Availability Document for Oracle Products.

4) 如果还要使用Streams复制, 还得打上oracle推荐的Streams相关Patch, 截止到2009-04-10, 在Oracle Database 10.2.0.4上已经发布了9个Streams相关的补丁, 强烈建议都安装上. 参见metalink 437838.1 Streams Specific Patches.

以上2,3,4中的推荐patch每隔一段时间都会更新, 所以安装前还得去metalink上看看是否有更新了.

打完这些patches后才开始建库, 应该就比较放心了, 参见如下在RHEL4.5平台里打的patch列表, 比较惊人啊!

$ $ORACLE_HOME/OPatch/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/opatch2009-06-18_15-57-24PM.log

Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2009-06-18_15-57-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.


Interim patches (66) :

Patch 8221870      : applied on Tue Jun 16 17:23:54 CST 2009
   Created on 12 Apr 2009, 23:33:54 hrs PST8PDT
   Bugs fixed:
     8221870

Patch 5933656      : applied on Tue Jun 16 17:23:09 CST 2009
   Created on 2 Oct 2008, 18:58:05 hrs PST8PDT
   Bugs fixed:
     5933656

Patch 6640411      : applied on Tue Jun 16 17:22:42 CST 2009
   Created on 5 Jan 2009, 08:10:50 hrs PST8PDT
   Bugs fixed:
     6640411

Patch 6827260      : applied on Tue Jun 16 17:22:16 CST 2009
   Created on 5 Jan 2009, 07:14:05 hrs PST8PDT
   Bugs fixed:
     6827260

Patch 6838714      : applied on Tue Jun 16 17:21:50 CST 2009
   Created on 6 Jan 2009, 21:24:52 hrs PST8PDT
   Bugs fixed:
     6838714

Patch 7219752      : applied on Tue Jun 16 17:21:08 CST 2009
   Created on 5 Jan 2009, 21:36:46 hrs PST8PDT
   Bugs fixed:
     7219752

Patch 7033630      : applied on Tue Jun 16 17:20:26 CST 2009
   Created on 11 Jun 2008, 23:37:09 hrs PST8PDT
   Bugs fixed:
     7033630

Patch 7599054      : applied on Tue Jun 16 17:19:56 CST 2009
   Created on 24 Feb 2009, 21:07:01 hrs PST8PDT
   Bugs fixed:
     7263055, 6600051, 7207654, 4966512, 7377526, 7599054, 7480651, 6134664
     6915767, 6200820

Patch 8309642      : applied on Tue Jun 16 16:25:28 CST 2009
   Created on 10 Mar 2009, 12:11:20 hrs PST8PDT
   Bugs fixed:
     8309642

Patch 8309639      : applied on Tue Jun 16 16:25:24 CST 2009
   Created on 9 Mar 2009, 12:18:10 hrs PST8PDT
   Bugs fixed:
     8309639

Patch 8309637      : applied on Tue Jun 16 16:25:21 CST 2009
   Created on 4 Mar 2009, 22:47:17 hrs PST8PDT
   Bugs fixed:
     8309637

Patch 8309632      : applied on Tue Jun 16 16:25:17 CST 2009
   Created on 4 Mar 2009, 22:47:12 hrs PST8PDT
   Bugs fixed:
     8309632

Patch 8309592      : applied on Tue Jun 16 16:25:09 CST 2009
   Created on 4 Mar 2009, 22:46:59 hrs PST8PDT
   Bugs fixed:
     8309592

Patch 8309587      : applied on Tue Jun 16 16:25:04 CST 2009
   Created on 4 Mar 2009, 22:46:51 hrs PST8PDT
   Bugs fixed:
     8309587

Patch 8290506      : applied on Tue Jun 16 16:24:59 CST 2009
   Created on 17 Mar 2009, 17:48:36 hrs PST8PDT
   Bugs fixed:
     8290506, 7375644, 7150470, 7592346

Patch 7609058      : applied on Tue Jun 16 16:24:54 CST 2009
   Created on 7 Dec 2008, 22:38:07 hrs PST8PDT
   Bugs fixed:
     7609058

Patch 7609057      : applied on Tue Jun 16 16:24:50 CST 2009
   Created on 7 Dec 2008, 22:40:46 hrs PST8PDT
   Bugs fixed:
     7609057

Patch 7375617      : applied on Tue Jun 16 16:24:46 CST 2009
   Created on 16 Sep 2008, 00:51:28 hrs PST8PDT
   Bugs fixed:
     7375617

Patch 7375613      : applied on Tue Jun 16 16:24:42 CST 2009
   Created on 16 Sep 2008, 00:51:25 hrs PST8PDT
   Bugs fixed:
     7375613

Patch 7375611      : applied on Tue Jun 16 16:24:38 CST 2009
   Created on 16 Sep 2008, 00:51:22 hrs PST8PDT
   Bugs fixed:
     7375611

Patch 7197583      : applied on Tue Jun 16 16:24:34 CST 2009
   Created on 20 Jun 2008, 07:14:55 hrs PST8PDT
   Bugs fixed:
     7197583

Patch 7155254      : applied on Tue Jun 16 16:24:27 CST 2009
   Created on 9 Jun 2008, 03:09:21 hrs PST8PDT
   Bugs fixed:
     7155254

Patch 7155253      : applied on Tue Jun 16 16:23:26 CST 2009
   Created on 9 Jun 2008, 03:07:12 hrs PST8PDT
   Bugs fixed:
     7155253

Patch 7155252      : applied on Tue Jun 16 16:22:37 CST 2009
   Created on 20 Jun 2008, 07:25:15 hrs PST8PDT
   Bugs fixed:
     7155252

Patch 7155251      : applied on Tue Jun 16 16:22:32 CST 2009
   Created on 20 Jun 2008, 07:24:32 hrs PST8PDT
   Bugs fixed:
     7155251

Patch 7155250      : applied on Tue Jun 16 16:22:26 CST 2009
   Created on 20 Jun 2008, 07:23:48 hrs PST8PDT
   Bugs fixed:
     7155250

Patch 7155249      : applied on Tue Jun 16 16:22:21 CST 2009
   Created on 20 Jun 2008, 07:19:39 hrs PST8PDT
   Bugs fixed:
     7155249

Patch 7155248      : applied on Tue Jun 16 16:22:17 CST 2009
   Created on 20 Jun 2008, 07:18:50 hrs PST8PDT
   Bugs fixed:
     7155248

Patch 8227106      : applied on Tue Jun 16 16:21:06 CST 2009
   Created on 18 Mar 2009, 00:47:33 hrs PST8PDT
   Bugs fixed:
     8251247, 7238230, 8331466, 6724797, 6802650, 7600026, 6817593, 6833965
     6403091, 6960489, 6610218, 6681695, 7457766, 7599944, 8324577, 7136866
     6343150, 7173005, 6804746, 8268054, 8227106

Patch 8227091      : applied on Tue Jun 16 16:20:52 CST 2009
   Created on 10 Feb 2009, 04:31:47 hrs PST8PDT
   Bugs fixed:
     7396409, 7298688, 8227091, 6952701

Patch 7936793      : applied on Tue Jun 16 16:20:48 CST 2009
   Created on 19 Mar 2009, 02:45:58 hrs PST8PDT
   Bugs fixed:
     7936793

Patch 8287504      : applied on Tue Jun 16 16:20:06 CST 2009
   Created on 19 Mar 2009, 03:53:36 hrs PST8PDT
   Bugs fixed:
     6941717, 7494333, 8287504, 6976005, 8304589, 6874522, 6711853, 7136489
     5476236, 7460818, 7593835, 7013124, 6954829, 7643632, 7044551, 6980597
     7432601, 7140204, 7197445, 6490140, 8287155, 7569205, 6070225, 5623467
     7276960, 6345573, 7159505, 6840740, 5126719, 7568556, 6469211, 6955744
     6882739, 5404871, 6074620, 8283650

Patch 8230457      : applied on Tue Jun 16 16:19:48 CST 2009
   Created on 18 Feb 2009, 12:01:16 hrs PST8PDT
   Bugs fixed:
     8230457

Patch 7936993      : applied on Tue Jun 16 16:19:43 CST 2009
   Created on 25 Mar 2009, 04:05:16 hrs PST8PDT
   Bugs fixed:
     7936993

Patch 7257770      : applied on Tue Jun 16 16:19:40 CST 2009
   Created on 18 Feb 2009, 22:53:30 hrs PST8PDT
   Bugs fixed:
     7257770

Patch 7257461      : applied on Tue Jun 16 16:19:35 CST 2009
   Created on 19 Feb 2009, 19:58:58 hrs PST8PDT
   Bugs fixed:
     7257461

Patch 6919819      : applied on Tue Jun 16 16:19:30 CST 2009
   Created on 18 Feb 2009, 12:05:33 hrs PST8PDT
   Bugs fixed:
     6919819

Patch 8267348      : applied on Tue Jun 16 16:18:23 CST 2009
   Created on 2 Mar 2009, 06:51:08 hrs PST8PDT
   Bugs fixed:
     8267348

Patch 7937113      : applied on Tue Jun 16 16:18:18 CST 2009
   Created on 25 Mar 2009, 04:37:06 hrs PST8PDT
   Bugs fixed:
     7937113

Patch 6451626      : applied on Tue Jun 16 16:18:06 CST 2009
   Created on 23 Feb 2009, 22:57:18 hrs PST8PDT
   Bugs fixed:
     6451626

Patch 6392076      : applied on Tue Jun 16 16:18:01 CST 2009
   Created on 25 Feb 2009, 01:23:23 hrs PST8PDT
   Bugs fixed:
     6392076

Patch 8362683      : applied on Tue Jun 16 16:17:09 CST 2009
   Created on 7 Apr 2009, 11:29:29 hrs PST8PDT
   Bugs fixed:
     8362683

Patch 7691766      : applied on Tue Jun 16 16:17:05 CST 2009
   Created on 8 Jan 2009, 20:47:40 hrs PST8PDT
   Bugs fixed:
     7691766, 7385253, 6870047

Patch 7340448      : applied on Tue Jun 16 16:16:53 CST 2009
   Created on 7 Apr 2009, 08:34:10 hrs PST8PDT
   Bugs fixed:
     7340448

Patch 7309458      : applied on Tue Jun 16 16:16:48 CST 2009
   Created on 7 Apr 2009, 08:34:14 hrs PST8PDT
   Bugs fixed:
     7309458

Patch 7278117      : applied on Tue Jun 16 16:16:44 CST 2009
   Created on 13 Aug 2008, 06:35:14 hrs PST8PDT
   Bugs fixed:
     7155655, 6917874, 7278117

Patch 7272297      : applied on Tue Jun 16 16:16:39 CST 2009
   Created on 8 Jan 2009, 20:47:50 hrs PST8PDT
   Bugs fixed:
     7272297

Patch 7189447      : applied on Tue Jun 16 16:16:36 CST 2009
   Created on 8 Jan 2009, 20:47:48 hrs PST8PDT
   Bugs fixed:
     7189447

Patch 7123643      : applied on Tue Jun 16 16:16:30 CST 2009
   Created on 27 Jun 2008, 04:00:34 hrs PST8PDT
   Bugs fixed:
     7123643

Patch 7008262      : applied on Tue Jun 16 16:16:16 CST 2009
   Created on 8 Jan 2009, 20:47:45 hrs PST8PDT
   Bugs fixed:
     7008262

Patch 6972843      : applied on Tue Jun 16 16:16:12 CST 2009
   Created on 8 Jan 2009, 20:47:44 hrs PST8PDT
   Bugs fixed:
     6972843

Patch 6923450      : applied on Tue Jun 16 16:16:07 CST 2009
   Created on 7 Apr 2009, 08:34:12 hrs PST8PDT
   Bugs fixed:
     6923450

Patch 6870937      : applied on Tue Jun 16 16:16:03 CST 2009
   Created on 7 Apr 2009, 08:34:08 hrs PST8PDT
   Bugs fixed:
     6870937

Patch 6679303      : applied on Tue Jun 16 16:15:58 CST 2009
   Created on 7 Apr 2009, 11:18:44 hrs PST8PDT
   Bugs fixed:
     6679303

Patch 6678845      : applied on Tue Jun 16 16:15:55 CST 2009
   Created on 8 Jan 2009, 20:47:37 hrs PST8PDT
   Bugs fixed:
     6678845

Patch 6638558      : applied on Tue Jun 16 16:15:48 CST 2009
   Created on 7 Apr 2009, 08:33:56 hrs PST8PDT
   Bugs fixed:
     6638558

Patch 6455659      : applied on Tue Jun 16 16:15:44 CST 2009
   Created on 23 Oct 2008, 20:38:29 hrs PST8PDT
   Bugs fixed:
     6455659

Patch 6374297      : applied on Tue Jun 16 16:15:38 CST 2009
   Created on 7 Apr 2009, 08:33:58 hrs PST8PDT
   Bugs fixed:
     6374297

Patch 6327692      : applied on Tue Jun 16 16:15:33 CST 2009
   Created on 13 Aug 2008, 06:40:20 hrs PST8PDT
   Bugs fixed:
     6327692

Patch 6084232      : applied on Tue Jun 16 16:15:28 CST 2009
   Created on 7 Apr 2009, 08:34:06 hrs PST8PDT
   Bugs fixed:
     6084232

Patch 6051177      : applied on Tue Jun 16 16:15:23 CST 2009
   Created on 7 Apr 2009, 08:34:04 hrs PST8PDT
   Bugs fixed:
     6051177

Patch 5895190      : applied on Tue Jun 16 16:15:18 CST 2009
   Created on 7 Apr 2009, 08:34:03 hrs PST8PDT
   Bugs fixed:
     5895190

Patch 5868257      : applied on Tue Jun 16 16:15:13 CST 2009
   Created on 30 Jun 2008, 00:52:04 hrs PST8PDT
   Bugs fixed:
     5868257

Patch 5756769      : applied on Tue Jun 16 16:15:09 CST 2009
   Created on 7 Apr 2009, 08:34:01 hrs PST8PDT
   Bugs fixed:
     5756769

Patch 5747462      : applied on Tue Jun 16 16:15:04 CST 2009
   Created on 7 Apr 2009, 08:33:59 hrs PST8PDT
   Bugs fixed:
     5747462

Patch 8373286      : applied on Tue Jun 16 16:13:44 CST 2009
   Created on 15 Apr 2009, 03:05:50 hrs PST8PDT
   Bugs fixed:
     7477934, 8373286, 7330909, 6800507, 7661251, 8342923, 6858062, 7835247, 8247855

--------------------------------------------------------------------------------

OPatch succeeded.

--End--