今天给家里那台爱机打上的OPATH ORACLE 9I R2 PATCH
SET 以前11月份打的INTERIM PATH#3238224估计派不上什么用了
这个补丁全集包含以前全部补丁 是ORACLE 07年1月RELEASE的
主要包含如下BUG LIST
9.2.0.2 2286367 OCISTMTFETCH2 FAILS WITH ORA-600 [KPOSCWR2] OR [KPOSCF10]
9.2.0.2 2288229 INVALID TIMEZONE RETURNED BY AGENT TO THE OMS
9.2.0.2 2389423 JDBC THICK DRIVER PERFORMANCE PROBLEMS WITH ECPERF WORKLOAD
9.2.0.2 2395838 MEMORY LEAK IN JVM IF USING SLTS
9.2.0.2 2026123 V$SESSION.PROGRAM DISPLAYS '?' FROM AN OCI CLIENT PROGRAM
9.2.0.3 2444960 TCL COMMAND 'EXEC' SHOULD NOT PRODUCE DEFUNCT PROCESS IF CMD TO EXECUTE IS ""
9.2.0.3 2660531 SRVCONFIG FAILS DUE TO MULTIPLE OPEN OF SHARED FILE WITHOUT CLOSING IT ON OCFS
9.2.0.3 2378501 SECOND INSTANCE STARTUP CAUSES 1ST TO CRASH W/ORA-7445 LMS PROCESS @KCLFLOGFLUSH
9.2.0.4 2420930 GET ORA-00600 [KSXPMPRP1] DURING STARTUP IN ORACLE RAC MODE WITH >10GB OF BUFFERS
9.2.0.4 2495727 MAKE SSKGMHCHECK() LIGHTER WEIGHT
9.2.0.4 2646914 ORA-600 [KCCSBCK_FIRST], [2] IF ORACM&ORACLE WAS RESTARTED ON ONE NODE
9.2.0.4 2661173 PROGRAM COLUMN IN V$SESSION POPULATED INCONSISTANTLY BY MODPLSQL SOLARIS / LINUX
9.2.0.4 2700033 TRACE FILE GENERATED FOR EVERY LOGIN WITH: CMCLI WARNING: CMINITCONTEXT
9.2.0.4 2820871 ORA-29740 NODE EVICTION DESIGN ALGORITHM AND ABRUPT TIME CHANGE
9.2.0.4 2844009 MISSING LIBCXA.SO.3 LIBRARY ISSUE IN PSR 9203
9.2.0.4 2861550 2861550 - GSD FAILS WITH PRKR-1064
9.2.0.4 2896667 PSRC: INCORRECT RESULT WHEN CALLING JAVAVM THROUGH ORACLE SERVER
9.2.0.4 2974707 EXT3 FILE SYSTEM IS NOT RECOGNIZED BY AGENT COLLECTION CART
9.2.0.4 2981273 PSRC:CORE ON LINUX JDBC OCI
9.2.0.4 3045792 MEMORY LEAK IN SLTSTSPAWN()
9.2.0.4 3238244 ENVIRON POINTER IS NULL WHEN USING GENMAKE
9.2.0.4 3274319 SELECT LN(1.0144572) FROM DUAL HANGS
9.2.0.5 2448994 DIRECT IO SUPPORT
9.2.0.5 2854962 UDLM VERSION OF SKGXN CAN ONLY SUPPORT 4 CLUSTER NODES
9.2.0.5 3016968 ASYNCIO FUNCTIONALITY IS NOT WORKING ON LINUX
9.2.0.5 3108162 ERROR: READOTHERSDSKINFO(): READFILE(/OCFSDISK1/QUORUM/QUORUMFILE) FAILED(22)
9.2.0.5 3119415 INS_OEMAGENT.MK IS NOT USING THE GLIBC STUBS
9.2.0.5 3210770 RTREE INDEX CREATION FAILURE IN MDRCRRDMDDATA
9.2.0.5 3268331 INDEX REBUILD AND SNP PROCESSES ARE FAILING WITH ORA -27103
9.2.0.5 3285741 ORA-00600 [KCCSBCK_FIRST] [2] [832017739] AFTER REBOOT
9.2.0.5 3403600 CHANGE G++ TO LD IN GENOCCISH SCRIPT
9.2.0.5 3417742 LCK KEEPS LOGGING --KSIMPOLL: SKGXNPSTAT ON (IGMXTSTALL,IGMXTSTMXTST) FAILED
9.2.0.5 3523919 ERROR CONNECTING TO PERFMON - IBVPPDC.SO: UNDEFINED SYMBOL: _VEC_MEMCPY
9.2.0.5 3553791 ORACM VERSION 49 (9.2.0.5) WITH 3+ NODES GIVES ORA-29740 EVICTION
9.2.0.5 3596858 HIGH SYSTEM TIME IN VLM MODE ON RHEL 3
9.2.0.5 3604572 LINIKING FAILS IN PRO*FORTRAN SUITS
9.2.0.5 3615482 OIDSERVER HANGS DURING STACK DUMP
9.2.0.5 3800687 _DB_BLOCK_CACHE_PROTECT NOT WORKING WITH LINUX VLM BIGPAGES
9.2.0.5 3935301 SPURIOUS ACP REFRESH EVENTS IN ACTIVE/ACTIVE OID CONFIGURATION
9.2.0.5 3942667 CANNOT START ORACLE INSTANCE WHEN SHMGET RETURNS ZERO SHMID
9.2.0.6 3928450 DIRECTIO IS REQUIRED ON X86_64 SLES9 AND NAS
9.2.0.6 3186847 FILESYSTEMIO_OPTIONS=DIRECTIO IS IGNORED ON LINUX
9.2.0.6 3901015 ORACM ON AMD64 EXITS UNEXPECTEDLY ON SLES9
9.2.0.7 4368927 APPSST:APPSRAP: 9206 CLUSTER MANAGER PATCHSET INSTALLS ONLY ON FIRST NODE
9.2.0.8 4636159 [LINUX X86] APPLYING PSR 9.2.0.7 DOES NOT UPGRADE ORACM
开始上新补丁心里还不是很有把握，嗨还是把DATAFILE 和CTL文件备份一把，保险起见把，
我把所有数据文件和控制文件拷贝到另外一个目录下去了，升级PATH正式开始了。
先把LINUX AS ENT的侦听器停掉了，过了大概20秒的样子直接把数据库DOWN了下来。
ps -ef|grep ora_|grep -v grep |wc 显示没有ORA服务在了，然后我把PATCH包传上去了
解压缩，开始运行把，一开始就报一个错误，晕 you must run as oracle, 我SU 过去以后
开始执行升级包，好事不段，又是一个错误，Xlib: connection to "192.168.1.40:0.0" refused by server
Xlib: No protocol specified ，看样子好像是 启动X11服务，CLIENT端口被拒绝的缘故，然后手工连接到X11服务，
有问题，提示 no correct protocol to set ,应该是设置对正确的协议，但是怪了在CLI下也能直接进入GNOME环境啊，
莫非是ORALCE 用户环境变量出了问题，cat /etc/profile 果然有问题 #export DISPLAY=192.168.1.40:0.0，
把X11 服务端设置回来export DISPLAY=192.168.1.40:0.0，(汗以前改了IP 环境变量没改回来，被注释掉了)
，修正以上错误配置以后，切换到安装用户，启动桌面，进入安装向导，OK 启动了，一开始显示10G安装界面，觉得有点
奇怪，所以马上关了，再次启动还是10G，莫非下错了版本，自己分析DOCUMENT发现，原来ORACLE做这个安装包是为了
方便所有数据库用的，不同的数据库，升级目录不一样的，所以切换到9i的目录去，启动runinstall OK 正常，
然后继续安装。大概20分钟后 补丁全部打上了，兴奋了一下，重启机器后，启动服务正常，一切OK,大功告成。
