SAP Database Administration with Oracle

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
... A.1 SQL Script for Creating the Database ... 789
... A.2 Perl Script for Generating the Database Content ... 790
... B General Options of the BR*Tools ... 791
... B.1 Functions of BRSPACE ... 791
... B.2 Functions of BRARCHIVE ... 792
... B.3 Functions of BRCONNECT ... 793
... B.4 Functions of BRBACKUP ... 794
... B.5 Functions of BRRESTORE ... 795
... B.6 Functions of BRRECOVER ... 796
... C References ... 797
... D Authors ... 799

Index ... 801