Solution : https://service.sap.com/sap/support/notes/817262 (SAP Service marketplace login required)
Summary :
This SAP Hot News note highlights issues with Oracle 9.2.0.5 on HP platforms HP-UX PA-RISC and HP-UX IA64, indicating that these are the only affected systems due to compiler behavior differences. Other platforms, including Windows, show no data corruption. The note includes specific prerequisites, like using Oracle 9.2.0.5 and operating with ASSM in tablespaces installed via sapinst with Kernel 6.40. For remediation, it details patches available for both Oracle 9.2.0.5 and 9.2.0.6 specifically for affected HP platforms, alongside instructions for applying patches and scripts to verify and repair potentially corrupt database segments.
Key words :
ziphp-ux ia64 /oracle/oracle 64-bit/oracle 9, hp platforms hp-ux pa-risc, analyze table validate structure cascade, sql @$oracle_home/rdbms/admin/prvtspad, 64-bit/ hp_ia64/p4138615_9205_hpux-ia64, 64-bit/ hp_ia64/p4131045_9206_hpux-ia64, @$oracle_home/rdbms/admin/dbmsspc, 5 64-bit/ hp-ux_64/p4138615_9205_hp64, 6 64-bit/ hp-ux_64/p4131045_9206_hp64, trace file requires approximately 5 ~ 6 mb
Related Notes :
| 830965 | VBDATA, DDLOG: size and increase in size |
| 764015 | Segment corruption in ASSM tablespace |
| 23345 | Consistency check of ORACLE database |