推荐订阅源

今天给家里那台爱机打上的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,大功告成。