Key Notes for SAP on Oracle

Make sure you read these key SAP notes for SAP on Oracle (you need SAP Service Marketplace access):


Hot News


SAP Note   Description
1915485Wrong results on Oracle Index Organized Table (IOTs)
1847870Oracle 11g: Advanced Compression - Known issues and solution
1654734Extended Support contract required for 10.2.0.5 PSU and SBP
163693611g Wrong results with star_transformation_enabled = true
1621425Wrong results with Temp Table Transformation
1620527 Veritas Filesystem: Block corruption with large LUNs
1616131 Oracle 11g: ORA-600/corruption possible during shutdown RAC
1589777Missing owner in menu "System -> Status"
1581715Wrong Results after ALTER TABLE ADD column + Index-only Join
1547676Wrong results from CARTESIAN product w. Star transformation
1514200Possible dataloss after long to lob conversion
1471817ASSM LOB segment corrupt after manual allocate extent
1413928Index corruption/wrong results after rebuild index ONLINE
1375124Possible wrong values if group by and views
1368640Oracle 10g: Array Update can corrupt a row
1355935DBMS_STATS calculated wrong distinct keys with patch 7434973
1351737Oracle 10.2.0.4: Table Prefetching causes Wrong Results
1339724Oracle 10.2 Extended Support free until July 31, 2011
1336810Wrong Result When Using DBMS_REDEFINITION in RAC environment
941369Upgrade of notes 738979 and 753876 to higher releases
1257511Oracle 10.2.0.4 - Wrong Results Unless Ansi Outer Join Used
1248584Oracle 10.2.0.4 - Wrong results possible from predicate push
1246629Discontinuing "Customer Care Support" for Oracle 10.1
1012607SQL/runtime error when writing/activating DataStore
1244076    kkp* Merge Fix for Oracle 10.2.0.4
1174491    J2EE: Data corruption with Oracle JDBC lower than 10.2.0.4 and JVM 5.0
1144178Invalid Float Values
977319Incorrect values in Oracle 10.2 (II)
1136063Oracle Direct Path Load leads to block corruptions in ASSM
1135589IOT Corruptions a. Upgrade from COMPATIBLE  <= 9.2 to >= 10.1
1126517ORA-1445 or incorrect values with 10.2
1107700Execution of SQL Statements in Wrong Schema
1040300Wrong values with Star Transformation Hint 9.2.0.8 /10.2.0.2
1003198J2EE: Incorrect data with Oracle10g JDBC lower than 10.2.0.4
1021844Oracle 9.2 Extended Support free until July 31, 2008
1028068Required Oracle options for the DBA Cockpit
1039393DATAPUMP creates corruptions in tables with LONG
1013476ORA-600 kcbzpbuf_1 during array insert causes corruption
980805ORA-600 kdtigetrow-2 w/ array insert leads to corruptions
985118Wrong values when you execute parallel queries
1021454Oracle Segment Shrinking may cause LOB corrupt data


Top Notes for Oracle 11g


SAP NoteDescription
971645 6.40 Patch Collection Hom./Het.System Copy Java
9716466.40 Patch Collection Hom./Het.System Copy ABAP
1478350 Oracle 11g Support on UNIX: 7.0/7.01-Based SAP Systems
1478060 Oracle 11g Support on Windows: SAP NW 7.-Based Systems
1478351 Oracle 11g Support on UNIX: 6.40-Based SAP Systems
1478059 Oracle 11g Support on Windows: 6.40-Based SAP Systems
1499877 Oracle 11.2 for R/3 Enterprise 4.7 Ext. Set 1.10
1431800 Oracle 11.2.0: Central Technical Note
1398634 Oracle database 11g: Integration in SAP environment
1431798 Oracle 11.2.0: Database Parameter Settings
1431796 Oracle 11.2.0: Troubleshooting the Software Installation
1431797 Oracle 11.2.0: Troubleshooting the Database Upgrade
1431799 Oracle 11.2.0: Current Patch Set
1431793 Oracle 11.2.0: Upgrade Scripts
1430669 BR*Tools support for Oracle 11g                                                                     


Top Notes for Oracle 10g


SAP NoteDescription
839187 Oracle 10.2.0: Applying patch set/patches/patch collection
720886 Oracle Database 10g: Integration into the SAP environment
940794 Releasing Oracle 10.2 versions for older SAP versions
527843 Oracle RAC support in the SAP environment
841728 Oracle Database 10g: Software installation problems 10.2.0
871096 Oracle Database 10g: Patch sets/patches for 10.2.0
834917 Oracle Database 10g: New database role SAPCONN
819829 Oracle Database 10g: Instant Client 10.x on Unix
998004 Update the Oracle Instant Client on Windows
830576 Parameter recommendations for Oracle 10g
819655 Add. info.: Upgrade to SAP NW 2004s ABAP ORACLE


Top Notes for BR*Tools

SAP NoteDescription
1125923Support for Oracle database flashback in BR*Tools
1279682Support for Oracle data encryption in BR*Tools
1259767Management of online redo log files using BRSPACE
1050329BR*Tools fails with ORA-01455 when database exceeds 16 TB
1033126BR*Tools support for Oracle 10g RAC
1033125  Managing database statistics with BRSPACE
1016173Verifying database and archive log files using RMAN
1016172Sorting table records during reorganization
1003028Enhanced support for system copy in BR*Tools
976435Support for Oracle Data Pump in BRSPACE
968507Considerable enhancements to backups using BR*Tools 7.00
936665BR*Tools support for MDM database
914174Minor functional enhancements in BR*Tools
912969BR*Tools 7.00 fails due to license problems
900905Creating tablespaces with UNIFORM SIZE using BRSPACE
892296Enhancements in statistics collection in BRCONNECT 7.00/7.10
892294Extended support of non-ABAP database in BRCONNECT 7.00
874912Displaying extended database disk volume space in BRSPACE
865366Changes in relation to collecting statistics for partitions
865365Placeholder support in BRCONNECT parameters
849485Reconstruction of the NOLOGGING indexes after recovery
849484New CRITICAL_TABLESPACE check condition in BRCONNECT
849483Corrections for BR*Tools Version 7.00


Top Notes for Oracle Database Interface


SAP NoteDescription
1047369 Faster DB accesses for R3szchk using Oracle DBSL
978710 Transferring UP TO n ROWS with FIRST_ROWS(n) hint
902042  DBSL: Hint und Profil-Parameter für "substitute literals"
832893 Oracle release check in DbSl
808505 Secondary connection to Oracle DB w/ different character set
797792 R/3 Reconnect after various Oracle error codes


Miscellaneous Notes


SAP NoteDescription
1575609Future HPUX support for SAP on Oracle databases
1174136Oracle: End of Support Dates
1179765AIX: End of Support Dates
1174175HP-UX: End of Support Dates
1174174Solaris: End of Support Dates
1174176Tru64: End of Support Dates
1177282Windows: End of Support for SAP Releases

1 comment:

Unknown said...

This is a tremendous article that you simply have written. I actually have continually liked beingness. The site content fades before long.
The beingness because the name says stand the check. Joyful to browse this web log.
sap hana online training