• Applying 11G R2 GI PSU 11.2.0.2.3


    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> 
    
    
  • 相关阅读:
    数据表列名与数据库关键字冲突,在Hibernate下的解决办法
    Ubuntu12.04 MySQL服务器乱码问题的解决办法
    Linux实时将所有输出重定向到文件
    vue Element UI 导航高亮
    Js计算时间差
    Js时间处理
    Vue设置导航栏为公共模块并在登录页不显示
    Vue中表单校验
    Vue中div高度自适应
    Vue引入js、css文件
  • 原文地址:https://www.cnblogs.com/macleanoracle/p/2967913.html
Copyright © 2020-2023  润新知