Year: 2008
Author: Michael Hoding, Andre Faustmann, Gunnar Klein, and Ronny Zimmermann
Publisher: Galileo Press
ISBN: 978-1-59229-120-5
Language: English
Format: PNG
Number of pages: 818
This book provides administrators with essential information on Oracle databases as well as their interaction with SAP systems. First, you'll learn how best to plan or extend an effective, secure system landscape. The authors show you how to analyze and optimize the performance of hardware, operating system, database, and SAP system as well as which parameters and tools you can use to monitor them. An entire chapter deals with the critical aspects of backup, recovery, and restore, describing different data backup concepts, BR*Tools, the Oracle Recovery Manager, and various backup strategies in detail. In addition, the authors tackle advanced topics, such as Java and SAP NetWeaver BI.
By bridging the gap between basic background knowledge and real-life instruction, this book assists you in solving concrete administration problems, structuring the operation of your system to achieve higher performance, and improving data security and availability.
Highlights
- Interaction between SAP and Oracle
- Planning and Extending the System Landscape
- System Lifecycle: Installation,
- System Maintenance, Upgrades
- Performance: Analysis of Hardware,
- Operating System, Database, SAP
- System, SQL Statements, and much more
- Backup, Recovery, and Restore:
- Data Backup Concepts, BR*Tools,
- Oracle Recovery Manager, Backup Strategies
- Oracle and SAP NetWeaver BI
- Includes a detailed quick-reference card with all of the most important transaction codes
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
Michael Höding is Professor of Information Management at the Brandenburg University of Applied Sciences, Germany, and played a decisive role in setting up the SAP University Competence Center (SAP UCC) in Magdeburg, Germany. André Faustmann and Ronny Zimmermann work at the SAP UCC, and Gunnar Klein is part of the SAP Basis team for T-Systems. All four authors are certified SAP Consultants.
http://www.sap-press.com/products/SAP-Database-Administration-with-Oracle.html
Download File Size:94.21 MB
|
