GI PSU 11.2.0.2.3在最近的一次CPU July中被释出,该Patch Set Update包含了最新的CPU,且GI和Database PSU的都包含在其中,可以直接从<Patch 12419353: GI PSU 11.2.0.2.3 (INCLUDES DATABASE PSU 11.2.0.2.3)>页面下载到,该PSU所修复的Bug包括:
CPU molecules in GI PSU 11.2.0.2.3: GI PSU 11.2.0.2.3 contains the following new CPU 11.2.0.2 molecules: 12586486 - DB-11.2.0.2-MOLECULE-004-CPUJUL2011 12586487 - DB-11.2.0.2-MOLECULE-005-CPUJUL2011 12586488 - DB-11.2.0.2-MOLECULE-006-CPUJUL2011 12586489 - DB-11.2.0.2-MOLECULE-007-CPUJUL2011 12586490 - DB-11.2.0.2-MOLECULE-008-CPUJUL2011 12586491 - DB-11.2.0.2-MOLECULE-009-CPUJUL2011 12586492 - DB-11.2.0.2-MOLECULE-010-CPUJUL2011 12586493 - DB-11.2.0.2-MOLECULE-011-CPUJUL2011 12586494 - DB-11.2.0.2-MOLECULE-012-CPUJUL2011 12586495 - DB-11.2.0.2-MOLECULE-013-CPUJUL2011 12586496 - DB-11.2.0.2-MOLECULE-014-CPUJUL2011 5.2 Bugs Fixed in GI PSU 11.2.0.2.3 GI PSU 11.2.0.2.3 contains all fixes previously released in GI PSU 11.2.0.2.2 (see Section 5.3 for a list of these bug fixes) and the following new fixes: Note: ACFS is not supported on HP and therefore the bug fixes for ACFS do not apply to the HP GI PSU 3. Automatic Storage Management 6892311 - PROVIDE REASON FOR MOUNT FORCE FAILURE WITHOUT REQUIRING PST DUMP 9078442 - ORA-19762 FROM ASMCMD CP COPYING FILE WITH DIFFERENT BYTE ORDER FROM FILESYSTEM 9572787 - LONG WAITS FOR ENQ: AM CONTENTION FOLLOWING CELL CRASH CAUSED CLUSTERWIDE OUTAGE 9953542 - TB_SOL_SP: HIT 7445 [KFKLCLOSE()+20] ERROR WHEN DG OFFLINE 10040921 - HUNG DATABASE WORKLOAD AND BACKGROUNDS AFTER INDUCING WRITE ERRORS ON AVD VOLUME 10155605 - 11201-OCE:DISABLE FC IN ONE NODE, ASM DISKGOUP FORCE DISMOUNTED IN OTHER NODES. 10278372 - TB:X:CONSISTENTLY PRINT "WARNING: ELAPSED TIME DID NOT ADVANCE" IN ASM ALERT LOG 10310299 - TB:X:LOST WRITES DUE TO RESYNC MISSING EXTENTS WHEN DISK GO OFFLINE DURING REBAL 10324294 - DBMV2: DBFS INSTANCE WAITS MUCH FOR "ASM METADATA FILE OPERATION" 10356782 - DBMV2+: ASM INSTANCE CRASH WITH ORA-600 : [KFCGET0_04], [25], 10367188 - TB:X:REBOOT 2 CELL NODES,ASM FOREGROUND PROCESS HIT ORA-600[KFNSMASTERWAIT01] 10621169 - FORCE DISMOUNT IN ASM RECOVERY MAY DROP REDO'S AND CAUSE METADATA CORRUPTIONS 11065646 - ASM MAY PICK INCORRECT PST WHEN MULTIPLE COPIES EXTANT 11664719 - 11203_ASM_X64:ARB0 STUCK IN DG REBALANCE 11695285 - ORA-15081 I/O WRITE ERROR OCCURED AFTER CELL NODE FAILURE TEST 11707302 - FOUND CORRUPTED ASM FILES AFTER CELL NODES FAILURE TESTING. 11707699 - DATABASE CANNOT MOUNT DUE TO ORA-00214: CONTROL FILE INCONSISTENCY 11800170 - ASM IN KSV WAIT AFTER APPLICATION OF 11.2.0.2 GRID PSU 11800854 - BUG TO TRACK LRG 5135625 12620422 - FAILED TO ONLINE DISKS BECAUSE OF A POSSIBLE RACING RESYNC Buffer Cache Management 11674485 - LOST DISK WRITE INCORRECTLY SIGNALLED IN STANDBY DATABASE WHEN APPLYING REDO Generic 9748749 - ORA-7445 [KOXSS2GPAGE] 10082277 - EXCESSIVE ALLOCATION IN PCUR OF "KKSCSADDCHILDNO" CAUSES ORA-4031 ERRORS 10126094 - ORA-600 [KGLLOCKOWNERSLISTDELETE] OR [KGLLOCKOWNERSLISTAPPEND-OVF] 10142788 - APPS 11I PL/SQL NCOMP:ORA-04030: OUT OF PROCESS MEMORY 10258337 - UNUSABLE INDEX SEGMENT NOT REMOVED FOR "ALTER TABLE MOVE" 10378005 - EXPDP RAISES ORA-00600[KOLRARFC: INVALID LOB TYPE], EXP IS SUCCESSFUL 10636231 - HIGH VERSION COUNT FOR INSERT STATEMENTS WITH REASON INST_DRTLD_MISMATCH 12431716 - UNEXPECTED CHANGE IN MUTEX WAIT BEHAVIOUR IN 11.2.0.2.2 PSU (HIGHER CPU POSSIBLE High Availability 9869401 - REDO TRANSPORT COMPRESSION (RTC) MESSAGES APPEARING IN ALERT LOG 10157249 - CATALOG UPGRADE TO 11.2.0.2 FAILS WITH ORA-1 10193846 - RMAN DUPLICATE FAILS WITH ORA-19755 WHEN BCT FILE OF PRIMARY IS NOT ACCESSIBLE 10648873 - SR11.2.0.3TXN_REGRESS - TRC - KCRFW_REDO_WRITE 11664046 - STBH: WRONG SEQUENCE NUMBER GENERATED AFTER DB SWITCHOVER FROM STBY TO PRIMARY Oracle Portable ClusterWare 8906163 - PE: NETWORK AND VIP RESOURCES FAIL TO START IN SOLARIS CONTAINERS 9593552 - GIPCCONNECT() IS NOT ASYNC 11.2.0.2GIBTWO 9897335 - TB-ASM: UNNECCESSARY OCR OPERATION LOG MESSAGES IN ASM ALERT LOG WITH ASM OCR 9902536 - LNX64-11202-MESSAGE: EXCESSIVE GNS LOGGING IN CRS ALERT FILE WHEN SELFCHECK FAIL 9916145 - LX64: INTERNAL ERROR IN CRSD.LOG, MISROUTED REQUEST, ASSERT IN CLSM2M.CPP 9916435 - ROOTCRS.PL FAILS TO CREATE NODEAPPS DURING ADD NODE OPERATION 9939306 - SERVICES NOT COMING UP AFTER SWITCHOVER USING SRVCTL START DATABASE 10012319 - ORA-600 [KFDVF_CSS], [19], [542] ON STARTUP OF ASM DURING ADDNODE 10019726 - MEMORY LEAK 1.2MB/HR IN CRSD.BIN ON NON-N NODE 10056713 - LNX64-11202-CSS: SPLIT BRAIN WHEN START CRS STACK IN PARALLEL WITH PRIV NIC DOWN 10103954 - INTERMITTENT "CANNOT COMMUNICATE WITH CRSD DAEMON" ERRORS 10104377 - GIPC ENSURE INITIAL MESSAGE IS NOT LOST DURING ESTABLISH PHASE 10115514 - SOL-X64-11202: CLIENT REGISTER IN GLOBAL GROUP MASTER#DISKMON#GROUP#MX NOT EXIT 10190153 - HPI-SG-11202 ORA.CTSSD AND ORA.CRSD GOES OFFLINE AFTER KILL GIPC ON CRS MASTER 10231906 - 11202-OCE-SYMANTEC:DOWN ONE OF PRIVAE LINKS ON NODE 3,OCSSD CRASHED ON NODE 3 10233811 - AFTER PATCHING GRID HOME, UNABLE TO START RESOURCES DBFS AND GOLDEN 10253630 - TB:X:HANG DETECTED,"WAITING FOR INSTANCE RECOVERY OF GROUP 2" FOR 45 MINUTES 10272615 - TB:X:SHUTDOWN SERVICE CELLD ON 2 CELL NODES,CSSD ABORT IN CLSSNMRCFGMGRTHREAD 10280665 - TB:X:STOP CELLD ON 2 CELL NODES,CSSD ABORT IN CLSSNMVVERIFYPENDINGCONFIGVFS 10299006 - AFTER 11.2.0.2 UPGRADE, ORAAGENT.BIN CONNECTS TO DATABASE WITH TOO MANY SESSIONS 10322157 - 11202_GIBONE: PERM OF FILES UNDER $CH/CRS/SBS CHANGED AFTER PATCHED 10324594 - STATIC ENDPOINT IN THE LEASE BLOCKS OVERWRITTEN DURING UPGRADE 10331452 - SOL-11202-UD: 10205->11202 NETWORK RES USR_ORA_IF VALUE MISSED AFTER UPGRADE 10357258 - SOL-11202-UD: 10205->11202 [IPMP] HUNDREDS OF DUP IP AFTER INTRA-NODE FAILOVER 10361177 - LNX64-11203-GNS: MANY GNS SELF CHECK FAILURE ALERT MESSAGES 10385838 - TB:X:CSS CORE DUMP AT GIPCHAINTERNALSEND 10397652 - AIX-11202-GIPC:DISABLE SWITCH PORT FOR ONE PRIVATE NIC,HAIP DID NOT FAILOVER 10398810 - DOUBLE FREE IN SETUPWORK DUE TO TIMING 10419987 - PEER LISTENER IS ACCESSING A GROCK THAT IS ALREADY DELETED 10621175 - TB_RAC_X64:X: CLSSSCEXIT: CSSD SIGNAL 11 IN THREAD GMDEATHCHECK 10622973 - LOSS OF LEGACY FEATURES IN 11.2 10631693 - TB:X:CLSSNMHANDLEVFDISCOVERACK: NO PENDINGCONFIGURATION TO COMPLETE. CSS ABORT 10637483 - TB:X:REBOOT ONE CELL NODE, CSS ABORT AT CLSSNMVDDISCTHREAD 10637741 - HARD STOP DEPENDENCY CAN CAUSE WRONG FAIL-OVER ORDER 10638381 - 11202-OCE-SYMANTEC: HAIP FAIL TO START WHEN PRIVATE IP IS PLUMBED ON VIRTUAL NIC 11069614 - RDBMS INSTANCE CRASH DUE TO SLOW REAP OF GIPC MESSAGES ON CMT SYSTEMS 11071429 - PORT 11GR2 CRS TO EL6 11654726 - SCAN LISTENER STARTUP FAILS IF /VAR/OPT/ORACLE/LISTENER.ORA EXISTS. 11663339 - DBMV2:SHARED PROCESS SPINNING CAUSES DELAY IN PRIMARY MEMBER CLEANUP 11682409 - RE-USING OCI MEMORY ACROSS CONNECTIONS CAUSES A MEMORY CORRUPTION 11698552 - SRVCTL REPORT WRONG STATUS FOR DATABASE INSTANCE. 11741224 - INCORRECT ACTIVE VERSION CHECK WHILE ENABLING THE BATCH FUNCTIONALITY 11744313 - LNX64-11203-RACG: UNEXPECTED CRSD RESTART DURING PARALLEL STACK START 11775080 - ORA-29701/29702 OCCURS WHEN WORKLOAD TEST RUNNING FOR A LONG TIME AND IS RESTART 11781515 - EVMD/CRSD FAIL TO START AFTER REBOOT, EVEN AFTER CRSCTL START CLUSTERWARE 11807012 - LNX64-11203-RACG: DB SERVICE RUNS INTO "UNKNOWN" STATE AFTER STACK START 11812615 - LNX64-11203-DIT: INCONSISTENT PERMISSION BEFORE/AFTER ROOTCRS.PL -UNLOCK/-PATCH 11828633 - DATABASE SERVICE DID NOT FAIL OVER AND COULD NOT BE STARTED AFTER NODE FAILURE 11840629 - KERNEL CRASH DUMP AND REBOOT FAIL INSIDE SOLARIS CONTAINER 11866171 - ENABLE CRASHDUMP WHEN REBOOTING THE MACHINE (LINUX) 11877079 - HUNDREDS OF ORAAGENT.BIN@HOSTNAME SESSSIONS IN 11.2.0.2 DATABASE 11899801 - 11202_GIBTWO_HPI:AFTER KILL ASM PMON, POLICY AND ADMIN DB RUNNING ON SAME SERVER 11904778 - LNX64-OEL6-11202: CRS STACK CAN'T BE START AFTER RESTART 11933693 - 11.1.0.7 DATABASE INSTANCE TERMINATED BY 11.2.0.2 CRS AGENT 11936945 - CVU NOT RECOGNIZING THE OEL6 ON LINUX 12332919 - ORAAGENT KEEPS EXITING 12340501 - SRVCTL SHOWS INSTANCE AS DOWN AFTER RELOCATION 12340700 - EVMD CONF FILES CAN HAVE WRONG PERMISSIONS AFTER INSTALL 12349848 - LNX64-11203: VIPS FELL OFFLINE WHEN BRING DOWN 3/4 PUBLIC NICS ONE BY ONE 12378938 - THE LISTENER STOPS WHEN THE ORA.NET1.NETWORK'S STATE IS CHANGED TO UNKNOWN 12380213 - 11203_110415:ERROR EXCEPTION WHILE INSTALLATION 11202 DB WITH DATAFILES ON 11203 12399977 - TYPO IN SUB PERFORM_START_SERVICE RETURNS ZERO (SUCCESS) EVEN WHEN FAILED 12677816 - SCAN LISTENER FAILD TO STARTUP IF /VAR/OPT/ORACLE/LISTENER.ORA EXIST Oracle Space Management 8223165 - ORA-00600 [KTSXTFFS2] AFTER DATABASE STARTUP 9443361 - WRONG RESULTS (ROWDATA) FOR SELECT IN SERIAL FROM COMPRESSED TABLE 10061015 - LNX64-11202:HIT MANY ORA-600 ARGUMENTS: [KTFBHGET:CLSVIOL_KCBGCUR_9] DURING DBCA 10132870 - INDEX BLOCK CORRUPTION - ORA-600 [KCBZPBUF_2], [6401] ON RECOVER 10324526 - ORA-600 [KDDUMMY_BLKCHK] [6106] WHEN UPDATE SUBPARTITION OF TABLE IN TTS Oracle Transaction Management 10053725 - TS11.2.0.3V3 - TRC - K2GUPDATEGLOBALPREPARECOUNT 10233732 - ORA-600 [K2GUGPC: PTCNT >= TCNT] OCCURS IN A DATABASE LINK TRANSACTION Oracle Universal Storage Management 9867867 - SUSE10-LNX64-11202:NODE REBOOT HANG WHILE ORACLE_HOME LOCATED ON ACFS 9936659 - LNX64-11202-CRS: ORACLE HOME PUT ON ACFS, DB INST FAILS TO RESTART AFTER CRASH 9942881 - TIGHTEN UP KILL SEMANTICS FOR 'CLEAN' ACTION. 10113899 - AIX KSPRINTTOBUFFER TIMESTAMPS NEEDS TIME SINCE BOOT AND WALL_CLOCK TIMES 10266447 - ROOTUPGRADE.SH FAILS: 'FATAL: MODULE ORACLEOKS NOT FOUND' , ACFS-9121, ACFS-9310 11789566 - ACFS RECOVERY PHASE 2 11804097 - GBM LOCK TAKEN WHEN DETERMINING WHETHER THE FILE SYSTEM IS MOUNTED AND ONLINE 11846686 - ACFSROOT FAILS ON ORACLELINUX-RELEASE-5-6.0.1 RUNNUNG A 2.6.18 KERNEL 12318560 - ALLOW IOS TO RESTART WHEN WRITE ERROR MESG RETURNS SUCCESS 12326246 - ASM TO RETURN DIFF VALUES WHEN OFFLINE MESG UNSUCCESSFUL 12378675 - AIX-11203-HA-ACFS: HIT INVALID ASM BLOCK HEADER WHEN CONFIGURE DG USING AIX LVS 12398567 - ACFS FILE SYSTEM NOT ACCESSIBLE 12545060 - CHOWN OR RM CMD TO LOST+FOUND DIR IN ACFS FAILS ON LINUX Oracle Utilities 9735282 - GETTING ORA-31693, ORA-2354, ORA-1426 WHEN IMPORTING PARTITIONED TABLE Oracle Virtual Operating System Services 10317487 - RMAN CONTROLFILE BACKUP FAILS WITH ODM ERROR ORA-17500 AND ORA-245 11651810 - STBH: HIGH HARD PARSING DUE TO FILEOPENBLOCK EATING UP SHARED POOL MEMORY XML Database 10368698 - PERF ISSUE WITH UPDATE RESOURCE_VIEW DURING AND AFTER UPGRADING TO 11.2.0.2 5.3 Bugs Fixed in GI PSU 11.2.0.2.2 This section describes bugs fixed in the GI PSU 11.2.0.2.2 release. ACFS 10015603 - KERNEL PANIC IN OKS DRIVER WHEN SHUTDOWING CRS STACK 10178670 - ACFS VOLUMES ARE NOT MOUNTING ONCE RESTARTED THE SERVER 10019796 - FAIL TO GET ENCRYPTION STATUS OF FILES UNTIL DOING ENCR OP FIRST 10029794 - THE DIR CAN'T READ EVEN IF THE DIR IS NOT IN ANY REALM 10056808 - MOUNT ACFS FS FAILED WHEN FS IS FULL 10061534 - DB INSTANCE TERMINATED DUE TO ORA-445 WHEN START INSTANCE ON ALL NODES 10069698 - THE EXISTING FILE COULD CORRUPT IF INPUT INCORRECT PKCS PASSOWRD 10070563 - MULTIPLE WRITES TO THE SAME BLOCK WITH REPLICATION ON CAN GO OUT OF ORDER 10087118 - UNMOUNT PANICS IF ANOTHER USER IS SITTING IN A SNAPSHOT ROOT DIRECTORY 10216878 - REPLI-RELATED RESOURCE FAILED TO FAILOVER WHEN DG DISMOUNTED 10228079 - MOUTING DG ORA-15196 [KFC.C:25316] [ENDIAN_KFBH] AFTER NODE REBOOT 10241696 - FAILED TO MOUNT ACFS FS TO DIRECTORY CREATED ON ANOTHER ACFS FS 10252497 - ADVM/ACFS FAILS TO INSTALL ON SLES10 9861790 - LX64: ADVM DRIVERS HANGING OS DURING ACFS START ATTEMPTS 9906432 - KERNEL PANIC WHILE DISMOUNT ACFS DG FORCE 9975343 - FAIL TO PREPARE SECURITY IF SET ENCRYPTION FIRST ON THE OTHER NODE 10283549 - FIX AIX PANIC AND REMOVE -DAIX_PERF 10283596 - ACFS:KERNEL PANIC DURING USM LABEL PATCHING - ON AIX 10326548 - WRITE-PROTETED ACFS FILES SHOULD NOT BE DELETED BY NON-ROOT USER ADVM 10045316 - RAC DB INSTALL ON SHARED ACFS HANGS AT LINKING PHASE 10283167 - ASM INSTANCE CANNOT STARTUP DUE TO EXISTENCE OF VMBX PROCESS 10268642 - NODE PANIC FOR BAD TRAP IN "ORACLEADVM" FOR NULL POINTER 10150020 - LINUX HANGS IN ADVM MIRROR RECOVERY, AFTER ASM EVICTIONS Automatic Storage Management 9788588 - STALENESS REGISTRY MAY GET CLEARED PREMATURELY 10022980 - DISK NOT EXPELLED WHEN COMPACT DISABLED 10040531 - ORA-600 [KFRHTADD01] TRYING TO MOUNT RECO DISKGROUP 10209232 - STBH: DB STUCK WITH A STALE EXTENT MAP AND RESULTS IN DATA CORRUPTIONS 10073683 - ORA-600 [KFCBINITSLOT40] ON ASM ON DBMV2 WITH BP5 9715581 - DBMV2: EXADATA AUTO MANAGEMENT FAILED TO BRING UP DISKS ONLINE 10019218 - ASM DROPPED DISKS BEFORE DISK_REPAIR_TIME EXPIRED 10084145 - DBMV2: ORA-600 [1427] MOUNTING DISKGROUP AFTER ALL CELLS RESTARTED 11067567 - KEPT GENERATING "ELAPSED TIME DID NOT ADVANCE " IN ASM ALERT LOG 10356513 - DISK OFFLINED WITH NON ZERO TIMEOUT EXPELLED IMMEDIATELY 10332589 - TB:X:MOUNT NORMAL REDUNDANCY DG, FAILED WITH ORA-00600:[KFCINITRQ20] 10329146 - MARKING DIFFERENT SR BITS FROM MULTIPLE DBWS CAN CAUSE A LOST WRITE 10299224 - TB:X:PIVOTING AN EXTENT ON AN OFFLINE DISK CAN CAUSE STALE XMAPS IN RDBMS 10245086 - ORA-01210 DURING CREATE TABLESPACE 10230571 - TB:X:REBOOT ONE CELL NODE, RBAL HIT ORA-600[17183] 10228151 - ASM DISKGROUPS NOT GETTING MOUNTED 10227288 - DG FORCIBLY DISMOUNTED AFTER ONE FG LOST DUE TO "COULD NOT READ PST FOR GRP 4" 10222719 - ASM INSTANCE HANGS WITH RBAL PROCESS WAITS ON "NO FREE BUFFER" 10102506 - DISK RESYNC TAKES A LONG TIME EVEN WITH NO STALE EXTENTS 10094201 - DISK OFFLINE IS SLOW 10190642 - ORA-00600: [1433] FOLLOWED BY INSTANCE CRASH WITH ASM ON EXADATA 11067567 - 11202_gibtwo: kept generating "elapsed time did not advance " in asm alert log Buffer Cache Management 9651350 - ora-00308 and ora-27037 when ora-8103 without event 10736 been set 10110863 - trace files is still generated after applying patch:9651350 10205230 - tb_x64: hit ora-00600: [kclwcrs_6] 10332111 - sql running long in active standby CRS Group CLEANUP 9949676 - GNSD.BIN CORE DUMP AFTER KILL ASM PMON ON ALL NODES AT SAME TIME 9975837 - GNS INCORRECTLY PROCESSES IPV6 LOOKUP REQUESTS 10007185 - GNS DUMPS CORE IN CLSKGOPANIC AT CLSKPDVA 717 10028343 - GNS CAN NOT BE RELOCATED AFTER PUBLIC RESTARTED CRS 9876201 - OHASD AGENT CORE DUMP AT EONSHTTP.C:162 10011084 - 11202 STEP3 MODIFY BINARY AFTER INSTALLATION CANNOT EXCUTE SUCCESSFULLY 10028235 - 'CLSNVIPAGENT.CPP', LINE 1522: ERROR: FORMAL ARGUMENT TYPE OF ... 10045436 - 'ORA.LISTENER.LSNR' FAILED TO BE FENCED OFF DURING CRSD CLEANUP 10062301 - VALUE FOR FIELD 'CLUSTER_NAME' IS MISSING IN CRSCONFIG_PARAMS 10110969 - PORTABILITY ISSUES IN FUNCTION TOLOWER_HOST 10175855 - FAILED TO UGPRADE 11.2.0.1 + ARU 12900951 -> 11.2.0.2 9891341 - CRSD CORE DUMP IN PROATH_MASTER_EXIT_HELPER AT PROATH.C:1834 11655840 - RAC1 DB' STATE_DETAILS IS WRONG AFTER KILL GIPCD 10634513 - OHASD DUMPS CORE WHEN PLUG IN UNPLUGGED PRIVATE NETWORK NIC 10236074 - ASM INSTANCES CRASH SEVERAL TIMES DURING PARALLEL CRS STARTUP 10052529 - DB INST OFFLINE AFTER STOP/START CRS STACK ON ALL NODES IN PARALLEL 10065216 - VIRTUAL MEMORY USAGE OF ORAROOTAGENT IS BIG(1321MB) AND NOT DECREASING 10168006 - ORAAGENT PROCESS MEMORY GROWTH PERIODICALLY. CSS 9907089 - CSS CORE DUMP DURING EXADATA ROLLING UPGRADE 9926027 - NODE REBOOTED AFTER CRS CLEAN-UP SUCCEEDED 11202 GI + 10205 RAC DB 10014392 - CRSCTL DELETE NODE FAILS WITH CRS-4662 & CRS-4000 10015460 - REMOVAL OF WRONG INCARNATION OF A NODE DUE TO MANUAL SHUTDOWN STATE 10040109 - PMON KILL LEAD TO OS REBOOT 10048027 - ASM UPGRADE FAILS 10052721 - 11201- 11202 NON-ROLLING,CRSCTL.BIN CORE AT CLSSNSQANUM, SIGNAL 11 10083789 - A NODE DOESNT INITIATE A RECONFIG DUE TO INCORRECT RECONFIG STATE 9944978 - FALSE CSS EVICTION AFTER PRIVATE NIC RESUME 9978195 - STOP DB ACTION TIMED OUT AND AGENT EXITS DUE TO FAILURE TO STOP EVENT BRIDGE 10248739 - AFTER APPLY THE PATCH, THE NODE EVICTED DURING START CRS STACK CVU 9679401 - OUI PREREQ CHECKS FAILED FOR WRONG OWNSHIP OF RESOLV.CONF_`HOST` 9959110 - GNS INTEGRITY PREREQUISITE FAILED WITH PRVF-5213 9979706 - COMP OCR CHECK FAILS TO VERIFY SIZE OF OCR LOCATION 10029900 - CVU PRE NODEADD CHECK VD ERROR 10033106 - ADDNODE.SH SHOULD INDICATE WHAT HAPPENS WHEN ERROR OCCURRING 10075643 - UNABLE TO CONTINUE CONFIG.SH FOR CRS UPGRAD 10083009 - GIPCD FAILS TO RETRIEVE INFORMATION FROM PEERS DUE TO INVALID ENDPOINT GIPC 9812956 - STATUS OF CRSD AND EVMD GOES INTERMEDIATE FOR EVER WHEN KILL GIPC 9915329 - ORA-600 [603] IN DB AND ORA-603 IN ASM AFTER DOWN INTER-CONNECT NIC 9944948 - START RESOUCE HAIP FAILED WHEN RUN ROOT.SH 9971646 - ORAROOTAGENT CORE DUMPED AT NETWORKHAMAINTHREAD::READROUTEDATA 9974223 - GRID INFRASTRUCTURE NEEDS MULTICAST COMMUNICATION ON 230.0.1.0 ADDRESSES WORKING 10053985 - ERROR IN NETWORK ADDRESS ON SOLARIS 11 10057680 - OHASD ORAROOTAGENT.BIN SPIN CPU AFTER SIMULATE ASM DISK ERROR 10078086 - ROOTUPGRADE.SH FAIL FOR 'CRSCTL STARTUPGRADE' FAIL,10205-> 11202 10260251 - GRID INSTALLATION FAILS TO START HAIP DUE TO CHANGE IN NETWORK INTERFACE NAME 10111010 - CRSD HANGS FOR THE HANAME OF PEER CRSD 11782423 - OHASD.BIN TAKES CPU ABOUT 95% ~ 100% 11077756 - STARTUP FAILURE OF HAIP CAUSES INSTALLATION FAILURE 10375649 - DISABLE HAIP ON PRIMECLUSTER 10284828 - INTERFACE UPDATES GET LOST DURING BOUNCE OF CRSD PROCESS 10284693 - AIX EPIPE FAILURE 10233159 - NEED 20 MINS TO STARTUP CRS WHEN 1/2 GIPC NICS DOWN 10128191 - LRGSRG9 AND LRGSRGE FAILURE GNS 9864003 - NODE REBOOT DUE TO 'ORA.GNS' FAILED TO BE FENCED OFF DURING CRSD GPNP 9336825 - GPNPD FLUSH PROFILE PUSH ERROR MESSAGES IN CRS ALERT LOG 10314123 - GPNPD MAY NOT UPDATE PROFILE TO LATEST ON START 10105195 - PROC-32 ACCESSING OCR; CRS DOES NOT COME UP ON NODE 10205290 - DBCA FAILED WITH ERROR ORA-00132 10376847 - [ORA.CRF] [START] ERROR = ERROR 9 ENCOUNTERED WHEN CONNECTING TO MOND IPD-OS 9812970 - IPD DO NOT MARK TYPE OF DISKS USED FOR VOTING DISK CORRECTLY 10057296 - IPD SPLIT BRAIN AFTER CHANGE BDB LOCATION 10069541 - IPD SPLIT BRAIN AFTER STOPPING ORA.CRF ON MASTER NODE 10071992 - UNREASONABLE VALUES FOR DISK STATISTICS 10072474 - A NODE IS NOT MONITORED AFTER STOP AND START THE ORA.CRF ON IT 10073075 - INVALID DATA RECEIVED FROM THE CLUSTER LOGGER SERVI 10107380 - IPD NOT STARTED DUE TO SCRFOSM_GET_IDS FAILED OCR 9978765 - ROOTUPGRADE.SH HANG AND CRSD CRASHED ON OTHER NODES,10205-> 11202 10016083 - 'OCRCONFIG -ADD' NEEDS HELPFUL MESSAGE FOR ERROR ORA-15221 OPSM 9918485 - EMCONFIG FAIL WITH NULLPOINTEREXCEPTION AT RACTRANSFERCORE.JAVA 10018215 - RACONE DOES NOT SHUTDOWN INSTANCE DURING RELOCATION 10042143 - ORECORE11 LWSFDSEV CAUSED SEGV IN SRVM NATIVE METHODS OTHERS 9963327 - CHMOD.PL GETS CALLED INSTEAD OF CHMOD.EXE 10008467 - FAILS DUE TO WRONG VERSION OF PERL USED: 10015210 - OCTSSD LEAK MEMORY 1.7M HR ON PE MASTER DURING 23 HOURS RUNNI 10027079 - CRS_SHUTDOWN_SYNCH EVENT NOT SENT IN SIHA 10028637 - SCLS.C COMPILE ERRORS ON AIX UNDECLARED IDENTIFIERS 10029119 - 11201-11202 CRS UPGRADE OUI ASKS TO RUN ROOTUPGRADE.SH 10036834 - PATCHES NOT FOUND ERROR WHILE UPGRADING GRID FROM 11201 TO 11202 10038791 - HAS SRG SRV GETTING MANY DIFS FOR AIX ON LABEL 100810 AND LATER 10040647 - LNX64-112022-UD; AQ AND RLB DO NOT WORK AFTER UPGRADING FROM 11201 10044622 - EVMD FAILED TO START AFTER KILL OHASD.BIN 10048487 - DIAGCOLLECTION CANNOT RETRIEVE IPD REPORTS 10073372 - DEINSTALL FAILED TO DELETE CRS_HOME ON REMOTE NODE IF OCR VD ON NFS 10089120 - WRONG PROMPT MESSAGE BY DEINSTALL COMMAND WHILE DELETING CRS HOME 10124517 - CRS STACK DOES NOT START AUTOMATICALLY AFTER NODE REBOOT 10157622 - 11.2.0.2 GI BUNDLE 1 HAS-CRS TRACKING BUG RACG 10036193 - STANDBY NIC DOESN'T WORK IF DOWN PUBLIC NIC 10146768 - NETWORK RESOURCE FAILS TO START WITH IPMP ON SOLARIS 11 USM Miscellaneous 10146744 - ORA.REGISTRY.ACFS BECOME UNKOWN AND ACFS FS DISMOUNT 10283058 - RESOURCES ACFS NEEDS AN OPTION TO DISALLOW THE MOUNTING OF FILE SYSTEMS ON RESOURCE START 10193581 - ROOT.SH CRS-2674: START OF 'ORA.REGISTRY.ACFS' FAIL 10244210 - FAIL TO INSTALL ADVM/ACFS ON SOLARIS CONTAINER 10311856 - APPLY ASSERTION FAILURE:PBOARDENTRY>USRGBOARDRECENTRY_RECORD Generic 9591812 - incorrect wait events in 11.2 ("cursor: mutex s" instead of "cursor: mutex x") 9905049 - ebr: ora-00600: internal error code, arguments: [kqlhdlod-bad-base-objn] 10052141 - exadata database crash with ora-7445 [_wordcopy_bwd_dest_aligned] and ora-600 [2 10052956 - ora-7445 [kjtdq()+176] 10157402 - lob segment has null data after long to lob conversion in parallel mode 10187168 - obsolete parent cursors if version count exceeds a threshold 10217802 - alter user rename raises ora-4030 10229719 - qrmp:12.2:ora-07445 while performing complete database import on solaris sparc 10264680 - incorrect version_number reported after patch for 10187168 applied 10411618 - add different wait schemes for mutex waits 11069199 - ora-600 [kksobsoletecursor:invalid stub] quering pq when pq is disabled 11818335 - additional changes when wait schemes for mutex waits is disabled High Availability 10018789 - dbmv2-bigbh:spin in kgllock caused db hung and high library cache lock 10129643 - appsst gsi11g m9000: ksim generic wait event 10170431 - ctwr consuming lots of cpu cycles Oracle Space Management 6523037 - et11.1dl: ora-600 [kddummy_blkchk] [6110] on update 9724970 - pdml fails with ora-600 [4511]. ora-600 [kdblkcheckerror] by block check 10218814 - dbmv2: ora-00600:[3020] data block corruption on standby 10219576 - ora-600 [ktsl_allocate_disp-fragment] Oracle Transaction Management 10358019 - invalid results from flashback_transaction_query after applying patch:10322043 Oracle Utilities 10373381 - ora-600 [kkpo_rcinfo_defstg:objnotfound] after rerunning catupgrd.sql Oracle Virtual Operating System Services 10127360 - dg4msql size increasing to 1.5gb after procedure executed 250 times Server Manageability 11699057 - ora-00001: unique constraint (sys.wri$_sqlset_plans_tocap_pk) violated
针对Grid Infrastructure的大致升级步骤如下,具体见该PSU的readme文档,见(6 Appendix A: Manual Steps for Apply/Rollback Patch)
部分:
1.升级Opatch,Patch 12419353 requires OPatch version 11.2.0.1.4. 可以从这里下载到11.2上最新的opatch工具,解压后直接覆盖原Opatch目录即可 2.关闭相关的RAC数据库 <ORACLE_HOME>/bin/srvctl stop database –d <db-unique-name> 3.Umount所有的ACFS文件系统 4. 切换到oracle用户,停止所有节点上的相关资源 su - oracle $<ORACLE_HOME>/bin/srvctl stop home -o <ORACLE_HOME> -s <status file location> -n <node name> 5.在所有节点上运行rootcrs.pl脚本停止GI相关资源 su - root <GI_HOME>/crs/install/rootcrs.pl -unlock Using configuration parameter file: /g01/11.2.0/grid/crs/install/crsconfig_params CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'vrh1' CRS-2673: Attempting to stop 'ora.crsd' on 'vrh1' CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'vrh1' CRS-2673: Attempting to stop 'ora.asm' on 'vrh1' CRS-2677: Stop of 'ora.asm' on 'vrh1' succeeded CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'vrh1' has completed CRS-2677: Stop of 'ora.crsd' on 'vrh1' succeeded CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'vrh1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'vrh1' CRS-2673: Attempting to stop 'ora.ctssd' on 'vrh1' CRS-2673: Attempting to stop 'ora.evmd' on 'vrh1' CRS-2673: Attempting to stop 'ora.asm' on 'vrh1' CRS-2677: Stop of 'ora.asm' on 'vrh1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'vrh1' CRS-2677: Stop of 'ora.evmd' on 'vrh1' succeeded CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'vrh1' succeeded CRS-2677: Stop of 'ora.mdnsd' on 'vrh1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'vrh1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'vrh1' CRS-2677: Stop of 'ora.cssd' on 'vrh1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'vrh1' CRS-2673: Attempting to stop 'ora.diskmon' on 'vrh1' CRS-2677: Stop of 'ora.diskmon' on 'vrh1' succeeded CRS-2677: Stop of 'ora.gipcd' on 'vrh1' succeeded CRS-2673: Attempting to stop 'ora.gpnpd' on 'vrh1' CRS-2677: Stop of 'ora.drivers.acfs' on 'vrh1' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'vrh1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'vrh1' has completed CRS-4133: Oracle High Availability Services has been stopped. Successfully unlock /g01/11.2.0/grid 6.解压下载的PSU补丁包 unzip p12419353_112020_Linux-x86-64.zip 7. 在所有节点上实施对GI的Patch <GI_HOME>/OPatch/opatch napply -oh <GI_HOME> -local /tmp/12419353 Invoking OPatch 11.2.0.1.6 Oracle Interim Patch Installer version 11.2.0.1.6 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /g01/11.2.0/grid Central Inventory : /g01/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.6 OUI version : 11.2.0.2.0 Log file location : /g01/11.2.0/grid/cfgtoollogs/opatch/opatch2011-08-12_00-07-39AM.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 12419353 Do you want to proceed? [y|n] Backing up files... Applying interim patch '12419353' to OH '/g01/11.2.0/grid' Patching component oracle.crs, 11.2.0.2.0... Copying file to "/g01/11.2.0/grid/crs/install/crsconfig_lib.pm" Copying file to "/g01/11.2.0/grid/crs/install/crspatch.pm" Copying file to "/g01/11.2.0/grid/crs/install/s_crsconfig_lib.pm" Patching component oracle.usm, 11.2.0.2.0... Patches 12419353 successfully applied. Log file location: /g01/11.2.0/grid/cfgtoollogs/opatch/opatch2011-08-12_00-07-39AM.log OPatch succeeded. <GI_HOME>/OPatch/opatch napply -oh <GI_HOME> -local /tmp/12419331 Invoking OPatch 11.2.0.1.6 Oracle Interim Patch Installer version 11.2.0.1.6 Copyright (c) 2011, Oracle Corporation. All rights reserved. UTIL session Oracle Home : /g01/11.2.0/grid Central Inventory : /g01/oraInventory from : /etc/oraInst.loc OPatch version : 11.2.0.1.6 OUI version : 11.2.0.2.0 Log file location : /g01/11.2.0/grid/cfgtoollogs/opatch/opatch2011-08-12_00-10-46AM.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 12419331 Backing up files... Applying interim patch '12419331' to OH '/g01/11.2.0/grid' ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.2.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.3 ] , [ oracle.rdbms.dv, 11.2.0.2.0 ] , [ oracle.sysman.plugin.db.main.repository, 11.2.0.2.0 ] not present in the Oracle Home or a higher version is found. Patching component oracle.rdbms.rsf, 11.2.0.2.0... Patching component oracle.rdbms, 11.2.0.2.0... Copying file to "/g01/11.2.0/grid/psu/11.2.0.2.3/catpsu.sql" Copying file to "/g01/11.2.0/grid/psu/11.2.0.2.3/catpsu_rollback.sql" Copying file to "/g01/11.2.0/grid/cpu/scripts/patch_8837510.sql" Copying file to "/g01/11.2.0/grid/cpu/scripts/emdb_recomp_invalids.sql" Patching component oracle.ldap.rsf, 11.2.0.2.0... Patching component oracle.rdbms.dbscripts, 11.2.0.2.0... Patching component oracle.rdbms.rman, 11.2.0.2.0... Patches 12419331 successfully applied. Log file location: /g01/11.2.0/grid/cfgtoollogs/opatch/opatch2011-08-12_00-10-46AM.log OPatch succeeded. 后续对DB HOME升级的步骤可以参照以下文档摘录 8.Run the pre script for DB component of the patch. As the database home owner execute: $<UNZIPPED_PATCH_LOCATION>/12419353/custom/server/12419353/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME> 9.Apply the DB patch. As the database home owner execute: $<ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/12419353/custom/server/12419353 $<ORACLE_HOME>/OPatch/opatch napply -oh <ORACLE_HOME> -local <UNZIPPED_PATCH_LOCATION>/12419331 10.Run the post script for DB component of the patch. As the database home owner execute: $<UNZIPPED_PATCH_LOCATION>/12419353/custom/server/12419353/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME> 11.Run the post script. As the root user execute: #<GI_HOME>/rdbms/install/rootadd_rdbms.sh If this is a GI Home, as the root user execute: #<GI_HOME>/crs/install/rootcrs.pl -patch If this is an Oracle Restart Home, as the root user execute: #<GI_HOME>/crs/install/roothas.pl -patch 12.Start the CRS managed resources that were earlier running from DB homes. If this is a GI Home environment, as the database home owner execute: $<ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location> -n <node name> If this is an Oracle Restart Home environment, as the database home owner execute: $<ORACLE_HOME>/bin/srvctl start home -o <ORACLE_HOME> -s <status file location>
readme里面的OCM Configuration是什么意思啊?你的好像没有执行怎么就行?
Patch the GI home.
On local node, as root user, execute the following command:
# opatch auto -oh
这步我的报错,说是配置没有弄好,想问问怎么配置才对?
”Patch 12419353: GI PSU 11.2.0.2.3 (INCLUDES DATABASE PSU 11.2.0.2.3)“
database psu也包括了吗?
打了GI PSU之后,DATABASE PSU也一起打上了吗?
比如11.2.0.3最新的PSU:
补丁程序14275605: DATABASE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES CPUOCT2012)
补丁程序14275572: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.4 (INCLUDES DB PSU 11.2.0.3.4)
怎么打PSU