我在我的rac数据库上打了最新的ORACLE补丁10.2.0.4.2补丁为p8833280_10204_Linux-x86-64.zip
我安装readme的要求打补丁,过程没有出现错误。
optach lsinventory得到如下结果:
rac1-> opatch lsinventory
Invoking OPatch 10.2.0.4.8
Oracle 中间补丁程序安装程序版本 10.2.0.4.8
版权所有 (c) 2009, Oracle Corporation。保留所有权利。
Oracle 主目录 : /oracle/product/10.2.0/db_1
主产品清单: /oracle/oraInventory
从 : /etc/oraInst.loc
OPatch 版本 : 10.2.0.4.8
OUI 版本 : 10.2.0.4.0
OUI 位置 : /oracle/product/10.2.0/db_1/oui
日志文件位置 : /oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2009-12-06_11-47-59上午.log
Patch history file: /oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
Lsinventory Output file location : /oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2009-12-06_11-47-59上午.txt
--------------------------------------------------------------------------------
已安装的顶级产品 (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
此 Oracle 主目录中已安装 2 个产品。
中间补丁程序 (1) :
Patch 8833280 : applied on Sun Dec 06 11:31:55 CST 2009
Unique Patch ID: 11733883
Created on 10 Sep 2009, 06:30:20 hrs PST8PDT
Bugs fixed:
6418420, 7835247, 7207654, 7592346, 6724797, 7936993, 7331867, 7552067
5879114, 5457450, 8344348, 7272297, 7136866, 7196894, 7013124, 7196532
8568395, 8309587, 7557226, 6509115, 8568397, 8568398, 6052226, 7424804
6817593, 7553884, 6469211, 7527650, 8309592, 6945157, 6403091, 7552082
6711853, 8304589, 8199266, 6327692, 5756769, 7460818, 6268409, 6687381
6972843, 8230457, 6800507, 7027551, 6778714, 6200820, 6645719, 7393804
3934160, 6683178, 6650256, 7528105, 6378112, 5126719, 7036453, 8426816
8433026, 7270434, 7172531, 6451626, 8247855, 6874522, 7175513, 6960489
7341598, 8576156, 6797677, 8342923, 5895190, 7150470, 7593835, 7356443
7044551, 8227106, 4695511, 7298688, 5747462, 7197445, 5348308, 7937113
8341623, 7569205, 8409848, 6163771, 6181488, 6375150, 7295780, 6345573
7033630, 6954722, 7457766, 7309458, 8324577, 6840740, 6804746, 7375611
8268054, 6988017, 7375613, 8344399, 7340448, 7375617, 8362683, 8251247
5933656, 6599920, 7238230, 6452375, 6352003, 6833965, 7136489, 6610218
7612639, 6392076, 5476236, 7609057, 7609058, 6374297, 6193945, 4693355
7039896, 7432514, 7330909, 6952701, 7190270, 8287155, 7207932, 6802650
7189447, 6615740, 7155655, 6749617, 7159505, 5727166, 5868257, 7173005
6917874, 7691766, 7385253, 7225720, 7244238, 7363767, 7257770, 6941717
8267348, 7710551, 7247217, 8328954, 6681695, 8702276, 8217011, 7661251
6265559, 6823287, 6991626, 6954829, 5259835, 6500033, 5923486, 7432601
8534387, 6653934, 7375644, 5147386, 7662491, 6490140, 8331466, 6070225
5623467, 7396409, 6638558, 7038750, 6838714, 6870937, 7219752, 7263842
7278117, 6882739, 5404871, 8836667, 8373286, 6678845, 6903051, 7936793
7155248, 4966512, 7155249, 8836308, 8568402, 8568404, 8568405, 6343150
6923450, 7643632, 8836671, 6145177, 6640411, 8347704, 8836675, 7155250
7155251, 8836677, 7155252, 8836678, 7155253, 7155254, 8292378, 6219529
7411865, 8227091, 8340379, 7276960, 5863926, 7123643, 6413089, 6596564
6851438, 8836681, 8836683, 8836684, 7579469, 8836686, 7315642, 7494333
8340383, 8340387, 6926448, 7600026, 6679303, 7197583, 7172752, 7008262
7477934, 6733655, 6084232, 7499353, 6980597, 6799205, 6014513, 7140204
7254987, 8833280, 7693128, 6120004, 6051177, 6858062, 7189645, 5630796
7196863, 7378661, 7378735, 8290506, 6658484, 8309623, 7599944, 7125408
6987790, 7257461, 5883691, 6919819, 7568556, 6955744, 6857917, 7149004
6074620, 8283650, 7552042, 6506617, 8287504, 6271590, 5386204, 6976005
7606362, 7043989, 8309632, 6870047, 8309637, 8309639, 6827260, 6752765
6024730, 6628122, 8239142, 4637902, 8309642, 7345904, 6994160, 6919764
7597354, 7523787, 6029179, 6455659, 5231155
包含多个节点的 RAC 系统
Local node = rac1
Remote node = rac2
--------------------------------------------------------------------------------
OPatch succeeded.
为什么我在用sqlplus登陆数据库是还是现实数据版本为10.2.0.4.0呢
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
请高手们指点,谢谢@@@@@