SAP Database Administration with Oracle

27.05.2008

Englisch

9781592291205

Rheinwerk Publishing

SAP PRESS Englisch

Nein

André Faustmann

818

1

Gebundene Ausgabe

Oracle, SAP Oracle, Database, DBMS, Administration

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

240 mm

16.8 cm