
SAP Database Administration with Oracle
SAP PRESS
1st Edition
Published on 28. March 2008
Book
Hardback
818 pages
978-1-59229-120-5 (ISBN)
Description
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.
More details
Series
Language
English
Place of publication
Bonn
Germany
Target group
College/higher education
Professional and scholarly
Edition type
New edition
Dimensions
Height: 24 cm
Width: 16.8 cm
ISBN-13
978-1-59229-120-5 (9781592291205)
Schweitzer Classification
Persons
Author
André Faustmann is a certified SAP consultant and holds a teaching position at the University Competence Center in Magdeburg.
Michael Höding is a professor for databases at the University of Applied Sciences in Brandenburg.
Gunnar Klein is a certified SAP consultant and holds a teaching position at the University Competence Center in Magdeburg.
Ronny Zimmermann is a certified SAP consultant and holds a teaching position at the University Competence Center in Magdeburg.
Content
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
... 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