Extra fixes on top of 10.2.0.4 for Linux 64 bit

This pages is intended to keep track of patches and bugs on top of 10.2.0.4 for 3D databases, CERN and T1s. See also DBA_issues_log

Patches of current interest, tested at T0

• Bundle of rolling patches applied with APR09 CPU
  • note all these patches are rolling:
  • rolled back patches: rollback -local -id 7331323 4693355 7219752
  • Bug 7715304 10.2.0.4 CRS Recommended Patch Bundle #3
  • Bug 8344348 10.2.0.4 RAC Recommended Patch Bundle #3
    • (note because of conflicts only the following was applied) $ORACLE_HOME/OPatch/opatch napply -local -id 5259835,5348308,5879114,6052226,6163771,6200820,7378661,7552067,7606362,8340379,8344348,8347704
  • Bug 7936993 10.2.0.4 Data Guard Physical Recommended Patch Bundle #1
  • Bug 8362683 10.2.0.4 Generic Recommended Patch Bundle #4
  • merge patch: 8374653 MERGE LABEL REQUEST ON TOP OF 10.2.0.4 FOR BUGS 7219752 8338727
  • patch 7225720 ASM DOES NOT CLOSE OPEN DESCRIPTORS EVEN AFTER APPLYING THE PATCH 4693355
  • patch 7257461 ORA-16146 DURING BLOCK MEDIA RECOVERY ON A PRIMARY WITH NO STANDBY DESTINATION
  • patch 6079224 Recommended on Linux: RAC ORA-27506 / IPC Send timeout
  • patch 6402302 DROP SYNONYM DDL IS NOT CAPTURED/PROPAGATED OR APPLIED

• Bundle of rolling patches applied with JAN09 CPU
  • RHEL4 U7 kernel 2.6.9-78.0.8
  • 4693355 ASM does not close open descriptors even after DROP DISKGROUP (rolling)
  • 6351293 SQL may execute in wrong schema when using database links (rolling)
  • 6452375 ORA-26687 NO INSTANTIATION SCN PROVIDED WHEN DROP CHILD TABLE (rolling)
  • 6827260 EXCESSIVE MEMORY USAGE FOR LCR CACHE DUE TO LARGE FREELISTS (rolling)
  • 6981690 asm issue on standby DB (rolling)
  • 7033630 an APPLY patch (rolling)
  • 7219752 ORA-26773 MALFORMED REDO ON CAPTURE OF LONG (rolling)
  • 7232072 a CDC Patch (rolling)
  • 7331323 oracle recommended patch - ORA-27302 FAILURE OCCURRED AT SKGXPVFYMMTU (rolling)
  • 5386204 oracle recommended patch - ORA-600 [KDDUMMY_BLKCHK] ERRORS WITH CODE 18038 (rolling)
  • 7493592 CRS 10.2.0.4 Bundle Patch #2:
  • 7573282 - 10.2.0.4 RAC RECOMMENDED BUNDLE #2 (rolling)
  • 7592346 CPU JAN09 (rolling)
  • 7612639 - 10.2.0.4 GENERIC RECOMMENDED BUNDLE# 3 (rolling) (only the following id are installed, as 2 patches are in conflit with the rest: -id 5868257,6327692,6455659,6678845,6972843,7008262,7123643,7189447,7272297,7278117,7612639)
  • set the NUMA parameter OFF as recommended in Metalink Note 555579.1, 10.2.0.4 Patch Set - Availability and Known Issues

    alter system set "_enable_NUMA_optimization"=FALSE scope=spfile sid='*';
    alter system set "_db_block_numa"=1 scope=spfile sid='*';
            

• Streams patches
  • see StreamsPatches
  • in particular the patch for apply: 7033630 APPLY ABORTING WITH ORA-600 (non-rolling)
• ORA-600, ASSM level 1 block corruption, with instance crash, (rare occurrance, requires simultaneous extending TBS and segment + db_block_checking or db_block_checksum -> result crash (found in Castor atlas stager once)
  • Apply Patch 6647480 fixes this, available and rolling
  • We are interested in the merge patch between 7046187 and 6647480 (work in progress as of 20-3-2009
• CSS diagwait
  • not rolling, not highly critical but recommended by Oracle. Applied on PDB production at CERN.
  • =crsctl set css diagwait 13 -force =
  • recommended by Oracle (at present) since the introduction of OPROCD on Linux. Note:567730.1
• Older patches/bundles
  • patch 6746196, QUERY FAILING WITH ORA-942 WHEN OBJECT EXISTS (rolling)
  • CPU OCT08 (rolling)
  • CRS and glibc issues with RHEL4 U6
  • update to RHEL4 U7 (2.6.9-78.0.1 or higher)
  • CRS bundle for 10.2.0.4#1: 7164095 (rolling)

Other patches and bugs found/reported/yet in testing

• Bug 7331323 - ORA-27302: FAILURE OCCURRED AT: SKGXPVFYMMTU
  • reported by BNL, caused an ASM crash
• BUG. 6763804, root.sh replaced by 2 lines that run rootadd.sh
  • reported by BNL, work around published by Oracle in Critical Patch Update October 2008 Database Known Issues Doc ID: 735219.1