SAP Database Administration with Oracle

Oracle is one of the most significant, but also one of the most complex, DB platforms available for SAP systems---so why hasn't someone written a book on how to configure the interaction? Well, here it is: With this in-depth reference book, administrators get much needed background knowledge, as well as complete details on architectural and software/logistics issues, in addition to step-by-step instructions for all of the most important administration tasks. Every aspect of system landscape planning and maintenance is covered, helping administrators hone their problem solving skills. Bonus chapters deal with Java, SAP NetWeaver BI, and the highly complex issues of Backup, Recovery, and Restoration.

André Faustmann is a certified SAP consultant and holds a teaching position at the University Competence Center in Magdeburg.

1 Introduction ... 15 ... 1.1 Reasons for Owning This Book ... 16 ,,, 1.2 Tasks of the SAP Basis ... 18 ,,, 1.3 Structure of This Book ... 19 ,,, 1.4 Conventions and Other Information ... 23 ,,, 1.5 Acknowledgments ... 24 2 SAP Fundamentals ... 27 ... 2.1 Overview of the SAP Software ... 27 ... 2.2 Architecture and Scalability ... 35 ... 2.3 Application Server ... 37 ... 2.4 SAP Administration ... 50 ... 2.5 SAP and Software Development ... 56 ... 2.6 Summary ... 63 3 Oracle Fundamentals ... 65 ... 3.1 Basics of Database Technology ... 65 ... 3.2 Development of Oracle ... 81 ... 3.3 Tools for the Oracle Administrator ... 84 ... 3.4 Oracle Kernel ... 89 ... 3.5 Summary ... 147 4 SAP and Oracle ... 149 ... 4.1 Processes of SAP and Oracle Systems ... 150 ... 4.2 Requirements at the Operating System Level ... 173 ... 4.3 Authentication Between SAP and Oracle ... 190 ... 4.4 SAP Tablespaces ... 202 ... 4.5 Administrating Oracle with the BR*Tools ... 216 ... 4.6 Summary ... 240 5 Planning the System Landscape ... 243 ... 5.1 From Product to Solution Landscape ... 243 ... 5.2 Overview of Planning Criteria ... 245 ... 5.3 High Availability ... 263 ... 5.4 IT and System Security ... 267 ... 5.5 Extending an Existing Landscape ... 274 ... 5.6 Summary ... 276 6 SAP Change and Transport Management ... 277 ... 6.1 Standard Software and Changes to the Standard ... 278 ... 6.2 Basic Principles of Software Logistics ... 280 ... 6.3 Change Management for Customizing Settings ... 309 ... 6.4 Change Management for Developments ... 313 ... 6.5 Transport Management ... 318 ... 6.6 Tips and Tricks ... 338 ... 6.7 Summary ... 339 7 System Lifecycle ... 341 ... 7.1 Installation ... 341 ... 7.2 System Maintenance ... 357 ... 7.3 Upgrades ... 386 ... 7.4 Summary ... 404 8 Performance ... 405 ... 8.1 Administrative and Program-Based Problems ... 406 ... 8.2 Analyzing Administrative Performance Problems ... 408 ... 8.3 Analyzing Program-Based Performance Problems: SQL Optimization ... 473 ... 8.4 Summary ... 492 9 System Operation and Monitoring ... 495 ... 9.1 Monitoring in the SAP Environment: Motivation and Scope ... 495 ... 9.2 Parameters for Monitoring an SAP System Based on Oracle ... 502 ... 9.3 Background Jobs in the Scope of Monitoring ... 538 ... 9.4 Summary ... 544 10 Backup, Restore, and Recovery ... 545 ... 10.1 What Must Be Backed Up? ... 547 ... 10.2 Data Backup Methods ... 561 ... 10.3 Recovery Methods ... 568 ... 10.4 BR*Tools for Backup, Restore, and Recovery ... 579 ... 10.5 Oracle Recovery Manager (RMAN) ... 622 ... 10.6 Other Error Scenarios ... 629 ... 10.7 Backup Strategies ... 649 ... 10.8 Tips and Tricks ... 665 ... 10.9 Summary ... 666 11 Administrating the Java Stack ... 669 ... 11.1 Using Java in SAP Systems ... 670 ... 11.2 Architecture of the J2EE Engine ... 673 ... 11.3 Java Software Logistics ... 705 ... 11.4 Tips and Tricks ... 714 ... 11.5 Summary ... 720 12 SAP NetWeaver BI and Oracle ... 723 ... 12.1 Basics and Concepts of Data Warehousing ... 723 ... 12.2 Data Warehousing with Oracle ... 733 ... 12.3 SAP NetWeaver BI: An Overview ... 742 ... 12.4 SAP NetWeaver BI on Oracle ... 765 ... 12.5 Summary ... 782 13 Afterword and Outlook ... 785 Appendix ... 787 ... A Flight Data Model ... 789 ...